APPS.PA_PURGE_PUB dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 465: l_fi_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

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;
469: l_debug_level3 NUMBER := 3;

Line 871: l_wf_item_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE ();

867: x_msg_count OUT NOCOPY NUMBER ,
868: x_msg_data OUT NOCOPY VARCHAR2
869: )
870: IS
871: l_wf_item_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE ();
872: l_wf_item_key_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE ();
873: l_wf_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE ();
874: l_debug_level3 NUMBER := 3;
875: i NUMBER;

Line 873: l_wf_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE ();

869: )
870: IS
871: l_wf_item_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE ();
872: l_wf_item_key_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE ();
873: l_wf_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE ();
874: l_debug_level3 NUMBER := 3;
875: i NUMBER;
876: l_rows1 NUMBER := 0;
877: l_rows2 NUMBER := 0;

Line 1789: l_table_name_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

1785: WHERE purge_batch_id = p_request_id
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