[Home] [Help]
3:
4:
5: g_package_name VARCHAR2(100) := 'PJI_FM_PLAN_CAL_RLPS';
6:
7: g_worker_id NUMBER := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
8: g_default_prg_level NUMBER := 0;
9:
10:
11: PROCEDURE PRINT_TIME(p_tag IN VARCHAR2);
46:
47: PROCEDURE CREATE_FP_ENT_ROLLUP IS -- Public
48: BEGIN
49:
50: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
51:
52: INSERT INTO PJI_FP_AGGR_PJP1
53: (
54: WORKER_ID
266: l_line_type VARCHAR2(15) := 'PAR';
267:
268: BEGIN
269:
270: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
271:
272: INSERT INTO pji_fp_aggr_pjp1
273: (
274: WORKER_ID
485: l_line_type VARCHAR2(15) := 'GLR';
486:
487: BEGIN
488:
489: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
490:
491: INSERT INTO pji_fp_aggr_pjp1
492: (
493: WORKER_ID
707: l_plan_type_id Number; --Bug 6381284
708:
709: BEGIN
710:
711: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
712:
713: /* Added calendar type 'C' for bug 6381284 */
714: IF (p_calendar_type NOT IN ('P', 'G', 'C') ) THEN
715: RETURN;
1082:
1083: PROCEDURE CREATE_AC_PA_ROLLUP IS
1084: BEGIN
1085:
1086: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1087:
1088: INSERT INTO PJI_AC_AGGR_PJP1
1089: (
1090: WORKER_ID
1265:
1266: PROCEDURE CREATE_AC_GL_ROLLUP IS
1267: BEGIN
1268:
1269: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1270:
1271: INSERT INTO PJI_AC_AGGR_PJP1
1272: (
1273: worker_id
1447:
1448: PROCEDURE CREATE_AC_ENT_ROLLUP IS
1449: BEGIN
1450:
1451: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1452:
1453: INSERT INTO PJI_AC_AGGR_PJP1
1454: (
1455: worker_id
1638: l_line_type VARCHAR2(15);
1639:
1640: BEGIN
1641:
1642: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1643:
1644: IF (p_calendar_type NOT IN ('P', 'G') ) THEN
1645: RETURN;
1646: ELSE
1650: l_line_type := 'GLR';
1651: END IF;
1652: END IF;
1653:
1654: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1655:
1656: INSERT INTO PJI_AC_AGGR_PJP1
1657: (
1658: worker_id
1837: --
1838: PROCEDURE PRORATE_TO_ENT_PG_PJP1_D IS
1839: BEGIN
1840:
1841: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1842:
1843: /* Commented for bug 4005006
1844: INSERT INTO pji_fp_aggr_pjp1
1845: (
3277:
3278: PROCEDURE PRORATE_TO_ENT_PG_FPRL_D IS
3279: BEGIN
3280:
3281: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
3282:
3283: EXCEPTION
3284: WHEN OTHERS THEN
3285: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
3290:
3291: PROCEDURE PRORATE_TO_ENT_N_PJP1_D IS
3292: BEGIN
3293:
3294: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
3295:
3296: INSERT INTO pji_fp_aggr_pjp1 -- Non time phased entries in pjp1 table.
3297: (
3298: WORKER_ID
3586:
3587: PROCEDURE PRORATE_TO_ENT_PG_PJP1_SE(p_prorating_format IN VARCHAR2) IS
3588: BEGIN
3589:
3590: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
3591:
3592: /* Commented for bug 4005006
3593:
3594: INSERT INTO pji_fp_aggr_pjp1 -- PA, GL calendar entries.
3997:
3998: PROCEDURE PRORATE_TO_ENT_PG_FPRL_SE IS
3999: BEGIN
4000:
4001: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4002:
4003: EXCEPTION
4004: WHEN OTHERS THEN
4005: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4010:
4011: PROCEDURE PRORATE_TO_ENT_N_PJP1_SE(p_prorating_format varchar2) IS
4012: BEGIN
4013:
4014: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4015:
4016: INSERT INTO pji_fp_aggr_pjp1 -- Non time phased entries.
4017: (
4018: WORKER_ID
4221:
4222: PROCEDURE PRORATE_TO_PAGL_PGE_PJP1_D (p_calendar_type IN VARCHAR2 := NULL) IS
4223: BEGIN
4224:
4225: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4226:
4227: INSERT INTO pji_fp_aggr_pjp1
4228: (
4229: worker_id
4539:
4540: PROCEDURE PRORATE_TO_PAGL_PGE_FPRL_D (p_calendar_type IN VARCHAR2 := NULL) IS
4541: BEGIN
4542:
4543: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4544:
4545: EXCEPTION
4546: WHEN OTHERS THEN
4547: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4556: IF (p_calendar_type NOT IN ('P', 'G')) THEN
4557: RETURN;
4558: END IF;
4559:
4560: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4561:
4562: INSERT INTO pji_fp_aggr_pjp1 -- Non time phased entries..
4563: (
4564: worker_id
4861: PROCEDURE PRORATE_TO_PAGL_PGE_PJP1_SE (p_calendar_type IN VARCHAR2 := NULL,
4862: p_prorating_format IN VARCHAR2) IS
4863: BEGIN
4864:
4865: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4866:
4867: INSERT INTO pji_fp_aggr_pjp1 -- For PA/GL entries.
4868: (
4869: worker_id
5073:
5074: PROCEDURE PRORATE_TO_PAGL_PGE_FPRL_SE (p_calendar_type IN VARCHAR2 := NULL) IS
5075: BEGIN
5076:
5077: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
5078:
5079: EXCEPTION
5080: WHEN OTHERS THEN
5081: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5087: PROCEDURE PRORATE_TO_PAGL_N_PJP1_SE (p_calendar_type IN VARCHAR2 := NULL,
5088: p_prorating_format IN VARCHAR2) IS
5089: BEGIN
5090:
5091: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
5092:
5093: INSERT INTO pji_fp_aggr_pjp1 -- For non time phased entries.
5094: (
5095: worker_id
5306: -- Print time API to measure time taken by each api. Also useful for debugging.
5307: ----------
5308: PROCEDURE PRINT_TIME(p_tag IN VARCHAR2) IS
5309: BEGIN
5310: PJI_PJP_FP_CURR_WRAP.print_time(p_tag);
5311: EXCEPTION
5312: WHEN OTHERS THEN
5313: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5314: p_procedure_name => 'PRINT_TIME');