APPS.PJI_FM_PLAN_MAINT dependencies on PA_VARCHAR2_1_TBL_TYPE

Line 630: l_tar_denorm_exists_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

626: l_wbs_tar_struct_version_id pa_budget_versions.project_structure_version_id%TYPE;
627: l_return_status VARCHAR2(1) ;
628:
629: -- Avoid re-populating pa/pji denorm tables if denorm definition already exists.
630: l_tar_denorm_exists_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
631:
632: l_wbs_tar_wvi_valid_tbl SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
633: l_src_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
634: l_tar_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

Line 1086: l_wp_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

1082: , p_commit IN VARCHAR2 := 'F') IS
1083:
1084: l_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
1085: l_wbs_version_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
1086: l_wp_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
1087:
1088: BEGIN
1089:
1090: print_time('DELETE_ALL_PVT: begin.. ');