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 210: PROCEDURE Log_Struct_Change_Event(p_wbs_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE) IS

206: Fnd_Message.set_name('PJI','PJI_REP_GENERIC_MSG');
207: Fnd_Message.set_token('PROC_NAME','Pji_Rep_Util.Add_Message');
208: END Add_Message;
209:
210: PROCEDURE Log_Struct_Change_Event(p_wbs_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE) IS
211: l_i NUMBER;
212: BEGIN
213:
214: IF g_debug_mode = 'Y' THEN

Line 296: l_proj_elem_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

292: l_prg_flag VARCHAR2(1);
293: l_project_id NUMBER;
294: l_relationship_type VARCHAR2(2);
295: l_element_version_id_str VARCHAR2(30);
296: l_proj_elem_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
297: l_complete_percents_tbl SYSTEM.PA_NUM_TBL_TYPE;
298:
299: l_proj_elem_ids_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;
300: l_complete_percents_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;

Line 297: l_complete_percents_tbl SYSTEM.PA_NUM_TBL_TYPE;

293: l_project_id NUMBER;
294: l_relationship_type VARCHAR2(2);
295: l_element_version_id_str VARCHAR2(30);
296: l_proj_elem_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
297: l_complete_percents_tbl SYSTEM.PA_NUM_TBL_TYPE;
298:
299: l_proj_elem_ids_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;
300: l_complete_percents_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;
301: l_rowid_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 299: l_proj_elem_ids_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;

295: l_element_version_id_str VARCHAR2(30);
296: l_proj_elem_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
297: l_complete_percents_tbl SYSTEM.PA_NUM_TBL_TYPE;
298:
299: l_proj_elem_ids_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;
300: l_complete_percents_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;
301: l_rowid_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
302: l_update_flag BOOLEAN;
303:

Line 300: l_complete_percents_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;

296: l_proj_elem_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
297: l_complete_percents_tbl SYSTEM.PA_NUM_TBL_TYPE;
298:
299: l_proj_elem_ids_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;
300: l_complete_percents_tmp_tbl SYSTEM.PA_NUM_TBL_TYPE;
301: l_rowid_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
302: l_update_flag BOOLEAN;
303:
304: -- OLAP START

Line 3508: , p_plan_version_id_tbl SYSTEM.pa_num_tbl_type

3504: END Derive_WP_Period;
3505:
3506: PROCEDURE Derive_VP_Period(
3507: p_project_id NUMBER
3508: , p_plan_version_id_tbl SYSTEM.pa_num_tbl_type
3509: , x_from_period OUT NOCOPY NUMBER
3510: , x_to_period OUT NOCOPY NUMBER
3511: , x_return_status IN OUT NOCOPY VARCHAR2
3512: , x_msg_count IN OUT NOCOPY NUMBER

Line 3551: , p_plan_version_id_tbl SYSTEM.pa_num_tbl_type

3547: END Derive_VP_Period;
3548:
3549: PROCEDURE Derive_Perf_Period(
3550: p_project_id NUMBER
3551: , p_plan_version_id_tbl SYSTEM.pa_num_tbl_type
3552: , x_from_period OUT NOCOPY NUMBER
3553: , x_to_period OUT NOCOPY NUMBER
3554: , x_return_status IN OUT NOCOPY VARCHAR2
3555: , x_msg_count IN OUT NOCOPY NUMBER

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

3630: */
3631:
3632: /* Modified code for bug 4175400*/
3633: PROCEDURE Get_Default_Period_Dates (
3634: p_plan_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
3635: , p_project_id IN NUMBER
3636: , x_min_julian_date OUT NOCOPY NUMBER
3637: , x_max_julian_date OUT NOCOPY NUMBER
3638: )

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

3641: l_max_date DATE := NULL;
3642: l_cur_min_date DATE := NULL;
3643: l_cur_max_date DATE := NULL;
3644: l_plan_version_id NUMBER := NULL;
3645: l_plan_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3646: j NUMBER := 0;
3647: BEGIN
3648: IF g_debug_mode = 'Y' THEN
3649: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: begining', TRUE , g_proc);

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

5367: /* Changed the whole logic for Program and Project case for bug 4411930 */
5368:
5369: PROCEDURE Is_Smart_Slice_Created(
5370: p_rbs_version_id IN NUMBER,
5371: p_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
5372: p_wbs_element_id IN NUMBER,
5373: p_rbs_element_id IN NUMBER,
5374: p_prg_rollup_flag IN VARCHAR2,
5375: p_curr_record_type_id IN NUMBER,

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

5382: x_msg_data OUT NOCOPY VARCHAR2,
5383: x_return_status OUT NOCOPY VARCHAR2)
5384: IS
5385: l_plan_version_id NUMBER := NULL;
5386: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5387: l_plan_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5388: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5389: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5390: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

5383: x_return_status OUT NOCOPY VARCHAR2)
5384: IS
5385: l_plan_version_id NUMBER := NULL;
5386: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5387: l_plan_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5388: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5389: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5390: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5391: l_exists VARCHAR2(1) := 'N';

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

5384: IS
5385: l_plan_version_id NUMBER := NULL;
5386: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5387: l_plan_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5388: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5389: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5390: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5391: l_exists VARCHAR2(1) := 'N';
5392: j NUMBER := 0;

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

5385: l_plan_version_id NUMBER := NULL;
5386: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5387: l_plan_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5388: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5389: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5390: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5391: l_exists VARCHAR2(1) := 'N';
5392: j NUMBER := 0;
5393: l_count NUMBER := 1;

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

5386: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5387: l_plan_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5388: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5389: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5390: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5391: l_exists VARCHAR2(1) := 'N';
5392: j NUMBER := 0;
5393: l_count NUMBER := 1;
5394: l_IsSmartSliceCreated_Flag VARCHAR2(1) := 'Y';

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

5692: + RBS is attached with context plan version
5693: + Additional Plan versions are selected
5694: */
5695: PROCEDURE Chk_plan_vers_have_same_RBS(
5696: p_fin_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
5697: x_R_PlanVers_HavSame_RBS_Flag OUT NOCOPY VARCHAR2,
5698: x_msg_count OUT NOCOPY NUMBER,
5699: x_msg_data OUT NOCOPY VARCHAR2,
5700: x_return_status OUT NOCOPY VARCHAR2)

Line 5703: l_fin_plan_version_ids SYSTEM.pa_num_tbl_type;

5699: x_msg_data OUT NOCOPY VARCHAR2,
5700: x_return_status OUT NOCOPY VARCHAR2)
5701: IS
5702: l_fin_plan_version_id NUMBER := NULL;
5703: l_fin_plan_version_ids SYSTEM.pa_num_tbl_type;
5704: j NUMBER := 0;
5705: l_count NUMBER := 1;
5706: l_R_PlanVers_HavSame_RBS_Flag VARCHAR2(1) := 'Y';
5707: BEGIN