DBA Data[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on PA_PLSQL_DATATYPES

Line 19384: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;

19380:
19381: l_return_status VARCHAR2(10);
19382: l_msg_count NUMBER := 0;
19383: l_msg_data VARCHAR2(2000);
19384: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
19385: BEGIN
19386: -- l_exclude_cust_id_tbl(1) := 0; Bug 5622539
19387: --Retrieve the customer to be set as the default top task customer
19388: pa_top_task_cust_invoice_pvt.Get_Highest_Contr_Cust(

Line 19482: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;

19478: hghst_ctr_cust_id NUMBER;
19479: hghst_ctr_cust_name hz_parties.party_name%TYPE; --VARCHAR2(50); Bug 5622539
19480: hghst_ctr_cust_num hz_parties.party_number%TYPE; --VARCHAR2(30); Bug 5622539
19481: -- num_customers NUMBER := 0; bug 5622539
19482: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
19483:
19484: l_return_status VARCHAR2(10);
19485: l_msg_count NUMBER := 0;
19486: l_msg_data VARCHAR2(2000);

Line 20948: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;

20944:
20945: l_return_status VARCHAR2(10);
20946: l_msg_count NUMBER := 0;
20947: l_msg_data VARCHAR2(2000);
20948: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
20949: BEGIN
20950: l_exclude_cust_id_tbl(1) := 0;
20951: --Retrieve the customer to be set as the default top task customer
20952: pa_top_task_cust_invoice_pvt.Get_Highest_Contr_Cust(

Line 21004: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;

21000: hghst_ctr_cust_id NUMBER;
21001: hghst_ctr_cust_name VARCHAR2(50);
21002: hghst_ctr_cust_num VARCHAR2(30);
21003: num_customers NUMBER := 0;
21004: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
21005:
21006: l_return_status VARCHAR2(10);
21007: l_msg_count NUMBER := 0;
21008: l_msg_data VARCHAR2(2000);

Line 21067: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;

21063: --sunkalya:federal changes bug#5511353
21064:
21065: DECLARE
21066: hghst_ctr_cust_id NUMBER;
21067: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
21068: l_return_status VARCHAR2(10);
21069: l_msg_count NUMBER := 0;
21070: l_msg_data VARCHAR2(2000);
21071: