[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: PROCEDURE PRINT_TIME(p_tag IN VARCHAR2);
11:
71: ra.task_id, plnt.plan_type_code, plnt.plan_version_id, plnt.rbs_struct_version_id; /* For bug 10305483 */
72: /* End of Bug# 9737300 */
73: BEGIN
74:
75: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
76:
77: INSERT INTO PJI_FP_AGGR_PJP1_T
78: (
79: WORKER_ID
395: l_line_type VARCHAR2(15) := 'PAR';
396:
397: BEGIN
398:
399: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
400:
401: INSERT INTO pji_fp_aggr_pjp1_t
402: (
403: WORKER_ID
633: l_line_type VARCHAR2(15) := 'GLR';
634:
635: BEGIN
636:
637: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
638:
639: INSERT INTO pji_fp_aggr_pjp1_t
640: (
641: WORKER_ID
879: BEGIN
880:
881: l_calendar_type := p_calendar_type; /* Added for bug 9067086 */
882:
883: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
884: /* Added for bug 9067086 starts */
885: if (pji_utils.get_setup_parameter('TIME_PHASE_FLAG') = 'Y' )
886: and (l_calendar_type is null) then
887: select min(calendar_type)
1496: l_period_type_id NUMBER := 2048;
1497:
1498: BEGIN
1499:
1500: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1501:
1502: INSERT INTO pji_fp_aggr_pjp1_t
1503: (
1504: WORKER_ID
1719: -- l_created_by NUMBER := FND_GLOBAL.USER_ID;
1720: -- l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1721: BEGIN
1722:
1723: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1724:
1725: INSERT INTO pji_fp_aggr_pjp1_t
1726: (
1727: WORKER_ID
1962: -- l_created_by NUMBER := FND_GLOBAL.USER_ID;
1963: -- l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1964: BEGIN
1965:
1966: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1967:
1968: INSERT INTO pji_fp_aggr_pjp1_t
1969: (
1970: WORKER_ID
2205: -- l_created_by NUMBER := FND_GLOBAL.USER_ID;
2206: -- l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2207: BEGIN
2208:
2209: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2210:
2211: INSERT INTO pji_fp_aggr_pjp1_t
2212: (
2213: WORKER_ID
2441:
2442: PROCEDURE CREATE_AC_PA_ROLLUP IS
2443: BEGIN
2444:
2445: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2446:
2447: INSERT INTO pji_ac_aggr_pjp1_t
2448: (
2449: WORKER_ID
2624:
2625: PROCEDURE CREATE_AC_GL_ROLLUP IS
2626: BEGIN
2627:
2628: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2629:
2630: INSERT INTO pji_ac_aggr_pjp1_t
2631: (
2632: worker_id
2806:
2807: PROCEDURE CREATE_AC_ENT_ROLLUP IS
2808: BEGIN
2809:
2810: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2811:
2812: INSERT INTO pji_ac_aggr_pjp1_t
2813: (
2814: worker_id
2997: l_line_type VARCHAR2(15);
2998:
2999: BEGIN
3000:
3001: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
3002:
3003: IF (p_calendar_type NOT IN ('P', 'G') ) THEN
3004: RETURN;
3005: ELSE
3191: --
3192: PROCEDURE PRORATE_TO_ENT_PG_PJP1_D IS
3193: BEGIN
3194:
3195: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
3196:
3197: /* Commented for bug 4005006
3198: INSERT INTO pji_fp_aggr_pjp1_t
3199: (
4630:
4631: PROCEDURE PRORATE_TO_ENT_PG_FPRL_D IS
4632: BEGIN
4633:
4634: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4635:
4636: INSERT INTO pji_fp_aggr_pjp1_t -- PA, GL calendar entries in FP Reporting lines.
4637: (
4638: WORKER_ID
5778:
5779: PROCEDURE PRORATE_TO_ENT_N_PJP1_D IS
5780: BEGIN
5781:
5782: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
5783:
5784: /* Commented for bug 4005006
5785: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries in pjp1 table.
5786: (
7223:
7224: PROCEDURE PRORATE_TO_ENT_PG_PJP1_SE( p_prorating_format varchar2) IS
7225: BEGIN
7226:
7227: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
7228:
7229: /* Commented for bug 4005006
7230: INSERT INTO pji_fp_aggr_pjp1_t -- PA, GL calendar entries.
7231: (
7631:
7632: PROCEDURE PRORATE_TO_ENT_PG_FPRL_SE IS
7633: BEGIN
7634:
7635: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
7636:
7637: INSERT INTO pji_fp_aggr_pjp1_t -- PA, GL calendar entries.
7638: (
7639: WORKER_ID
7834:
7835: PROCEDURE PRORATE_TO_ENT_N_PJP1_SE( p_prorating_format varchar2) IS
7836: BEGIN
7837:
7838: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
7839:
7840: /* Commented for bug 4005006
7841:
7842: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries.
8255:
8256: PROCEDURE PRORATE_TO_PAGL_PGE_PJP1_D (p_calendar_type IN VARCHAR2 := NULL) IS
8257: BEGIN
8258:
8259: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
8260:
8261: /* Commented for bug 4005006
8262: INSERT INTO pji_fp_aggr_pjp1_t
8263: (
9720:
9721: PROCEDURE PRORATE_TO_PAGL_PGE_FPRL_D (p_calendar_type IN VARCHAR2 := NULL) IS
9722: BEGIN
9723:
9724: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
9725:
9726: INSERT INTO pji_fp_aggr_pjp1_t
9727: (
9728: worker_id
10880: IF (p_calendar_type NOT IN ('P', 'G')) THEN
10881: RETURN;
10882: END IF;
10883:
10884: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
10885:
10886: /* Commented for bug 4005006
10887: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries..
10888: (
12336: PROCEDURE PRORATE_TO_PAGL_PGE_PJP1_SE (p_calendar_type IN VARCHAR2 := NULL,
12337: p_prorating_format IN VARCHAR2) IS
12338: BEGIN
12339:
12340: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
12341:
12342: /* Commented for bug 4005006
12343: INSERT INTO pji_fp_aggr_pjp1_t -- For PA/GL entries.
12344: (
12745:
12746: PROCEDURE PRORATE_TO_PAGL_PGE_FPRL_SE (p_calendar_type IN VARCHAR2 := NULL) IS
12747: BEGIN
12748:
12749: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
12750:
12751: INSERT INTO pji_fp_aggr_pjp1_t -- For PA/GL entries.
12752: (
12753: worker_id
12964: IF (p_calendar_type NOT IN ('P', 'G')) THEN
12965: RETURN;
12966: END IF;
12967:
12968: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
12969: /* Commented for bug 4005006
12970: INSERT INTO pji_fp_aggr_pjp1_t -- For non time phased entries.
12971: (
12972: worker_id
13398: -- Print time API to measure time taken by each api. Also useful for debugging.
13399: ----------
13400: PROCEDURE PRINT_TIME(p_tag IN VARCHAR2) IS
13401: BEGIN
13402: PJI_PJP_FP_CURR_WRAP.print_time(p_tag);
13403: EXCEPTION
13404: WHEN OTHERS THEN
13405: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
13406: p_procedure_name => 'PRINT_TIME');