APPS.PA_PURGE_PUB dependencies on PA_NUM_TBL_TYPE

Line 464: l_fi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

460: x_msg_data OUT NOCOPY VARCHAR2
461: )
462: IS
463:
464: l_fi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
465: l_fi_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
466: l_rows1 NUMBER :=0;
467: l_rows2 NUMBER :=0;
468: l_rows3 NUMBER :=0;

Line 1153: l_request_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE ();

1149: x_msg_count OUT NOCOPY NUMBER ,
1150: x_msg_data OUT NOCOPY VARCHAR2
1151: )
1152: IS
1153: l_request_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE ();
1154: l_debug_level3 NUMBER :=3;
1155: l_rows1 NUMBER :=0;
1156: l_msg_data VARCHAR2(2000);
1157: l_data VARCHAR2(2000);

Line 1790: l_rows_deleted_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

1786: AND project_id = 0
1787: ORDER BY table_name ;
1788:
1789: l_table_name_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1790: l_rows_deleted_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1791: l_debug_mode VARCHAR2(1); -- 5201806
1792:
1793: BEGIN
1794: