DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PA_NUM_TBL_TYPE

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

21: ---------------------------------------------------------------------------
22:
23:
24: PROCEDURE CHECK_BUDGET_VERSION_EXISTS (
25: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ) ;
26:
27: PROCEDURE PRINT_TIME(p_tag IN VARCHAR2 := NULL);
28:
29: PROCEDURE CLEANUP_TEMP_TABLES;

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

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

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

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

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

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

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

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

Line 53: p_event_ids IN SYSTEM.pa_num_tbl_type

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

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

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

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

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

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

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

Line 240: l_fp_version_ids SYSTEM.pa_num_tbl_type := p_fp_version_ids;

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

Line 241: l_fp_version_ids1 SYSTEM.pa_num_tbl_type := p_fp_version_ids;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

388: PROCEDURE PLAN_CREATE (
389: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
390: x_return_status OUT NOCOPY VARCHAR2,
391: x_msg_code OUT NOCOPY VARCHAR2,
392: p_fp_src_version_ids IN SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type(),
393: p_copy_mode in varchar2 :=NULL) IS
394:
395: -- OLAP START CHANGE
396:

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

401: l_cbs_version_id number;
402: l_cbs_enabled_flag VARCHAR2(1);
403:
404:
405: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
406: l_fp_src_version_ids SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
407: l_cnt number ;
408:
409: -- OLAP END CHANGE

Line 406: l_fp_src_version_ids SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();

402: l_cbs_enabled_flag VARCHAR2(1);
403:
404:
405: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
406: l_fp_src_version_ids SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
407: l_cnt number ;
408:
409: -- OLAP END CHANGE
410:

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

812: AND ROWID IN ( SELECT extr_lines_rowid FROM pji_fp_rmap_fpr_update_t)
813: ORDER BY rbs_version_id,struct_ver_id;
814:
815: l_num_rows_extr_lines NUMBER := NULL;
816: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
817: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
818: l_return_status VARCHAR2(1);
819: l_msg_code VARCHAR2(100);
820: l_num_need_to_lock NUMBER;

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

813: ORDER BY rbs_version_id,struct_ver_id;
814:
815: l_num_rows_extr_lines NUMBER := NULL;
816: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
817: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
818: l_return_status VARCHAR2(1);
819: l_msg_code VARCHAR2(100);
820: l_num_need_to_lock NUMBER;
821: l_temp NUMBER;

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

821: l_temp NUMBER;
822:
823: l_update_id NUMBER;
824:
825: p_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
826: p_rbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
827: p_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
828:
829: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

822:
823: l_update_id NUMBER;
824:
825: p_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
826: p_rbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
827: p_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
828:
829: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
830:

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

823: l_update_id NUMBER;
824:
825: p_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
826: p_rbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
827: p_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
828:
829: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
830:
831: l_new_rbs_version_id number;

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

825: p_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
826: p_rbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
827: p_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
828:
829: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
830:
831: l_new_rbs_version_id number;
832: l_new_wbs_version_id number;
833: l_new_plan_version_id number;

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

911: END IF;
912: */
913:
914: IF (p_plan_version_id IS NOT NULL) THEN
915: l_fp_version_ids := SYSTEM.pa_num_tbl_type(p_plan_version_id);
916: print_time ( 'PLAN_UPDATE_PVT 4.999 ');
917: END IF;
918:
919: -------------------------------------------------------------------------

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

1251: , x_return_status OUT NOCOPY VARCHAR2
1252: , x_processing_code OUT NOCOPY VARCHAR2) IS
1253:
1254: l_num_rows_extr_lines NUMBER := NULL;
1255: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1256: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1257: l_return_status VARCHAR2(1);
1258: l_msg_code VARCHAR2(100);
1259: l_num_need_to_lock NUMBER;

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

1252: , x_processing_code OUT NOCOPY VARCHAR2) IS
1253:
1254: l_num_rows_extr_lines NUMBER := NULL;
1255: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1256: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1257: l_return_status VARCHAR2(1);
1258: l_msg_code VARCHAR2(100);
1259: l_num_need_to_lock NUMBER;
1260: l_temp NUMBER;

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

1396: END;
1397:
1398:
1399: PROCEDURE FINPLAN_COPY (
1400: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
1401: p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
1402: p_source_fp_version_types IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
1403: p_dest_fp_version_types IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
1404: x_return_status OUT NOCOPY VARCHAR2,

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

1397:
1398:
1399: PROCEDURE FINPLAN_COPY (
1400: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
1401: p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
1402: p_source_fp_version_types IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
1403: p_dest_fp_version_types IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
1404: x_return_status OUT NOCOPY VARCHAR2,
1405: x_msg_code OUT NOCOPY VARCHAR2 ) IS

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

1403: p_dest_fp_version_types IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
1404: x_return_status OUT NOCOPY VARCHAR2,
1405: x_msg_code OUT NOCOPY VARCHAR2 ) IS
1406:
1407: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1408: l_s_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- s == Source
1409: l_s_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- d == Desination
1410: l_d_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1411: l_d_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

1404: x_return_status OUT NOCOPY VARCHAR2,
1405: x_msg_code OUT NOCOPY VARCHAR2 ) IS
1406:
1407: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1408: l_s_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- s == Source
1409: l_s_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- d == Desination
1410: l_d_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1411: l_d_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1412: l_num_wking_fp_ver_ids NUMBER := NULL;

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

1405: x_msg_code OUT NOCOPY VARCHAR2 ) IS
1406:
1407: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1408: l_s_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- s == Source
1409: l_s_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- d == Desination
1410: l_d_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1411: l_d_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1412: l_num_wking_fp_ver_ids NUMBER := NULL;
1413: l_return_status VARCHAR2(1);

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

1406:
1407: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1408: l_s_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- s == Source
1409: l_s_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- d == Desination
1410: l_d_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1411: l_d_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1412: l_num_wking_fp_ver_ids NUMBER := NULL;
1413: l_return_status VARCHAR2(1);
1414: l_processing_code VARCHAR2(100);

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

1407: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1408: l_s_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- s == Source
1409: l_s_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- d == Desination
1410: l_d_wking_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1411: l_d_bslnd_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1412: l_num_wking_fp_ver_ids NUMBER := NULL;
1413: l_return_status VARCHAR2(1);
1414: l_processing_code VARCHAR2(100);
1415: l_msg_code VARCHAR2(100);

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

1412: l_num_wking_fp_ver_ids NUMBER := NULL;
1413: l_return_status VARCHAR2(1);
1414: l_processing_code VARCHAR2(100);
1415: l_msg_code VARCHAR2(100);
1416: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1417: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1418: l_event_rec pa_pji_proj_events_log%ROWTYPE;
1419:
1420: l_num_src_fp_ver_ids NUMBER := NULL;

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

1413: l_return_status VARCHAR2(1);
1414: l_processing_code VARCHAR2(100);
1415: l_msg_code VARCHAR2(100);
1416: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1417: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1418: l_event_rec pa_pji_proj_events_log%ROWTYPE;
1419:
1420: l_num_src_fp_ver_ids NUMBER := NULL;
1421: l_num_dest_fp_ver_ids NUMBER := NULL;

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

1552: --
1553: -- Copy the plan without creating events.
1554: --
1555:
1556: l_s_fp_version_ids := SYSTEM.pa_num_tbl_type (p_source_fp_version_ids(i) );
1557: l_d_fp_version_ids := SYSTEM.pa_num_tbl_type (p_dest_fp_version_ids(i) );
1558:
1559: print_time ( ' plan copy api .. 008 ' );
1560:

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

1553: -- Copy the plan without creating events.
1554: --
1555:
1556: l_s_fp_version_ids := SYSTEM.pa_num_tbl_type (p_source_fp_version_ids(i) );
1557: l_d_fp_version_ids := SYSTEM.pa_num_tbl_type (p_dest_fp_version_ids(i) );
1558:
1559: print_time ( ' plan copy api .. 008 ' );
1560:
1561: Pji_Fm_Plan_Maint_T_Pvt.COPY_PRIMARY

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

1604: p_event_id IN NUMBER
1605: , x_return_status OUT NOCOPY VARCHAR2
1606: , x_processing_code OUT NOCOPY VARCHAR2) IS
1607:
1608: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1609: l_s_plan_version_id NUMBER := NULL;
1610: l_d_plan_version_id NUMBER := NULL;
1611: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1612: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

1607:
1608: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1609: l_s_plan_version_id NUMBER := NULL;
1610: l_d_plan_version_id NUMBER := NULL;
1611: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1612: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1613: l_working_or_baselined VARCHAR2(30) := 'N';
1614: l_return_status VARCHAR2(1);
1615: l_msg_code VARCHAR2(100);

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

1608: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1609: l_s_plan_version_id NUMBER := NULL;
1610: l_d_plan_version_id NUMBER := NULL;
1611: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1612: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1613: l_working_or_baselined VARCHAR2(30) := 'N';
1614: l_return_status VARCHAR2(1);
1615: l_msg_code VARCHAR2(100);
1616:

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

1628: INTO l_s_plan_version_id, l_d_plan_version_id, l_working_or_baselined
1629: FROM PA_PJI_PROJ_EVENTS_LOG
1630: WHERE event_id = p_event_id;
1631:
1632: l_s_fp_version_ids := SYSTEM.pa_num_tbl_type (l_s_plan_version_id);
1633: l_d_fp_version_ids := SYSTEM.pa_num_tbl_type (l_d_plan_version_id);
1634:
1635: print_time ( ' plan copy PVT api .. 002 ' );
1636:

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

1629: FROM PA_PJI_PROJ_EVENTS_LOG
1630: WHERE event_id = p_event_id;
1631:
1632: l_s_fp_version_ids := SYSTEM.pa_num_tbl_type (l_s_plan_version_id);
1633: l_d_fp_version_ids := SYSTEM.pa_num_tbl_type (l_d_plan_version_id);
1634:
1635: print_time ( ' plan copy PVT api .. 002 ' );
1636:
1637: WBS_HEADERS_LOCK (

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

1667:
1668: --
1669: -- Delete from events table.
1670: --
1671: l_event_ids := SYSTEM.pa_num_tbl_type (p_event_id);
1672:
1673: DELETE_EVENTS (
1674: p_event_ids => l_event_ids
1675: , x_return_status => l_return_status

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

1695: p_new_version_id IN NUMBER,
1696: x_return_status OUT NOCOPY VARCHAR2,
1697: x_msg_code OUT NOCOPY VARCHAR2 ) IS
1698:
1699: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1700: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1701: l_return_status VARCHAR2(1);
1702: l_msg_code VARCHAR2(100);
1703: l_event_id NUMBER;

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

1696: x_return_status OUT NOCOPY VARCHAR2,
1697: x_msg_code OUT NOCOPY VARCHAR2 ) IS
1698:
1699: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1700: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1701: l_return_status VARCHAR2(1);
1702: l_msg_code VARCHAR2(100);
1703: l_event_id NUMBER;
1704: l_event_rec pa_pji_proj_events_log%ROWTYPE;

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

1710: l_plan_type_code CHAR(1);
1711: l_processing_code VARCHAR2(12000);
1712: l_wp_version_flag VARCHAR2(1) := NULL;
1713:
1714: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1715: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1716:
1717: -- OLAP START CHANGE V2
1718:

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

1711: l_processing_code VARCHAR2(12000);
1712: l_wp_version_flag VARCHAR2(1) := NULL;
1713:
1714: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1715: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1716:
1717: -- OLAP START CHANGE V2
1718:
1719: l_msg_count number;

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

1787: ------------------------------------------------------------------------------
1788:
1789: print_time ( ' PLAN_BASELINE api 001.1 ' || p_baseline_version_id || ' ' || p_new_version_id );
1790:
1791: l_s_fp_version_ids := SYSTEM.pa_num_tbl_type (p_baseline_version_id );
1792: l_d_fp_version_ids := SYSTEM.pa_num_tbl_type (p_new_version_id);
1793:
1794: -- OLAP START CHANGE
1795:

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

1788:
1789: print_time ( ' PLAN_BASELINE api 001.1 ' || p_baseline_version_id || ' ' || p_new_version_id );
1790:
1791: l_s_fp_version_ids := SYSTEM.pa_num_tbl_type (p_baseline_version_id );
1792: l_d_fp_version_ids := SYSTEM.pa_num_tbl_type (p_new_version_id);
1793:
1794: -- OLAP START CHANGE
1795:
1796: select p.pjt_rollup_enabled_flag , p.cbs_enable_flag, p.project_id , fpo.rbs_version_id , p.cbs_version_id

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

1891: l_baseline_version_id NUMBER;
1892: l_old_baseline_version_id NUMBER;
1893: l_new_version_id NUMBER;
1894: l_plan_type_id NUMBER;
1895: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1896: l_source_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1897: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1898: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1899: l_return_status VARCHAR2(12000);

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

1892: l_old_baseline_version_id NUMBER;
1893: l_new_version_id NUMBER;
1894: l_plan_type_id NUMBER;
1895: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1896: l_source_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1897: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1898: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1899: l_return_status VARCHAR2(12000);
1900: l_msg_code VARCHAR2(100);

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

1893: l_new_version_id NUMBER;
1894: l_plan_type_id NUMBER;
1895: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1896: l_source_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1897: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1898: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1899: l_return_status VARCHAR2(12000);
1900: l_msg_code VARCHAR2(100);
1901: l_baselined_exists NUMBER;

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

1894: l_plan_type_id NUMBER;
1895: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1896: l_source_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1897: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1898: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1899: l_return_status VARCHAR2(12000);
1900: l_msg_code VARCHAR2(100);
1901: l_baselined_exists NUMBER;
1902: l_new_working_ver_id NUMBER;

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

1901: l_baselined_exists NUMBER;
1902: l_new_working_ver_id NUMBER;
1903: l_processing_code VARCHAR2(1);
1904:
1905: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1906: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1907:
1908: l_last_update_date date := SYSDATE;
1909: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

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

1902: l_new_working_ver_id NUMBER;
1903: l_processing_code VARCHAR2(1);
1904:
1905: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1906: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1907:
1908: l_last_update_date date := SYSDATE;
1909: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1910: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

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

1937: FROM PA_PJI_PROJ_EVENTS_LOG
1938: WHERE event_id = p_event_id;
1939:
1940:
1941: l_dest_fp_version_ids := SYSTEM.pa_num_tbl_type (l_new_version_id);
1942:
1943:
1944: ----------------------------------------------------------------------------------------
1945: -- Insert the missing -3, -4 header records and lock the appropriate versions.

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

2012: ------------------------------------------------------------------------------
2013: -- Delete event.
2014: ------------------------------------------------------------------------------
2015:
2016: l_event_ids := SYSTEM.pa_num_tbl_type (p_event_id);
2017:
2018: DELETE_EVENTS (
2019: p_event_ids => l_event_ids
2020: , x_return_status => l_return_status

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

2037: p_original_version_id IN NUMBER,
2038: x_return_status OUT NOCOPY VARCHAR2,
2039: x_msg_code OUT NOCOPY VARCHAR2 ) IS
2040:
2041: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2042: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2043: l_wp_flag VARCHAR2(1);
2044: l_return_status VARCHAR2(1);
2045: l_msg_code VARCHAR2(100);

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

2038: x_return_status OUT NOCOPY VARCHAR2,
2039: x_msg_code OUT NOCOPY VARCHAR2 ) IS
2040:
2041: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2042: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2043: l_wp_flag VARCHAR2(1);
2044: l_return_status VARCHAR2(1);
2045: l_msg_code VARCHAR2(100);
2046: l_event_id NUMBER;

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

2161: p_event_id IN NUMBER
2162: , x_return_status OUT NOCOPY VARCHAR2
2163: , x_processing_code OUT NOCOPY VARCHAR2) IS
2164:
2165: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2166: l_source_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2167: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2168: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2169: l_wp_flag VARCHAR2(1);

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

2162: , x_return_status OUT NOCOPY VARCHAR2
2163: , x_processing_code OUT NOCOPY VARCHAR2) IS
2164:
2165: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2166: l_source_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2167: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2168: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2169: l_wp_flag VARCHAR2(1);
2170: l_return_status VARCHAR2(1);

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

2163: , x_processing_code OUT NOCOPY VARCHAR2) IS
2164:
2165: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2166: l_source_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2167: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2168: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2169: l_wp_flag VARCHAR2(1);
2170: l_return_status VARCHAR2(1);
2171: l_msg_code VARCHAR2(100);

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

2164:
2165: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2166: l_source_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2167: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2168: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2169: l_wp_flag VARCHAR2(1);
2170: l_return_status VARCHAR2(1);
2171: l_msg_code VARCHAR2(100);
2172: l_event_id NUMBER;

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

2207: ----------------------------------------------------------------------------------------
2208: -- First, need to lock all relevant plan versions, if this is not possible, return.
2209: ----------------------------------------------------------------------------------------
2210:
2211: l_fp_version_ids := SYSTEM.pa_num_tbl_type (l_new_orig_ver_id);
2212:
2213: /*
2214: CHECK_BUDGET_VERSION_EXISTS(l_fp_version_ids);
2215:

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

2297: ------------------------------------------
2298: -- Delete from events table.
2299: ------------------------------------------
2300:
2301: l_event_ids := SYSTEM.pa_num_tbl_type (p_event_id);
2302:
2303: DELETE_EVENTS (
2304: p_event_ids => l_event_ids
2305: , x_return_status => l_return_status

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

2369: , x_return_status OUT NOCOPY VARCHAR2
2370: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
2371:
2372: l_event_rec pa_pji_proj_events_log%ROWTYPE;
2373: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2374: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2375: l_return_status VARCHAR2(1);
2376: l_msg_code VARCHAR2(100);
2377: l_template_flag VARCHAR2(1);

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

2370: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
2371:
2372: l_event_rec pa_pji_proj_events_log%ROWTYPE;
2373: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2374: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2375: l_return_status VARCHAR2(1);
2376: l_msg_code VARCHAR2(100);
2377: l_template_flag VARCHAR2(1);
2378:

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

2463: , x_return_status OUT NOCOPY VARCHAR2
2464: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
2465:
2466: l_event_rec pa_pji_proj_events_log%ROWTYPE;
2467: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2468: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2469: l_return_status VARCHAR2(1);
2470: l_msg_code VARCHAR2(100);
2471:

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

2464: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
2465:
2466: l_event_rec pa_pji_proj_events_log%ROWTYPE;
2467: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2468: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2469: l_return_status VARCHAR2(1);
2470: l_msg_code VARCHAR2(100);
2471:
2472: BEGIN

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

2673: ----------
2674: -- API to lock headers, used by online and bulk summarization apis.
2675: ----------
2676: PROCEDURE WBS_HEADERS_LOCK (
2677: p_fp_version_ids IN OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
2678: , p_context IN VARCHAR2
2679: , x_return_status OUT NOCOPY VARCHAR2
2680: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
2681:

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

2684: l_count NUMBER := 0;
2685: l_count1 NUMBER := 0;
2686: l_num_locked NUMBER := 0;
2687:
2688: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139
2689: l_project_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139
2690: l_baseline_fp_ver_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139
2691: l_wp_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2692: l_latest_pub_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

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

2685: l_count1 NUMBER := 0;
2686: l_num_locked NUMBER := 0;
2687:
2688: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139
2689: l_project_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139
2690: l_baseline_fp_ver_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139
2691: l_wp_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2692: l_latest_pub_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2693: l_baselined_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

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

2686: l_num_locked NUMBER := 0;
2687:
2688: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139
2689: l_project_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139
2690: l_baseline_fp_ver_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --initialized the collection bug#4001139
2691: l_wp_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2692: l_latest_pub_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2693: l_baselined_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2694: l_published_flags SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

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

3385: END;
3386:
3387:
3388: PROCEDURE GET_HDRS_TOLOCK_FOR_UPDATE (
3389: x_fp_version_ids OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
3390: , x_return_status OUT NOCOPY VARCHAR2
3391: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
3392:
3393: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

3389: x_fp_version_ids OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
3390: , x_return_status OUT NOCOPY VARCHAR2
3391: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
3392:
3393: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3394:
3395: CURSOR c_plan_version_ids_cur IS
3396: SELECT DISTINCT plan_version_id
3397: FROM PJI_FM_EXTR_PLAN_LINES

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

3425: END;
3426:
3427:
3428: PROCEDURE GET_EVENT_IDS (
3429: p_fp_version_ids IN SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
3430: , p_operation_type IN VARCHAR2 := NULL
3431: , x_event_ids OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
3432: , x_return_status OUT NOCOPY VARCHAR2
3433: , x_msg_code OUT NOCOPY VARCHAR2 ) IS

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

3427:
3428: PROCEDURE GET_EVENT_IDS (
3429: p_fp_version_ids IN SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
3430: , p_operation_type IN VARCHAR2 := NULL
3431: , x_event_ids OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
3432: , x_return_status OUT NOCOPY VARCHAR2
3433: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
3434:
3435: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

3431: , x_event_ids OUT NOCOPY SYSTEM.pa_num_tbl_type -- := SYSTEM.pa_num_tbl_type(),
3432: , x_return_status OUT NOCOPY VARCHAR2
3433: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
3434:
3435: l_event_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3436: i NUMBER := NULL;
3437: j NUMBER := NULL;
3438:
3439: CURSOR c_event_id_cur (

Line 3481: p_event_ids IN SYSTEM.pa_num_tbl_type

3477: END;
3478:
3479:
3480: PROCEDURE DELETE_EVENTS (
3481: p_event_ids IN SYSTEM.pa_num_tbl_type
3482: , x_return_status OUT NOCOPY VARCHAR2
3483: , x_msg_code OUT NOCOPY VARCHAR2 ) IS
3484: BEGIN
3485:

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

3506: END;
3507:
3508:
3509: PROCEDURE COPY_PJI_SUMMRZD_FLAG (
3510: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
3511: , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ) IS
3512:
3513: l_pji_summarized_flag VARCHAR2(1) := NULL;
3514: l_return_status VARCHAR2(1);

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

3507:
3508:
3509: PROCEDURE COPY_PJI_SUMMRZD_FLAG (
3510: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
3511: , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ) IS
3512:
3513: l_pji_summarized_flag VARCHAR2(1) := NULL;
3514: l_return_status VARCHAR2(1);
3515:

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

4158: l_chd_dev_status VARCHAR2(400);
4159: l_chd_message VARCHAR2(2000);
4160: l_plan_version_id NUMBER;
4161:
4162: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4163: l_struct_sharing_code pa_projects_all.structure_sharing_code%TYPE;
4164: CURSOR c_pln_ver_list (p_old_struct_ver_id IN NUMBER) IS
4165: SELECT project_id, plan_version_id
4166: FROM pji_pjp_wbs_header

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

5535: --there are no pending event for the plan version
5536: ---------------------------------------------------------------
5537: PROCEDURE process_plan_events (
5538: p_project_id IN NUMBER,
5539: p_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
5540: x_processing_code OUT NOCOPY VARCHAR2,
5541: x_msg_count OUT NOCOPY NUMBER,
5542: x_msg_data OUT NOCOPY VARCHAR2,
5543: x_return_status OUT NOCOPY VARCHAR2 )

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

5755: -- Create on demand slices.
5756: --
5757: PROCEDURE maintain_smart_slice (
5758: p_rbs_version_id IN NUMBER :=NULL,
5759: p_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
5760: p_wbs_element_id IN NUMBER,
5761: p_rbs_element_id IN NUMBER,
5762: p_prg_rollup_flag IN VARCHAR2,
5763: p_curr_record_type_id IN NUMBER,

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

5763: p_curr_record_type_id IN NUMBER,
5764: p_calendar_type IN VARCHAR2,
5765: p_wbs_version_id IN NUMBER,
5766: p_commit IN VARCHAR2 := 'Y',
5767: p_rbs_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
5768: x_msg_count OUT NOCOPY NUMBER,
5769: x_msg_data OUT NOCOPY VARCHAR2,
5770: x_return_status OUT NOCOPY VARCHAR2) IS
5771:

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

5773: -- l_rollup_status_exists VARCHAR2(1) := 'N';
5774: l_exists VARCHAR2(1) := 'N';
5775: l_struct_element_id NUMBER := -1;
5776: l_project_id NUMBER := 1;
5777: l_proj_element_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5778: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5779: l_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
5780: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5781: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

5774: l_exists VARCHAR2(1) := 'N';
5775: l_struct_element_id NUMBER := -1;
5776: l_project_id NUMBER := 1;
5777: l_proj_element_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5778: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5779: l_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
5780: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5781: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5782: l_count NUMBER := 1;

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

5776: l_project_id NUMBER := 1;
5777: l_proj_element_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5778: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5779: l_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
5780: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5781: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5782: l_count NUMBER := 1;
5783:
5784: l_last_update_date date := SYSDATE;

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

5777: l_proj_element_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5778: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5779: l_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
5780: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5781: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5782: l_count NUMBER := 1;
5783:
5784: l_last_update_date date := SYSDATE;
5785: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

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

5785: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5786: l_creation_date date := SYSDATE;
5787: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5788: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5789: il_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5790: il_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5791: il_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5792: il_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5793: l_prg_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

5787: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5788: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5789: il_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5790: il_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5791: il_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5792: il_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5793: l_prg_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5794: l_prg_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5795: l_prg_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

5788: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5789: il_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5790: il_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5791: il_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5792: il_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5793: l_prg_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5794: l_prg_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5795: l_prg_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5796: l_prg_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

5789: il_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5790: il_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5791: il_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5792: il_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5793: l_prg_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5794: l_prg_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5795: l_prg_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5796: l_prg_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5797: l_prg_count NUMBER := 1;

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

5791: il_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5792: il_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5793: l_prg_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5794: l_prg_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5795: l_prg_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5796: l_prg_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5797: l_prg_count NUMBER := 1;
5798: l_roll_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5799: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

5792: il_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5793: l_prg_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5794: l_prg_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5795: l_prg_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5796: l_prg_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5797: l_prg_count NUMBER := 1;
5798: l_roll_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5799: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5800: l_get_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

5794: l_prg_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5795: l_prg_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5796: l_prg_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5797: l_prg_count NUMBER := 1;
5798: l_roll_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5799: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5800: l_get_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5801: l_get_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5802: l_wbs_count NUMBER:=2;

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

5795: l_prg_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5796: l_prg_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5797: l_prg_count NUMBER := 1;
5798: l_roll_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5799: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5800: l_get_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5801: l_get_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5802: l_wbs_count NUMBER:=2;
5803: l_wbs_exists NUMBER :=0;

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

5796: l_prg_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5797: l_prg_count NUMBER := 1;
5798: l_roll_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5799: l_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5800: l_get_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5801: l_get_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5802: l_wbs_count NUMBER:=2;
5803: l_wbs_exists NUMBER :=0;
5804: validcount NUMBER:=1;

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

5801: l_get_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5802: l_wbs_count NUMBER:=2;
5803: l_wbs_exists NUMBER :=0;
5804: validcount NUMBER:=1;
5805: jl_get_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /*4471527 */
5806: jl_get_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5807: jl_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /*4471527 */
5808: l_rbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5809:

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

5803: l_wbs_exists NUMBER :=0;
5804: validcount NUMBER:=1;
5805: jl_get_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /*4471527 */
5806: jl_get_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5807: jl_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /*4471527 */
5808: l_rbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5809:
5810: -- OLAP START
5811:

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

5804: validcount NUMBER:=1;
5805: jl_get_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /*4471527 */
5806: jl_get_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5807: jl_get_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /*4471527 */
5808: l_rbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5809:
5810: -- OLAP START
5811:
5812: l_pjt_rollup_enabled_flag varchar2(1) ;

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

7030: --
7031: -- Checks if list of plan versions exist in budget versions table.
7032: --
7033: PROCEDURE CHECK_BUDGET_VERSION_EXISTS (
7034: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ) IS
7035: i NUMBER;
7036: l_project_id NUMBER;
7037: l_return_status VARCHAR2(1);
7038: BEGIN

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

7088: ----------
7089: -- Prints the list of plan versions in a given table of plan versions.
7090: ----------
7091: PROCEDURE PRINT_PLAN_VERSION_ID_LIST
7092: ( p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ) IS
7093: i NUMBER;
7094: l_return_status VARCHAR2(1);
7095: BEGIN
7096: