DBA Data[Home] [Help]

APPS.PA_TOP_TASK_CUST_INVOICE_PVT dependencies on PA_NUM_TBL_TYPE

Line 292: -- p_exclude_cust_id_tbl SYSTEM.PA_NUM_TBL_TYPE N Customer IDs to be excluded while fetching highest contrib

288: -- Parameters Type Required Description and Purpose
289: -- --------------------------- ------ -------- --------------------------------------------------------
290: -- p_project_id NUMBER Y Project ID for which highest contribution customer is
291: -- to be returned
292: -- p_exclude_cust_id_tbl SYSTEM.PA_NUM_TBL_TYPE N Customer IDs to be excluded while fetching highest contrib
293: -- customer (Required during customer deletion)
294: -- x_highst_contr_cust_id NUMBER N Customer ID of the highest contribution customer
295: -- x_highst_contr_cust_name VARCHAR2 N Customer Name of the highest contribution customer
296: -- x_highst_contr_cust_num VARCHAR2 N Customer Number of the highest contribution customer

Line 326: l_return_cust_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

322: l_debug_level3 CONSTANT NUMBER := 3;
323: l_debug_level4 CONSTANT NUMBER := 4;
324: l_debug_level5 CONSTANT NUMBER := 5;
325:
326: l_return_cust_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
327: l_return_cust_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
328: l_return_cust_num_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
329: l_return_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
330: