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 1172: l_request_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE ();

1168: x_msg_count OUT NOCOPY NUMBER ,
1169: x_msg_data OUT NOCOPY VARCHAR2
1170: )
1171: IS
1172: l_request_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE ();
1173: l_debug_level3 NUMBER :=3;
1174: l_rows1 NUMBER :=0;
1175: l_msg_data VARCHAR2(2000);
1176: l_data VARCHAR2(2000);

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

1805: AND project_id = 0
1806: ORDER BY table_name ;
1807:
1808: l_table_name_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1809: l_rows_deleted_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1810: l_debug_mode VARCHAR2(1); -- 5201806
1811:
1812: BEGIN
1813: