SQL & PL/SQL

I am reading data from a Temp table created in a Temp schema on the database. I read this data with a cursor, pass it to a Procedure called PrCreatePerson which takes these local variables and in turn maps them to the p_person_rec and then calls the createPerson API. The API fails with the following error:

x_return_status = U
x_msg_count = 1
x_msg_data = The following SQL error occurred:
ORA-00942: table or view does not exist.

I have tested the cursor, it is reading the data correctly from the table
I have tested the procedure I created, the cursor is fetched into its variables correctly
Somehow API record p_person_rec is not being passed with its values to the API. Thanks.

I suspect it is because I haven't initialzed some variables. The question I
have is where in my current user responsibility do I find these variables.
My current org_ig
My user_id
My resp_id
My resp_appl_id
My login_id
My prog_appl_id
Please point me to any scripts, tables, schemas which I can use to determine my
current settings for the above values. Also plz note that I am executing the
APIs from the APPS schema. Thx.