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_REP_UTIL dependencies on PA_NUM_TBL_TYPE

Line 82: PROCEDURE Log_Struct_Change_Event(p_wbs_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE) IS

78: Fnd_Message.set_name('PJI','PJI_REP_GENERIC_MSG');
79: Fnd_Message.set_token('PROC_NAME','Pji_Rep_Util.Add_Message');
80: END Add_Message;
81:
82: PROCEDURE Log_Struct_Change_Event(p_wbs_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE) IS
83: l_i NUMBER;
84: BEGIN
85:
86: IF g_debug_mode = 'Y' THEN

Line 154: l_proj_elem_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

150: l_prg_flag VARCHAR2(1);
151: l_project_id NUMBER;
152: l_relationship_type VARCHAR2(2);
153: l_element_version_id_str VARCHAR2(30);
154: l_proj_elem_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
155: l_complete_percents_tbl SYSTEM.PA_NUM_TBL_TYPE;
156:
157: l_proj_elem_ids_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;
158: l_complete_percents_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;

Line 155: l_complete_percents_tbl SYSTEM.PA_NUM_TBL_TYPE;

151: l_project_id NUMBER;
152: l_relationship_type VARCHAR2(2);
153: l_element_version_id_str VARCHAR2(30);
154: l_proj_elem_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
155: l_complete_percents_tbl SYSTEM.PA_NUM_TBL_TYPE;
156:
157: l_proj_elem_ids_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;
158: l_complete_percents_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;
159: l_rowid_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 157: l_proj_elem_ids_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;

153: l_element_version_id_str VARCHAR2(30);
154: l_proj_elem_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
155: l_complete_percents_tbl SYSTEM.PA_NUM_TBL_TYPE;
156:
157: l_proj_elem_ids_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;
158: l_complete_percents_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;
159: l_rowid_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
160: l_update_flag BOOLEAN;
161:

Line 158: l_complete_percents_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;

154: l_proj_elem_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
155: l_complete_percents_tbl SYSTEM.PA_NUM_TBL_TYPE;
156:
157: l_proj_elem_ids_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;
158: l_complete_percents_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;
159: l_rowid_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
160: l_update_flag BOOLEAN;
161:
162:

Line 3064: , p_plan_version_id_tbl SYSTEM.pa_num_tbl_type

3060: END Derive_WP_Period;
3061:
3062: PROCEDURE Derive_VP_Period(
3063: p_project_id NUMBER
3064: , p_plan_version_id_tbl SYSTEM.pa_num_tbl_type
3065: , x_from_period OUT NOCOPY NUMBER
3066: , x_to_period OUT NOCOPY NUMBER
3067: , x_return_status IN OUT NOCOPY VARCHAR2
3068: , x_msg_count IN OUT NOCOPY NUMBER

Line 3107: , p_plan_version_id_tbl SYSTEM.pa_num_tbl_type

3103: END Derive_VP_Period;
3104:
3105: PROCEDURE Derive_Perf_Period(
3106: p_project_id NUMBER
3107: , p_plan_version_id_tbl SYSTEM.pa_num_tbl_type
3108: , x_from_period OUT NOCOPY NUMBER
3109: , x_to_period OUT NOCOPY NUMBER
3110: , x_return_status IN OUT NOCOPY VARCHAR2
3111: , x_msg_count IN OUT NOCOPY NUMBER

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

3186: */
3187:
3188: /* Modified code for bug 4175400*/
3189: PROCEDURE Get_Default_Period_Dates (
3190: p_plan_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
3191: , p_project_id IN NUMBER
3192: , x_min_julian_date OUT NOCOPY NUMBER
3193: , x_max_julian_date OUT NOCOPY NUMBER
3194: )

Line 3201: l_plan_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3197: l_max_date DATE := NULL;
3198: l_cur_min_date DATE := NULL;
3199: l_cur_max_date DATE := NULL;
3200: l_plan_version_id NUMBER := NULL;
3201: l_plan_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3202: j NUMBER := 0;
3203: BEGIN
3204: IF g_debug_mode = 'Y' THEN
3205: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: begining', TRUE , g_proc);

Line 4927: p_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),

4923: /* Changed the whole logic for Program and Project case for bug 4411930 */
4924:
4925: PROCEDURE Is_Smart_Slice_Created(
4926: p_rbs_version_id IN NUMBER,
4927: p_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
4928: p_wbs_element_id IN NUMBER,
4929: p_rbs_element_id IN NUMBER,
4930: p_prg_rollup_flag IN VARCHAR2,
4931: p_curr_record_type_id IN NUMBER,

Line 4942: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

4938: x_msg_data OUT NOCOPY VARCHAR2,
4939: x_return_status OUT NOCOPY VARCHAR2)
4940: IS
4941: l_plan_version_id NUMBER := NULL;
4942: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4943: l_plan_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4944: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4945: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4946: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 4943: l_plan_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

4939: x_return_status OUT NOCOPY VARCHAR2)
4940: IS
4941: l_plan_version_id NUMBER := NULL;
4942: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4943: l_plan_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4944: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4945: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4946: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4947: l_exists VARCHAR2(1) := 'N';

Line 4944: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

4940: IS
4941: l_plan_version_id NUMBER := NULL;
4942: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4943: l_plan_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4944: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4945: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4946: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4947: l_exists VARCHAR2(1) := 'N';
4948: j NUMBER := 0;

Line 4945: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

4941: l_plan_version_id NUMBER := NULL;
4942: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4943: l_plan_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4944: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4945: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4946: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4947: l_exists VARCHAR2(1) := 'N';
4948: j NUMBER := 0;
4949: l_count NUMBER := 1;

Line 4946: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

4942: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4943: l_plan_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4944: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4945: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4946: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4947: l_exists VARCHAR2(1) := 'N';
4948: j NUMBER := 0;
4949: l_count NUMBER := 1;
4950: l_IsSmartSliceCreated_Flag VARCHAR2(1) := 'Y';

Line 5212: p_fin_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),

5208: + RBS is attached with context plan version
5209: + Additional Plan versions are selected
5210: */
5211: PROCEDURE Chk_plan_vers_have_same_RBS(
5212: p_fin_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
5213: x_R_PlanVers_HavSame_RBS_Flag OUT NOCOPY VARCHAR2,
5214: x_msg_count OUT NOCOPY NUMBER,
5215: x_msg_data OUT NOCOPY VARCHAR2,
5216: x_return_status OUT NOCOPY VARCHAR2)

Line 5219: l_fin_plan_version_ids SYSTEM.pa_num_tbl_type;

5215: x_msg_data OUT NOCOPY VARCHAR2,
5216: x_return_status OUT NOCOPY VARCHAR2)
5217: IS
5218: l_fin_plan_version_id NUMBER := NULL;
5219: l_fin_plan_version_ids SYSTEM.pa_num_tbl_type;
5220: j NUMBER := 0;
5221: l_count NUMBER := 1;
5222: l_R_PlanVers_HavSame_RBS_Flag VARCHAR2(1) := 'Y';
5223: BEGIN