DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PA_NUM_TBL_TYPE

Line 23: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ) ;

19: ------ Specs of internal apis..
20: ---------------------------------------------------------------------------
21:
22: PROCEDURE CHECK_BUDGET_VERSION_EXISTS (
23: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ) ;
24:
25: PROCEDURE PRINT_TIME(p_tag IN VARCHAR2 := NULL);
26:
27: PROCEDURE CLEANUP_TEMP_TABLES;

Line 30: p_fp_version_ids IN OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),

26:
27: PROCEDURE CLEANUP_TEMP_TABLES;
28:
29: PROCEDURE WBS_HEADERS_LOCK (
30: p_fp_version_ids IN OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
31: , p_context IN VARCHAR2
32: , x_return_status OUT NOCOPY VARCHAR2
33: , x_msg_code OUT NOCOPY VARCHAR2 );
34:

Line 37: x_fp_version_ids OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),

33: , x_msg_code OUT NOCOPY VARCHAR2 );
34:
35:
36: PROCEDURE GET_HDRS_TOLOCK_FOR_UPDATE (
37: x_fp_version_ids OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
38: , x_return_status OUT NOCOPY VARCHAR2
39: , x_msg_code OUT NOCOPY VARCHAR2 );
40:
41:

Line 43: p_fp_version_ids IN SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),

39: , x_msg_code OUT NOCOPY VARCHAR2 );
40:
41:
42: PROCEDURE GET_EVENT_IDS (
43: p_fp_version_ids IN SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
44: , p_operation_type IN VARCHAR2 := NULL
45: , x_event_ids OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
46: , x_return_status OUT NOCOPY VARCHAR2
47: , x_msg_code OUT NOCOPY VARCHAR2 );

Line 45: , x_event_ids OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),

41:
42: PROCEDURE GET_EVENT_IDS (
43: p_fp_version_ids IN SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
44: , p_operation_type IN VARCHAR2 := NULL
45: , x_event_ids OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
46: , x_return_status OUT NOCOPY VARCHAR2
47: , x_msg_code OUT NOCOPY VARCHAR2 );
48:
49:

Line 51: p_event_ids IN SYSTEM.pa_num_tbl_type

47: , x_msg_code OUT NOCOPY VARCHAR2 );
48:
49:
50: PROCEDURE DELETE_EVENTS (
51: p_event_ids IN SYSTEM.pa_num_tbl_type
52: , x_return_status OUT NOCOPY VARCHAR2
53: , x_msg_code OUT NOCOPY VARCHAR2 );
54:
55:

Line 57: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

53: , x_msg_code OUT NOCOPY VARCHAR2 );
54:
55:
56: PROCEDURE COPY_PJI_SUMMRZD_FLAG (
57: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
58: , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() );
59:
60:
61: PROCEDURE MARK_PLAN_ORIGINAL (

Line 58: , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() );

54:
55:
56: PROCEDURE COPY_PJI_SUMMRZD_FLAG (
57: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
58: , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() );
59:
60:
61: PROCEDURE MARK_PLAN_ORIGINAL (
62: p_original_version_id IN NUMBER,

Line 234: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),

230: END;
231:
232:
233: PROCEDURE PLAN_DELETE (
234: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_msg_code OUT NOCOPY VARCHAR2 ) IS
237:
238: l_fp_version_ids SYSTEM.pa_num_tbl_type := p_fp_version_ids;

Line 238: l_fp_version_ids SYSTEM.pa_num_tbl_type := p_fp_version_ids;

234: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_msg_code OUT NOCOPY VARCHAR2 ) IS
237:
238: l_fp_version_ids SYSTEM.pa_num_tbl_type := p_fp_version_ids;
239: l_fp_version_ids1 SYSTEM.pa_num_tbl_type := p_fp_version_ids;
240: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
241: l_event_id NUMBER := NULL;
242: l_return_status VARCHAR2(1);

Line 239: l_fp_version_ids1 SYSTEM.pa_num_tbl_type := p_fp_version_ids;

235: x_return_status OUT NOCOPY VARCHAR2,
236: x_msg_code OUT NOCOPY VARCHAR2 ) IS
237:
238: l_fp_version_ids SYSTEM.pa_num_tbl_type := p_fp_version_ids;
239: l_fp_version_ids1 SYSTEM.pa_num_tbl_type := p_fp_version_ids;
240: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
241: l_event_id NUMBER := NULL;
242: l_return_status VARCHAR2(1);
243: l_msg_code VARCHAR2(100);

Line 240: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

236: x_msg_code OUT NOCOPY VARCHAR2 ) IS
237:
238: l_fp_version_ids SYSTEM.pa_num_tbl_type := p_fp_version_ids;
239: l_fp_version_ids1 SYSTEM.pa_num_tbl_type := p_fp_version_ids;
240: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
241: l_event_id NUMBER := NULL;
242: l_return_status VARCHAR2(1);
243: l_msg_code VARCHAR2(100);
244: l_processing_code VARCHAR2(12000);

Line 280: l_fp_version_ids1 := SYSTEM.pa_num_tbl_type (l_fp_version_ids(i));

276:
277: --
278: -- Plan delete pvt api.
279: --
280: l_fp_version_ids1 := SYSTEM.pa_num_tbl_type (l_fp_version_ids(i));
281:
282: PLAN_DELETE_PVT (
283: p_event_id => l_event_rec.event_id
284: , x_return_status => x_return_status

Line 314: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

310: , x_return_status OUT NOCOPY VARCHAR2
311: , x_processing_code OUT NOCOPY VARCHAR2 ) IS
312:
313: l_plan_version_id NUMBER := NULL;
314: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
315: l_return_status VARCHAR2(1);
316: l_msg_code VARCHAR2(100);
317: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
318:

Line 317: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

313: l_plan_version_id NUMBER := NULL;
314: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
315: l_return_status VARCHAR2(1);
316: l_msg_code VARCHAR2(100);
317: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
318:
319: BEGIN
320:
321: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK

Line 339: l_fp_version_ids := SYSTEM.pa_num_tbl_type (l_plan_version_id);

335: END;
336:
337: print_time ( ' plan delete pvt 002 ' );
338:
339: l_fp_version_ids := SYSTEM.pa_num_tbl_type (l_plan_version_id);
340:
341: print_time ( ' plan delete pvt 003 ' );
342:
343: WBS_HEADERS_LOCK (

Line 361: l_event_ids := SYSTEM.pa_num_tbl_type (p_event_id);

357: PJI_FM_PLAN_MAINT.DELETE_ALL_PVT ( p_fp_version_ids => l_fp_version_ids);
358:
359: print_time ( ' plan delete pvt 006 ' );
360:
361: l_event_ids := SYSTEM.pa_num_tbl_type (p_event_id);
362:
363: print_time ( ' plan delete pvt 007 ' );
364:
365: DELETE_EVENTS (

Line 387: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),

383: END;
384:
385:
386: PROCEDURE PLAN_CREATE (
387: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
388: x_return_status OUT NOCOPY VARCHAR2,
389: x_msg_code OUT NOCOPY VARCHAR2,
390: p_fp_src_version_ids IN SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type(),
391: p_copy_mode in varchar2 :=NULL) IS

Line 390: p_fp_src_version_ids IN SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type(),

386: PROCEDURE PLAN_CREATE (
387: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
388: x_return_status OUT NOCOPY VARCHAR2,
389: x_msg_code OUT NOCOPY VARCHAR2,
390: p_fp_src_version_ids IN SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type(),
391: p_copy_mode in varchar2 :=NULL) IS
392: BEGIN
393:
394: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK

Line 538: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

534: AND ROWID IN ( SELECT extr_lines_rowid FROM pji_fp_rmap_fpr_update_t)
535: ORDER BY rbs_version_id,struct_ver_id;
536:
537: l_num_rows_extr_lines NUMBER := NULL;
538: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
539: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
540: l_return_status VARCHAR2(1);
541: l_msg_code VARCHAR2(100);
542: l_num_need_to_lock NUMBER;

Line 539: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

535: ORDER BY rbs_version_id,struct_ver_id;
536:
537: l_num_rows_extr_lines NUMBER := NULL;
538: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
539: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
540: l_return_status VARCHAR2(1);
541: l_msg_code VARCHAR2(100);
542: l_num_need_to_lock NUMBER;
543: l_temp NUMBER;

Line 547: p_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

543: l_temp NUMBER;
544:
545: l_update_id NUMBER;
546:
547: p_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
548: p_rbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
549: p_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
550:
551: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 548: p_rbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

544:
545: l_update_id NUMBER;
546:
547: p_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
548: p_rbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
549: p_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
550:
551: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
552:

Line 549: p_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

545: l_update_id NUMBER;
546:
547: p_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
548: p_rbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
549: p_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
550:
551: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
552:
553: l_new_rbs_version_id number;

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

547: p_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
548: p_rbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
549: p_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
550:
551: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
552:
553: l_new_rbs_version_id number;
554: l_new_wbs_version_id number;
555: l_new_plan_version_id number;

Line 637: l_fp_version_ids := SYSTEM.pa_num_tbl_type(p_plan_version_id);

633: END IF;
634: */
635:
636: IF (p_plan_version_id IS NOT NULL) THEN
637: l_fp_version_ids := SYSTEM.pa_num_tbl_type(p_plan_version_id);
638: print_time ( 'PLAN_UPDATE_PVT 4.999 ');
639: END IF;
640:
641: -------------------------------------------------------------------------

Line 977: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

973: , x_return_status OUT NOCOPY VARCHAR2
974: , x_processing_code OUT NOCOPY VARCHAR2) IS
975:
976: l_num_rows_extr_lines NUMBER := NULL;
977: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
978: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
979: l_return_status VARCHAR2(1);
980: l_msg_code VARCHAR2(100);
981: l_num_need_to_lock NUMBER;

Line 978: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

974: , x_processing_code OUT NOCOPY VARCHAR2) IS
975:
976: l_num_rows_extr_lines NUMBER := NULL;
977: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
978: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
979: l_return_status VARCHAR2(1);
980: l_msg_code VARCHAR2(100);
981: l_num_need_to_lock NUMBER;
982: l_temp NUMBER;

Line 1122: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),

1118: END;
1119:
1120:
1121: PROCEDURE FINPLAN_COPY (
1122: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
1123: p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
1124: p_source_fp_version_types IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
1125: p_dest_fp_version_types IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
1126: x_return_status OUT NOCOPY VARCHAR2,

Line 1123: p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),

1119:
1120:
1121: PROCEDURE FINPLAN_COPY (
1122: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
1123: p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
1124: p_source_fp_version_types IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
1125: p_dest_fp_version_types IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
1126: x_return_status OUT NOCOPY VARCHAR2,
1127: x_msg_code OUT NOCOPY VARCHAR2 ) IS

Line 1129: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1125: p_dest_fp_version_types IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
1126: x_return_status OUT NOCOPY VARCHAR2,
1127: x_msg_code OUT NOCOPY VARCHAR2 ) IS
1128:
1129: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1130: l_s_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- s == Source
1131: l_s_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- d == Desination
1132: l_d_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1133: l_d_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 1130: l_s_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- s == Source

1126: x_return_status OUT NOCOPY VARCHAR2,
1127: x_msg_code OUT NOCOPY VARCHAR2 ) IS
1128:
1129: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1130: l_s_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- s == Source
1131: l_s_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- d == Desination
1132: l_d_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1133: l_d_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1134: l_num_wking_fp_ver_ids NUMBER := NULL;

Line 1131: l_s_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- d == Desination

1127: x_msg_code OUT NOCOPY VARCHAR2 ) IS
1128:
1129: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1130: l_s_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- s == Source
1131: l_s_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- d == Desination
1132: l_d_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1133: l_d_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1134: l_num_wking_fp_ver_ids NUMBER := NULL;
1135: l_return_status VARCHAR2(1);

Line 1132: l_d_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1128:
1129: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1130: l_s_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- s == Source
1131: l_s_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- d == Desination
1132: l_d_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1133: l_d_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1134: l_num_wking_fp_ver_ids NUMBER := NULL;
1135: l_return_status VARCHAR2(1);
1136: l_processing_code VARCHAR2(100);

Line 1133: l_d_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1129: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1130: l_s_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- s == Source
1131: l_s_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- d == Desination
1132: l_d_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1133: l_d_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1134: l_num_wking_fp_ver_ids NUMBER := NULL;
1135: l_return_status VARCHAR2(1);
1136: l_processing_code VARCHAR2(100);
1137: l_msg_code VARCHAR2(100);

Line 1138: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1134: l_num_wking_fp_ver_ids NUMBER := NULL;
1135: l_return_status VARCHAR2(1);
1136: l_processing_code VARCHAR2(100);
1137: l_msg_code VARCHAR2(100);
1138: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1139: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1140: l_event_rec pa_pji_proj_events_log%ROWTYPE;
1141:
1142: l_num_src_fp_ver_ids NUMBER := NULL;

Line 1139: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1135: l_return_status VARCHAR2(1);
1136: l_processing_code VARCHAR2(100);
1137: l_msg_code VARCHAR2(100);
1138: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1139: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1140: l_event_rec pa_pji_proj_events_log%ROWTYPE;
1141:
1142: l_num_src_fp_ver_ids NUMBER := NULL;
1143: l_num_dest_fp_ver_ids NUMBER := NULL;

Line 1232: l_s_fp_version_ids := SYSTEM.pa_num_tbl_type (p_source_fp_version_ids(i) );

1228: --
1229: -- Copy the plan without creating events.
1230: --
1231:
1232: l_s_fp_version_ids := SYSTEM.pa_num_tbl_type (p_source_fp_version_ids(i) );
1233: l_d_fp_version_ids := SYSTEM.pa_num_tbl_type (p_dest_fp_version_ids(i) );
1234:
1235: print_time ( ' plan copy api .. 008 ' );
1236:

Line 1233: l_d_fp_version_ids := SYSTEM.pa_num_tbl_type (p_dest_fp_version_ids(i) );

1229: -- Copy the plan without creating events.
1230: --
1231:
1232: l_s_fp_version_ids := SYSTEM.pa_num_tbl_type (p_source_fp_version_ids(i) );
1233: l_d_fp_version_ids := SYSTEM.pa_num_tbl_type (p_dest_fp_version_ids(i) );
1234:
1235: print_time ( ' plan copy api .. 008 ' );
1236:
1237: Pji_Fm_Plan_Maint_T_Pvt.COPY_PRIMARY

Line 1278: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1274: p_event_id IN NUMBER
1275: , x_return_status OUT NOCOPY VARCHAR2
1276: , x_processing_code OUT NOCOPY VARCHAR2) IS
1277:
1278: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1279: l_s_plan_version_id NUMBER := NULL;
1280: l_d_plan_version_id NUMBER := NULL;
1281: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1282: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 1281: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1277:
1278: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1279: l_s_plan_version_id NUMBER := NULL;
1280: l_d_plan_version_id NUMBER := NULL;
1281: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1282: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1283: l_working_or_baselined VARCHAR2(30) := 'N';
1284: l_return_status VARCHAR2(1);
1285: l_msg_code VARCHAR2(100);

Line 1282: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1278: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1279: l_s_plan_version_id NUMBER := NULL;
1280: l_d_plan_version_id NUMBER := NULL;
1281: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1282: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1283: l_working_or_baselined VARCHAR2(30) := 'N';
1284: l_return_status VARCHAR2(1);
1285: l_msg_code VARCHAR2(100);
1286:

Line 1302: l_s_fp_version_ids := SYSTEM.pa_num_tbl_type (l_s_plan_version_id);

1298: INTO l_s_plan_version_id, l_d_plan_version_id, l_working_or_baselined
1299: FROM PA_PJI_PROJ_EVENTS_LOG
1300: WHERE event_id = p_event_id;
1301:
1302: l_s_fp_version_ids := SYSTEM.pa_num_tbl_type (l_s_plan_version_id);
1303: l_d_fp_version_ids := SYSTEM.pa_num_tbl_type (l_d_plan_version_id);
1304:
1305: print_time ( ' plan copy PVT api .. 002 ' );
1306:

Line 1303: l_d_fp_version_ids := SYSTEM.pa_num_tbl_type (l_d_plan_version_id);

1299: FROM PA_PJI_PROJ_EVENTS_LOG
1300: WHERE event_id = p_event_id;
1301:
1302: l_s_fp_version_ids := SYSTEM.pa_num_tbl_type (l_s_plan_version_id);
1303: l_d_fp_version_ids := SYSTEM.pa_num_tbl_type (l_d_plan_version_id);
1304:
1305: print_time ( ' plan copy PVT api .. 002 ' );
1306:
1307: WBS_HEADERS_LOCK (

Line 1341: l_event_ids := SYSTEM.pa_num_tbl_type (p_event_id);

1337:
1338: --
1339: -- Delete from events table.
1340: --
1341: l_event_ids := SYSTEM.pa_num_tbl_type (p_event_id);
1342:
1343: DELETE_EVENTS (
1344: p_event_ids => l_event_ids
1345: , x_return_status => l_return_status

Line 1369: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1365: p_new_version_id IN NUMBER,
1366: x_return_status OUT NOCOPY VARCHAR2,
1367: x_msg_code OUT NOCOPY VARCHAR2 ) IS
1368:
1369: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1370: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1371: l_return_status VARCHAR2(1);
1372: l_msg_code VARCHAR2(100);
1373: l_event_id NUMBER;

Line 1370: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1366: x_return_status OUT NOCOPY VARCHAR2,
1367: x_msg_code OUT NOCOPY VARCHAR2 ) IS
1368:
1369: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1370: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1371: l_return_status VARCHAR2(1);
1372: l_msg_code VARCHAR2(100);
1373: l_event_id NUMBER;
1374: l_event_rec pa_pji_proj_events_log%ROWTYPE;

Line 1384: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1380: l_plan_type_code CHAR(1);
1381: l_processing_code VARCHAR2(12000);
1382: l_wp_version_flag VARCHAR2(1) := NULL;
1383:
1384: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1385: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1386:
1387: BEGIN
1388:

Line 1385: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1381: l_processing_code VARCHAR2(12000);
1382: l_wp_version_flag VARCHAR2(1) := NULL;
1383:
1384: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1385: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1386:
1387: BEGIN
1388:
1389: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK

Line 1450: l_s_fp_version_ids := SYSTEM.pa_num_tbl_type (p_baseline_version_id );

1446: ------------------------------------------------------------------------------
1447:
1448: print_time ( ' PLAN_BASELINE api 001.1 ' || p_baseline_version_id || ' ' || p_new_version_id );
1449:
1450: l_s_fp_version_ids := SYSTEM.pa_num_tbl_type (p_baseline_version_id );
1451: l_d_fp_version_ids := SYSTEM.pa_num_tbl_type (p_new_version_id);
1452:
1453: COPY_PJI_SUMMRZD_FLAG (
1454: p_source_fp_version_ids => l_s_fp_version_ids

Line 1451: l_d_fp_version_ids := SYSTEM.pa_num_tbl_type (p_new_version_id);

1447:
1448: print_time ( ' PLAN_BASELINE api 001.1 ' || p_baseline_version_id || ' ' || p_new_version_id );
1449:
1450: l_s_fp_version_ids := SYSTEM.pa_num_tbl_type (p_baseline_version_id );
1451: l_d_fp_version_ids := SYSTEM.pa_num_tbl_type (p_new_version_id);
1452:
1453: COPY_PJI_SUMMRZD_FLAG (
1454: p_source_fp_version_ids => l_s_fp_version_ids
1455: , p_dest_fp_version_ids => l_d_fp_version_ids);

Line 1519: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1515: l_baseline_version_id NUMBER;
1516: l_old_baseline_version_id NUMBER;
1517: l_new_version_id NUMBER;
1518: l_plan_type_id NUMBER;
1519: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1520: l_source_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1521: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1522: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1523: l_return_status VARCHAR2(12000);

Line 1520: l_source_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1516: l_old_baseline_version_id NUMBER;
1517: l_new_version_id NUMBER;
1518: l_plan_type_id NUMBER;
1519: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1520: l_source_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1521: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1522: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1523: l_return_status VARCHAR2(12000);
1524: l_msg_code VARCHAR2(100);

Line 1521: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1517: l_new_version_id NUMBER;
1518: l_plan_type_id NUMBER;
1519: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1520: l_source_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1521: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1522: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1523: l_return_status VARCHAR2(12000);
1524: l_msg_code VARCHAR2(100);
1525: l_baselined_exists NUMBER;

Line 1522: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1518: l_plan_type_id NUMBER;
1519: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1520: l_source_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1521: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1522: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1523: l_return_status VARCHAR2(12000);
1524: l_msg_code VARCHAR2(100);
1525: l_baselined_exists NUMBER;
1526: l_new_working_ver_id NUMBER;

Line 1529: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1525: l_baselined_exists NUMBER;
1526: l_new_working_ver_id NUMBER;
1527: l_processing_code VARCHAR2(1);
1528:
1529: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1530: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1531:
1532: l_last_update_date date := SYSDATE;
1533: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

Line 1530: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1526: l_new_working_ver_id NUMBER;
1527: l_processing_code VARCHAR2(1);
1528:
1529: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1530: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1531:
1532: l_last_update_date date := SYSDATE;
1533: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1534: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line 1565: l_dest_fp_version_ids := SYSTEM.pa_num_tbl_type (l_new_version_id);

1561: FROM PA_PJI_PROJ_EVENTS_LOG
1562: WHERE event_id = p_event_id;
1563:
1564:
1565: l_dest_fp_version_ids := SYSTEM.pa_num_tbl_type (l_new_version_id);
1566:
1567:
1568: ----------------------------------------------------------------------------------------
1569: -- Insert the missing -3, -4 header records and lock the appropriate versions.

Line 1640: l_event_ids := SYSTEM.pa_num_tbl_type (p_event_id);

1636: ------------------------------------------------------------------------------
1637: -- Delete event.
1638: ------------------------------------------------------------------------------
1639:
1640: l_event_ids := SYSTEM.pa_num_tbl_type (p_event_id);
1641:
1642: DELETE_EVENTS (
1643: p_event_ids => l_event_ids
1644: , x_return_status => l_return_status

Line 1665: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1661: p_original_version_id IN NUMBER,
1662: x_return_status OUT NOCOPY VARCHAR2,
1663: x_msg_code OUT NOCOPY VARCHAR2 ) IS
1664:
1665: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1666: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1667: l_wp_flag VARCHAR2(1);
1668: l_return_status VARCHAR2(1);
1669: l_msg_code VARCHAR2(100);

Line 1666: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1662: x_return_status OUT NOCOPY VARCHAR2,
1663: x_msg_code OUT NOCOPY VARCHAR2 ) IS
1664:
1665: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1666: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1667: l_wp_flag VARCHAR2(1);
1668: l_return_status VARCHAR2(1);
1669: l_msg_code VARCHAR2(100);
1670: l_event_id NUMBER;

Line 1789: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1785: p_event_id IN NUMBER
1786: , x_return_status OUT NOCOPY VARCHAR2
1787: , x_processing_code OUT NOCOPY VARCHAR2) IS
1788:
1789: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1790: l_source_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1791: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1792: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1793: l_wp_flag VARCHAR2(1);

Line 1790: l_source_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1786: , x_return_status OUT NOCOPY VARCHAR2
1787: , x_processing_code OUT NOCOPY VARCHAR2) IS
1788:
1789: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1790: l_source_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1791: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1792: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1793: l_wp_flag VARCHAR2(1);
1794: l_return_status VARCHAR2(1);

Line 1791: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1787: , x_processing_code OUT NOCOPY VARCHAR2) IS
1788:
1789: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1790: l_source_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1791: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1792: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1793: l_wp_flag VARCHAR2(1);
1794: l_return_status VARCHAR2(1);
1795: l_msg_code VARCHAR2(100);

Line 1792: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1788:
1789: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1790: l_source_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1791: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1792: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1793: l_wp_flag VARCHAR2(1);
1794: l_return_status VARCHAR2(1);
1795: l_msg_code VARCHAR2(100);
1796: l_event_id NUMBER;

Line 1835: l_fp_version_ids := SYSTEM.pa_num_tbl_type (l_new_orig_ver_id);

1831: ----------------------------------------------------------------------------------------
1832: -- First, need to lock all relevant plan versions, if this is not possible, return.
1833: ----------------------------------------------------------------------------------------
1834:
1835: l_fp_version_ids := SYSTEM.pa_num_tbl_type (l_new_orig_ver_id);
1836:
1837: /*
1838: CHECK_BUDGET_VERSION_EXISTS(l_fp_version_ids);
1839:

Line 1925: l_event_ids := SYSTEM.pa_num_tbl_type (p_event_id);

1921: ------------------------------------------
1922: -- Delete from events table.
1923: ------------------------------------------
1924:
1925: l_event_ids := SYSTEM.pa_num_tbl_type (p_event_id);
1926:
1927: DELETE_EVENTS (
1928: p_event_ids => l_event_ids
1929: , x_return_status => l_return_status

Line 1997: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1993: , x_return_status OUT NOCOPY VARCHAR2
1994: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
1995:
1996: l_event_rec pa_pji_proj_events_log%ROWTYPE;
1997: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1998: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1999: l_return_status VARCHAR2(1);
2000: l_msg_code VARCHAR2(100);
2001: l_template_flag VARCHAR2(1);

Line 1998: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1994: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
1995:
1996: l_event_rec pa_pji_proj_events_log%ROWTYPE;
1997: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1998: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1999: l_return_status VARCHAR2(1);
2000: l_msg_code VARCHAR2(100);
2001: l_template_flag VARCHAR2(1);
2002:

Line 2091: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2087: , x_return_status OUT NOCOPY VARCHAR2
2088: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
2089:
2090: l_event_rec pa_pji_proj_events_log%ROWTYPE;
2091: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2092: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2093: l_return_status VARCHAR2(1);
2094: l_msg_code VARCHAR2(100);
2095:

Line 2092: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2088: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
2089:
2090: l_event_rec pa_pji_proj_events_log%ROWTYPE;
2091: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2092: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2093: l_return_status VARCHAR2(1);
2094: l_msg_code VARCHAR2(100);
2095:
2096: BEGIN

Line 2301: p_fp_version_ids IN OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),

2297: ----------
2298: -- API to lock headers, used by online and bulk summarization apis.
2299: ----------
2300: PROCEDURE WBS_HEADERS_LOCK (
2301: p_fp_version_ids IN OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
2302: , p_context IN VARCHAR2
2303: , x_return_status OUT NOCOPY VARCHAR2
2304: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
2305:

Line 2312: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139

2308: l_count NUMBER := 0;
2309: l_count1 NUMBER := 0;
2310: l_num_locked NUMBER := 0;
2311:
2312: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139
2313: l_project_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139
2314: l_baseline_fp_ver_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139
2315: l_wp_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2316: l_latest_pub_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

Line 2313: l_project_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139

2309: l_count1 NUMBER := 0;
2310: l_num_locked NUMBER := 0;
2311:
2312: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139
2313: l_project_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139
2314: l_baseline_fp_ver_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139
2315: l_wp_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2316: l_latest_pub_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2317: l_baselined_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

Line 2314: l_baseline_fp_ver_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139

2310: l_num_locked NUMBER := 0;
2311:
2312: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139
2313: l_project_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139
2314: l_baseline_fp_ver_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139
2315: l_wp_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2316: l_latest_pub_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2317: l_baselined_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2318: l_published_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

Line 3013: x_fp_version_ids OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),

3009: END;
3010:
3011:
3012: PROCEDURE GET_HDRS_TOLOCK_FOR_UPDATE (
3013: x_fp_version_ids OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
3014: , x_return_status OUT NOCOPY VARCHAR2
3015: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
3016:
3017: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 3017: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3013: x_fp_version_ids OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
3014: , x_return_status OUT NOCOPY VARCHAR2
3015: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
3016:
3017: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3018:
3019: CURSOR c_plan_version_ids_cur IS
3020: SELECT DISTINCT plan_version_id
3021: FROM PJI_FM_EXTR_PLAN_LINES

Line 3053: p_fp_version_ids IN SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),

3049: END;
3050:
3051:
3052: PROCEDURE GET_EVENT_IDS (
3053: p_fp_version_ids IN SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
3054: , p_operation_type IN VARCHAR2 := NULL
3055: , x_event_ids OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
3056: , x_return_status OUT NOCOPY VARCHAR2
3057: , x_msg_code OUT NOCOPY VARCHAR2 ) IS

Line 3055: , x_event_ids OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),

3051:
3052: PROCEDURE GET_EVENT_IDS (
3053: p_fp_version_ids IN SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
3054: , p_operation_type IN VARCHAR2 := NULL
3055: , x_event_ids OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
3056: , x_return_status OUT NOCOPY VARCHAR2
3057: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
3058:
3059: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 3059: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3055: , x_event_ids OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
3056: , x_return_status OUT NOCOPY VARCHAR2
3057: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
3058:
3059: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3060: i NUMBER := NULL;
3061: j NUMBER := NULL;
3062:
3063: CURSOR c_event_id_cur (

Line 3105: p_event_ids IN SYSTEM.pa_num_tbl_type

3101: END;
3102:
3103:
3104: PROCEDURE DELETE_EVENTS (
3105: p_event_ids IN SYSTEM.pa_num_tbl_type
3106: , x_return_status OUT NOCOPY VARCHAR2
3107: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
3108: BEGIN
3109:

Line 3134: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

3130: END;
3131:
3132:
3133: PROCEDURE COPY_PJI_SUMMRZD_FLAG (
3134: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
3135: , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ) IS
3136:
3137: l_pji_summarized_flag VARCHAR2(1) := NULL;
3138: l_return_status VARCHAR2(1);

Line 3135: , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ) IS

3131:
3132:
3133: PROCEDURE COPY_PJI_SUMMRZD_FLAG (
3134: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
3135: , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ) IS
3136:
3137: l_pji_summarized_flag VARCHAR2(1) := NULL;
3138: l_return_status VARCHAR2(1);
3139:

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

3782: l_chd_dev_status VARCHAR2(400);
3783: l_chd_message VARCHAR2(2000);
3784: l_plan_version_id NUMBER;
3785:
3786: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3787: l_struct_sharing_code pa_projects_all.structure_sharing_code%TYPE;
3788: CURSOR c_pln_ver_list (p_old_struct_ver_id IN NUMBER) IS
3789: SELECT project_id, plan_version_id
3790: FROM pji_pjp_wbs_header

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

5157: --there are no pending event for the plan version
5158: ---------------------------------------------------------------
5159: PROCEDURE process_plan_events (
5160: p_project_id IN NUMBER,
5161: p_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
5162: x_processing_code OUT NOCOPY VARCHAR2,
5163: x_msg_count OUT NOCOPY NUMBER,
5164: x_msg_data OUT NOCOPY VARCHAR2,
5165: x_return_status OUT NOCOPY VARCHAR2 )

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

5377: -- Create on demand slices.
5378: --
5379: PROCEDURE maintain_smart_slice (
5380: p_rbs_version_id IN NUMBER :=NULL,
5381: p_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
5382: p_wbs_element_id IN NUMBER,
5383: p_rbs_element_id IN NUMBER,
5384: p_prg_rollup_flag IN VARCHAR2,
5385: p_curr_record_type_id IN NUMBER,

Line 5389: p_rbs_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),

5385: p_curr_record_type_id IN NUMBER,
5386: p_calendar_type IN VARCHAR2,
5387: p_wbs_version_id IN NUMBER,
5388: p_commit IN VARCHAR2 := 'Y',
5389: p_rbs_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
5390: x_msg_count OUT NOCOPY NUMBER,
5391: x_msg_data OUT NOCOPY VARCHAR2,
5392: x_return_status OUT NOCOPY VARCHAR2) IS
5393:

Line 5399: l_proj_element_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

5395: -- l_rollup_status_exists VARCHAR2(1) := 'N';
5396: l_exists VARCHAR2(1) := 'N';
5397: l_struct_element_id NUMBER := -1;
5398: l_project_id NUMBER := 1;
5399: l_proj_element_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5400: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5401: l_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
5402: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5403: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

5396: l_exists VARCHAR2(1) := 'N';
5397: l_struct_element_id NUMBER := -1;
5398: l_project_id NUMBER := 1;
5399: l_proj_element_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5400: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5401: l_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
5402: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5403: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5404: l_count NUMBER := 1;

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

5398: l_project_id NUMBER := 1;
5399: l_proj_element_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5400: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5401: l_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
5402: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5403: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5404: l_count NUMBER := 1;
5405:
5406: l_last_update_date date := SYSDATE;

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

5399: l_proj_element_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5400: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5401: l_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
5402: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5403: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5404: l_count NUMBER := 1;
5405:
5406: l_last_update_date date := SYSDATE;
5407: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

Line 5411: il_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

5407: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5408: l_creation_date date := SYSDATE;
5409: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5410: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5411: il_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5412: il_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5413: il_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5414: il_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5415: l_prg_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 5413: il_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

5409: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5410: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5411: il_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5412: il_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5413: il_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5414: il_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5415: l_prg_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5416: l_prg_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5417: l_prg_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 5414: il_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

5410: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5411: il_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5412: il_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5413: il_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5414: il_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5415: l_prg_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5416: l_prg_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5417: l_prg_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5418: l_prg_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 5415: l_prg_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

5411: il_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5412: il_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5413: il_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5414: il_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5415: l_prg_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5416: l_prg_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5417: l_prg_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5418: l_prg_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5419: l_prg_count NUMBER := 1;

Line 5417: l_prg_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

5413: il_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5414: il_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5415: l_prg_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5416: l_prg_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5417: l_prg_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5418: l_prg_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5419: l_prg_count NUMBER := 1;
5420: l_roll_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5421: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 5418: l_prg_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

5414: il_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5415: l_prg_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5416: l_prg_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5417: l_prg_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5418: l_prg_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5419: l_prg_count NUMBER := 1;
5420: l_roll_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5421: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5422: l_get_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 5420: l_roll_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

5416: l_prg_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5417: l_prg_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5418: l_prg_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5419: l_prg_count NUMBER := 1;
5420: l_roll_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5421: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5422: l_get_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5423: l_get_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5424: l_wbs_count NUMBER:=2;

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

5417: l_prg_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5418: l_prg_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5419: l_prg_count NUMBER := 1;
5420: l_roll_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5421: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5422: l_get_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5423: l_get_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5424: l_wbs_count NUMBER:=2;
5425: l_wbs_exists NUMBER :=0;

Line 5422: l_get_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

5418: l_prg_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5419: l_prg_count NUMBER := 1;
5420: l_roll_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5421: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5422: l_get_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5423: l_get_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5424: l_wbs_count NUMBER:=2;
5425: l_wbs_exists NUMBER :=0;
5426: validcount NUMBER:=1;

Line 5427: jl_get_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /*4471527 */

5423: l_get_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5424: l_wbs_count NUMBER:=2;
5425: l_wbs_exists NUMBER :=0;
5426: validcount NUMBER:=1;
5427: jl_get_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /*4471527 */
5428: jl_get_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5429: jl_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /*4471527 */
5430: l_rbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5431: BEGIN

Line 5429: jl_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /*4471527 */

5425: l_wbs_exists NUMBER :=0;
5426: validcount NUMBER:=1;
5427: jl_get_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /*4471527 */
5428: jl_get_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5429: jl_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /*4471527 */
5430: l_rbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5431: BEGIN
5432:
5433: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK

Line 5430: l_rbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

5426: validcount NUMBER:=1;
5427: jl_get_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /*4471527 */
5428: jl_get_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5429: jl_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /*4471527 */
5430: l_rbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5431: BEGIN
5432:
5433: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
5434: ( p_package_name => g_package_name

Line 6514: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ) IS

6510: --
6511: -- Checks if list of plan versions exist in budget versions table.
6512: --
6513: PROCEDURE CHECK_BUDGET_VERSION_EXISTS (
6514: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ) IS
6515: i NUMBER;
6516: l_project_id NUMBER;
6517: l_return_status VARCHAR2(1);
6518: BEGIN

Line 6572: ( p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ) IS

6568: ----------
6569: -- Prints the list of plan versions in a given table of plan versions.
6570: ----------
6571: PROCEDURE PRINT_PLAN_VERSION_ID_LIST
6572: ( p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ) IS
6573: i NUMBER;
6574: l_return_status VARCHAR2(1);
6575: BEGIN
6576: