eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_FM_PLAN_MAINT dependencies on PA_NUM_TBL_TYPE

Line 23: , p_tar_denorm_not_exists_tbl IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

19: -- Populate wbs denorm table for plan create case.
20: --
21: PROCEDURE POPULATE_WBS_DENORM(
22: p_online IN VARCHAR2 := 'Y'
23: , p_tar_denorm_not_exists_tbl IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
24: , x_return_status OUT NOCOPY VARCHAR2
25: );
26:
27:

Line 53: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

49: --
50: PROCEDURE SEC_SLICE_CREATE_T;
51:
52: PROCEDURE CHECK_PRIMARY_ALREADY_EXISTS (
53: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
54: , p_is_primary_rbs IN VARCHAR2
55: , x_return_status OUT NOCOPY VARCHAR2 );
56:
57: --

Line 63: p_tar_wbs_version_id_tbl IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

59: -- denorm definition already exists, function checks if denorm definition
60: -- exists.
61: --
62: PROCEDURE DENORM_DEFINITION_EXISTS(
63: p_tar_wbs_version_id_tbl IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
64: , x_tar_denorm_not_exists_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
65: );
66:
67: --

Line 64: , x_tar_denorm_not_exists_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

60: -- exists.
61: --
62: PROCEDURE DENORM_DEFINITION_EXISTS(
63: p_tar_wbs_version_id_tbl IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
64: , x_tar_denorm_not_exists_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
65: );
66:
67: --
68: -- Performance tuning and debug api.

Line 80: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

76: ------------------------------------------------------------------
77:
78:
79: PROCEDURE MAP_RESOURCE_LIST (
80: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
81: , p_context IN VARCHAR2 := 'BULK') IS
82:
83: l_return_status VARCHAR2(1) := NULL;
84: l_msg_count NUMBER := NULL;

Line 592: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

588: -- p_copy_mode -> If NULL, denorm table is created based on task relationships
589: -- If NOT NULL, denorm table is created based denorm copy of source structure
590: --
591: PROCEDURE CREATE_PRIMARY_PVT(
592: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
593: , p_is_primary_rbs IN VARCHAR2 -- Valid values are T/F.
594: , p_commit IN VARCHAR2 := 'F'
595: , p_fp_src_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
596: , p_Copy_mode IN VARCHAR2 :=NULL

Line 595: , p_fp_src_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

591: PROCEDURE CREATE_PRIMARY_PVT(
592: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
593: , p_is_primary_rbs IN VARCHAR2 -- Valid values are T/F.
594: , p_commit IN VARCHAR2 := 'F'
595: , p_fp_src_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
596: , p_Copy_mode IN VARCHAR2 :=NULL
597: ) IS
598:
599: CURSOR c_src_struct_version_id (

Line 632: l_wbs_tar_wvi_valid_tbl SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

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;
635: l_tar_denorm_not_exists_tbl SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
636:

Line 633: l_src_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

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;
635: l_tar_denorm_not_exists_tbl SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
636:
637: l_src_pln_ver_id NUMBER;

Line 634: l_tar_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

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;
635: l_tar_denorm_not_exists_tbl SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
636:
637: l_src_pln_ver_id NUMBER;
638:

Line 635: l_tar_denorm_not_exists_tbl SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

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;
635: l_tar_denorm_not_exists_tbl SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
636:
637: l_src_pln_ver_id NUMBER;
638:
639: BEGIN

Line 825: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

821: END;
822:
823:
824: PROCEDURE CREATE_SECONDARY_PVT(
825: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
826: , p_commit IN VARCHAR2 := 'F'
827: , p_process_all IN VARCHAR2 := 'F') IS
828:
829: l_count NUMBER;

Line 890: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

886: END;
887:
888:
889: PROCEDURE CREATE_SECONDARY_T_PVT(
890: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
891: , p_commit IN VARCHAR2 := 'F'
892: , p_process_all IN VARCHAR2 := 'F') IS
893:
894: l_return_status VARCHAR2(1);

Line 964: p_plan_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

960: END;
961:
962:
963: PROCEDURE UPDATE_PRIMARY_PVT (
964: p_plan_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
965: -- p_plan_version_id IN NUMBER := NULL
966: , p_commit IN VARCHAR2 := 'F'
967: )
968: IS

Line 969: -- l_plan_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(p_plan_version_id);

965: -- p_plan_version_id IN NUMBER := NULL
966: , p_commit IN VARCHAR2 := 'F'
967: )
968: IS
969: -- l_plan_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(p_plan_version_id);
970: BEGIN
971:
972: print_time('UPDATE_PRIMARY_PVT: begin.. ');
973:

Line 1036: l_fp_version_ids SYSTEM.pa_num_tbl_type;

1032: , p_prev_pub_version_id IN NUMBER := NULL
1033: , x_return_status OUT NOCOPY VARCHAR2
1034: , x_processing_code OUT NOCOPY VARCHAR2) IS
1035:
1036: l_fp_version_ids SYSTEM.pa_num_tbl_type;
1037:
1038: BEGIN
1039:
1040: print_time ( 'UPDATE_PRIMARY_PVT_ACT_ETC: begin.. ');

Line 1081: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

1077: END;
1078:
1079:
1080: PROCEDURE DELETE_ALL_PVT (
1081: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
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;

Line 1084: l_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

1080: PROCEDURE DELETE_ALL_PVT (
1081: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
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

Line 1085: l_wbs_version_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

1081: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
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:

Line 1293: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

1289: END;
1290:
1291:
1292: PROCEDURE CHECK_PRIMARY_ALREADY_EXISTS (
1293: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
1294: , p_is_primary_rbs IN VARCHAR2
1295: , x_return_status OUT NOCOPY VARCHAR2 ) IS
1296: i NUMBER;
1297: l_project_id NUMBER;

Line 1349: p_tar_wbs_version_id_tbl IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

1345: -- denorm definition already exists, function checks if denorm definition
1346: -- exists.
1347: --
1348: PROCEDURE DENORM_DEFINITION_EXISTS(
1349: p_tar_wbs_version_id_tbl IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
1350: , x_tar_denorm_not_exists_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
1351: ) IS
1352:
1353: CURSOR c_wbs_vers_exist IS

Line 1350: , x_tar_denorm_not_exists_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

1346: -- exists.
1347: --
1348: PROCEDURE DENORM_DEFINITION_EXISTS(
1349: p_tar_wbs_version_id_tbl IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
1350: , x_tar_denorm_not_exists_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
1351: ) IS
1352:
1353: CURSOR c_wbs_vers_exist IS
1354: SELECT DISTINCT wbs_struct_version_id

Line 1364: l_tar_wbs_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1360: AND struct_version_id IS NULL
1361: AND sup_id = ver3.wbs_struct_version_id
1362: );
1363:
1364: l_tar_wbs_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1365: l_tar_denorm_not_exists_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1366: l_tar_wbs_ver_id1 NUMBER;
1367: l_tar_wbs_ver_id2 NUMBER;
1368:

Line 1365: l_tar_denorm_not_exists_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1361: AND sup_id = ver3.wbs_struct_version_id
1362: );
1363:
1364: l_tar_wbs_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1365: l_tar_denorm_not_exists_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1366: l_tar_wbs_ver_id1 NUMBER;
1367: l_tar_wbs_ver_id2 NUMBER;
1368:
1369: BEGIN

Line 1450: , p_tar_denorm_not_exists_tbl IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

1446: -- Populate wbs denorm table for plan create case.
1447: --
1448: PROCEDURE POPULATE_WBS_DENORM(
1449: p_online IN VARCHAR2 := 'Y'
1450: , p_tar_denorm_not_exists_tbl IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
1451: , x_return_status OUT NOCOPY VARCHAR2
1452: ) IS
1453:
1454: CURSOR c_wbs_struct_ver_id_online (