[Home] [Help]
3:
4:
5: g_package_name VARCHAR2(100) := 'PJI_FM_PLAN_CAL_RLPS_T';
6:
7: g_worker_id NUMBER := 1; -- 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_T
53: (
54: WORKER_ID
274: l_line_type VARCHAR2(15) := 'PAR';
275:
276: BEGIN
277:
278: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
279:
280: INSERT INTO pji_fp_aggr_pjp1_t
281: (
282: WORKER_ID
512: l_line_type VARCHAR2(15) := 'GLR';
513:
514: BEGIN
515:
516: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
517:
518: INSERT INTO pji_fp_aggr_pjp1_t
519: (
520: WORKER_ID
755: l_time_phase_change NUMBER := 0;
756:
757: BEGIN
758:
759: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
760:
761: IF (p_calendar_type NOT IN ('P', 'G','C') ) THEN -- 'C' for time phase change
762: RETURN;
763: ELSE
1358: l_period_type_id NUMBER := 2048;
1359:
1360: BEGIN
1361:
1362: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1363:
1364: INSERT INTO pji_fp_aggr_pjp1_t
1365: (
1366: WORKER_ID
1581: -- l_created_by NUMBER := FND_GLOBAL.USER_ID;
1582: -- l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1583: BEGIN
1584:
1585: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1586:
1587: INSERT INTO pji_fp_aggr_pjp1_t
1588: (
1589: WORKER_ID
1824: -- l_created_by NUMBER := FND_GLOBAL.USER_ID;
1825: -- l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1826: BEGIN
1827:
1828: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1829:
1830: INSERT INTO pji_fp_aggr_pjp1_t
1831: (
1832: WORKER_ID
2067: -- l_created_by NUMBER := FND_GLOBAL.USER_ID;
2068: -- l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2069: BEGIN
2070:
2071: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2072:
2073: INSERT INTO pji_fp_aggr_pjp1_t
2074: (
2075: WORKER_ID
2303:
2304: PROCEDURE CREATE_AC_PA_ROLLUP IS
2305: BEGIN
2306:
2307: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2308:
2309: INSERT INTO pji_ac_aggr_pjp1_t
2310: (
2311: WORKER_ID
2486:
2487: PROCEDURE CREATE_AC_GL_ROLLUP IS
2488: BEGIN
2489:
2490: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2491:
2492: INSERT INTO pji_ac_aggr_pjp1_t
2493: (
2494: worker_id
2668:
2669: PROCEDURE CREATE_AC_ENT_ROLLUP IS
2670: BEGIN
2671:
2672: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2673:
2674: INSERT INTO pji_ac_aggr_pjp1_t
2675: (
2676: worker_id
2859: l_line_type VARCHAR2(15);
2860:
2861: BEGIN
2862:
2863: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2864:
2865: IF (p_calendar_type NOT IN ('P', 'G') ) THEN
2866: RETURN;
2867: ELSE
3053: --
3054: PROCEDURE PRORATE_TO_ENT_PG_PJP1_D IS
3055: BEGIN
3056:
3057: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
3058:
3059: /* Commented for bug 4005006
3060: INSERT INTO pji_fp_aggr_pjp1_t
3061: (
4492:
4493: PROCEDURE PRORATE_TO_ENT_PG_FPRL_D IS
4494: BEGIN
4495:
4496: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4497:
4498: INSERT INTO pji_fp_aggr_pjp1_t -- PA, GL calendar entries in FP Reporting lines.
4499: (
4500: WORKER_ID
5640:
5641: PROCEDURE PRORATE_TO_ENT_N_PJP1_D IS
5642: BEGIN
5643:
5644: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
5645:
5646: /* Commented for bug 4005006
5647: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries in pjp1 table.
5648: (
7085:
7086: PROCEDURE PRORATE_TO_ENT_PG_PJP1_SE( p_prorating_format varchar2) IS
7087: BEGIN
7088:
7089: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
7090:
7091: /* Commented for bug 4005006
7092: INSERT INTO pji_fp_aggr_pjp1_t -- PA, GL calendar entries.
7093: (
7493:
7494: PROCEDURE PRORATE_TO_ENT_PG_FPRL_SE IS
7495: BEGIN
7496:
7497: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
7498:
7499: INSERT INTO pji_fp_aggr_pjp1_t -- PA, GL calendar entries.
7500: (
7501: WORKER_ID
7696:
7697: PROCEDURE PRORATE_TO_ENT_N_PJP1_SE( p_prorating_format varchar2) IS
7698: BEGIN
7699:
7700: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
7701:
7702: /* Commented for bug 4005006
7703:
7704: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries.
8117:
8118: PROCEDURE PRORATE_TO_PAGL_PGE_PJP1_D (p_calendar_type IN VARCHAR2 := NULL) IS
8119: BEGIN
8120:
8121: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
8122:
8123: /* Commented for bug 4005006
8124: INSERT INTO pji_fp_aggr_pjp1_t
8125: (
9582:
9583: PROCEDURE PRORATE_TO_PAGL_PGE_FPRL_D (p_calendar_type IN VARCHAR2 := NULL) IS
9584: BEGIN
9585:
9586: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
9587:
9588: INSERT INTO pji_fp_aggr_pjp1_t
9589: (
9590: worker_id
10742: IF (p_calendar_type NOT IN ('P', 'G')) THEN
10743: RETURN;
10744: END IF;
10745:
10746: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
10747:
10748: /* Commented for bug 4005006
10749: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries..
10750: (
12198: PROCEDURE PRORATE_TO_PAGL_PGE_PJP1_SE (p_calendar_type IN VARCHAR2 := NULL,
12199: p_prorating_format IN VARCHAR2) IS
12200: BEGIN
12201:
12202: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
12203:
12204: /* Commented for bug 4005006
12205: INSERT INTO pji_fp_aggr_pjp1_t -- For PA/GL entries.
12206: (
12607:
12608: PROCEDURE PRORATE_TO_PAGL_PGE_FPRL_SE (p_calendar_type IN VARCHAR2 := NULL) IS
12609: BEGIN
12610:
12611: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
12612:
12613: INSERT INTO pji_fp_aggr_pjp1_t -- For PA/GL entries.
12614: (
12615: worker_id
12826: IF (p_calendar_type NOT IN ('P', 'G')) THEN
12827: RETURN;
12828: END IF;
12829:
12830: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
12831: /* Commented for bug 4005006
12832: INSERT INTO pji_fp_aggr_pjp1_t -- For non time phased entries.
12833: (
12834: worker_id
13260: -- Print time API to measure time taken by each api. Also useful for debugging.
13261: ----------
13262: PROCEDURE PRINT_TIME(p_tag IN VARCHAR2) IS
13263: BEGIN
13264: PJI_PJP_FP_CURR_WRAP.print_time(p_tag);
13265: EXCEPTION
13266: WHEN OTHERS THEN
13267: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
13268: p_procedure_name => 'PRINT_TIME');