APPS.PA_PROJECT_PUB dependencies on PA_PLSQL_DATATYPES

Line 19782: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;

19778:
19779: l_return_status VARCHAR2(10);
19780: l_msg_count NUMBER := 0;
19781: l_msg_data VARCHAR2(2000);
19782: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
19783: BEGIN
19784: -- l_exclude_cust_id_tbl(1) := 0; Bug 5622539
19785: --Retrieve the customer to be set as the default top task customer
19786: pa_top_task_cust_invoice_pvt.Get_Highest_Contr_Cust(

Line 19880: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;

19876: hghst_ctr_cust_id NUMBER;
19877: hghst_ctr_cust_name hz_parties.party_name%TYPE; --VARCHAR2(50); Bug 5622539
19878: hghst_ctr_cust_num hz_parties.party_number%TYPE; --VARCHAR2(30); Bug 5622539
19879: -- num_customers NUMBER := 0; bug 5622539
19880: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
19881:
19882: l_return_status VARCHAR2(10);
19883: l_msg_count NUMBER := 0;
19884: l_msg_data VARCHAR2(2000);

Line 21349: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;

21345:
21346: l_return_status VARCHAR2(10);
21347: l_msg_count NUMBER := 0;
21348: l_msg_data VARCHAR2(2000);
21349: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
21350: BEGIN
21351: l_exclude_cust_id_tbl(1) := 0;
21352: --Retrieve the customer to be set as the default top task customer
21353: pa_top_task_cust_invoice_pvt.Get_Highest_Contr_Cust(

Line 21405: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;

21401: hghst_ctr_cust_id NUMBER;
21402: hghst_ctr_cust_name VARCHAR2(50);
21403: hghst_ctr_cust_num VARCHAR2(30);
21404: num_customers NUMBER := 0;
21405: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
21406:
21407: l_return_status VARCHAR2(10);
21408: l_msg_count NUMBER := 0;
21409: l_msg_data VARCHAR2(2000);

Line 21468: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;

21464: --sunkalya:federal changes bug#5511353
21465:
21466: DECLARE
21467: hghst_ctr_cust_id NUMBER;
21468: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
21469: l_return_status VARCHAR2(10);
21470: l_msg_count NUMBER := 0;
21471: l_msg_data VARCHAR2(2000);
21472: