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

922: END;
923:
924:
925: PROCEDURE CREATE_SECONDARY_T_PVT(
926: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
927: , p_commit IN VARCHAR2 := 'F'
928: , p_process_all IN VARCHAR2 := 'F') IS
929:
930: l_return_status VARCHAR2(1);

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

996: END;
997:
998:
999: PROCEDURE UPDATE_PRIMARY_PVT (
1000: p_plan_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
1001: -- p_plan_version_id IN NUMBER := NULL
1002: , p_commit IN VARCHAR2 := 'F'
1003: )
1004: IS

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

1001: -- p_plan_version_id IN NUMBER := NULL
1002: , p_commit IN VARCHAR2 := 'F'
1003: )
1004: IS
1005: -- l_plan_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(p_plan_version_id);
1006: BEGIN
1007:
1008: print_time('UPDATE_PRIMARY_PVT: begin.. ');
1009:

Line 1072: l_fp_version_ids SYSTEM.pa_num_tbl_type;

1068: , p_prev_pub_version_id IN NUMBER := NULL
1069: , x_return_status OUT NOCOPY VARCHAR2
1070: , x_processing_code OUT NOCOPY VARCHAR2) IS
1071:
1072: l_fp_version_ids SYSTEM.pa_num_tbl_type;
1073:
1074: BEGIN
1075:
1076: print_time ( 'UPDATE_PRIMARY_PVT_ACT_ETC: begin.. ');

Line 1117: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

1113: END;
1114:
1115:
1116: PROCEDURE DELETE_ALL_PVT (
1117: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
1118: , p_commit IN VARCHAR2 := 'F') IS
1119:
1120: l_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
1121: l_wbs_version_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

Line 1120: l_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

1116: PROCEDURE DELETE_ALL_PVT (
1117: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
1118: , p_commit IN VARCHAR2 := 'F') IS
1119:
1120: l_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
1121: l_wbs_version_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
1122: l_wp_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
1123:
1124: BEGIN

Line 1121: l_wbs_version_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

1117: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
1118: , p_commit IN VARCHAR2 := 'F') IS
1119:
1120: l_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
1121: l_wbs_version_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
1122: l_wp_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
1123:
1124: BEGIN
1125:

Line 1346: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

1342: END;
1343:
1344:
1345: PROCEDURE CHECK_PRIMARY_ALREADY_EXISTS (
1346: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
1347: , p_is_primary_rbs IN VARCHAR2
1348: , x_return_status OUT NOCOPY VARCHAR2 ) IS
1349: i NUMBER;
1350: l_project_id NUMBER;

Line 1402: p_tar_wbs_version_id_tbl IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

1398: -- denorm definition already exists, function checks if denorm definition
1399: -- exists.
1400: --
1401: PROCEDURE DENORM_DEFINITION_EXISTS(
1402: p_tar_wbs_version_id_tbl IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
1403: , x_tar_denorm_not_exists_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
1404: ) IS
1405:
1406: CURSOR c_wbs_vers_exist IS

Line 1403: , x_tar_denorm_not_exists_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

1399: -- exists.
1400: --
1401: PROCEDURE DENORM_DEFINITION_EXISTS(
1402: p_tar_wbs_version_id_tbl IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
1403: , x_tar_denorm_not_exists_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
1404: ) IS
1405:
1406: CURSOR c_wbs_vers_exist IS
1407: SELECT DISTINCT wbs_struct_version_id

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

1413: AND struct_version_id IS NULL
1414: AND sup_id = ver3.wbs_struct_version_id
1415: );
1416:
1417: l_tar_wbs_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1418: l_tar_denorm_not_exists_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1419: l_tar_wbs_ver_id1 NUMBER;
1420: l_tar_wbs_ver_id2 NUMBER;
1421:

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

1414: AND sup_id = ver3.wbs_struct_version_id
1415: );
1416:
1417: l_tar_wbs_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1418: l_tar_denorm_not_exists_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1419: l_tar_wbs_ver_id1 NUMBER;
1420: l_tar_wbs_ver_id2 NUMBER;
1421:
1422: BEGIN

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

1499: -- Populate wbs denorm table for plan create case.
1500: --
1501: PROCEDURE POPULATE_WBS_DENORM(
1502: p_online IN VARCHAR2 := 'Y'
1503: , p_tar_denorm_not_exists_tbl IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
1504: , x_return_status OUT NOCOPY VARCHAR2
1505: ) IS
1506:
1507: CURSOR c_wbs_struct_ver_id_online (