[Home] [Help]
133:
134: PROCEDURE CREATE_FP_ENT_ROLLUP IS -- Public
135: BEGIN
136:
137: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
138:
139: INSERT /*+ parallel(pjp1) */ INTO PJI_FP_AGGR_PJP1 pjp1
140: (
141: WORKER_ID
347: l_line_type VARCHAR2(15) := 'PAR';
348:
349: BEGIN
350:
351: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
352:
353: INSERT /*+ parallel(pjp1) */ INTO pji_fp_aggr_pjp1 pjp1
354: (
355: WORKER_ID
564: l_pji_schema varchar2(30); /* Added for Bug 13813361 */
565:
566: BEGIN
567:
568: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
569:
570: /* Added for Bug 13813361 Start */
571: l_process := PJI_PJP_SUM_MAIN.G_PROCESS || to_char(g_worker_id);
572: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,'EXTRACTION_TYPE');
871: l_plan_type_id Number;
872:
873: BEGIN
874:
875: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
876:
877: /* Added calendar type 'C' for bug 6109930 */
878: IF (p_calendar_type NOT IN ('P', 'G', 'C') ) THEN
879: RETURN;
1109:
1110: PROCEDURE PRORATE_TO_ENT_PG_PJP1_D IS
1111: BEGIN
1112:
1113: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1114:
1115: INSERT INTO pji_fp_aggr_pjp1
1116: (
1117: WORKER_ID
1404:
1405: PROCEDURE PRORATE_TO_ENT_N_PJP1_D IS
1406: BEGIN
1407:
1408: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1409:
1410: INSERT INTO pji_fp_aggr_pjp1 -- Non time phased entries in pjp1 table.
1411: (
1412: WORKER_ID
1699:
1700: PROCEDURE PRORATE_TO_PAGL_PGE_PJP1_D (p_calendar_type IN VARCHAR2 := NULL) IS
1701: BEGIN
1702:
1703: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1704:
1705: INSERT INTO pji_fp_aggr_pjp1
1706: (
1707: worker_id
2018: IF (p_calendar_type NOT IN ('P', 'G')) THEN
2019: RETURN;
2020: END IF;
2021:
2022: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2023:
2024: INSERT INTO pji_fp_aggr_pjp1 -- Non time phased entries..
2025: (
2026: worker_id
2326: l_pji_schema varchar2(30); /* Added for Bug 13813361 */
2327:
2328: BEGIN
2329:
2330: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2331: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME; /* Added for Bug 13813361 */
2332:
2333: /* Added for Bug 13813361 Start */
2334: IF PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
2531: l_pji_schema varchar2(30); /* Added for Bug 13813361 */
2532:
2533: BEGIN
2534:
2535: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2536: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME; /* Added for Bug 13813361 */
2537:
2538: INSERT /*+ append parallel(rl) */ INTO pji_fp_xbs_accum_f rl
2539: (
2712: l_gl2_mau NUMBER := g_global2_currency_mau;
2713:
2714: BEGIN
2715:
2716: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2717:
2718: PJI_PJP_FP_CURR_WRAP.get_global_currency_info (
2719: x_currency_conversion_rule => g_currency_conversion_rule
2720: , x_prorating_format => g_prorating_format
2714: BEGIN
2715:
2716: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2717:
2718: PJI_PJP_FP_CURR_WRAP.get_global_currency_info (
2719: x_currency_conversion_rule => g_currency_conversion_rule
2720: , x_prorating_format => g_prorating_format
2721: , x_global1_currency_code => g_global1_currency_code
2722: , x_global2_currency_code => g_global2_currency_code
2885: PROCEDURE PRORATE_TO_ENT IS
2886: l_calendar_type VARCHAR2(15) := 'E';
2887: BEGIN
2888:
2889: PJI_PJP_FP_CURR_WRAP.get_global_currency_info (
2890: x_currency_conversion_rule => g_currency_conversion_rule
2891: , x_prorating_format => g_prorating_format
2892: , x_global1_currency_code => g_global1_currency_code
2893: , x_global2_currency_code => g_global2_currency_code
2894: , x_global1_currency_mau => g_global1_currency_mau
2895: , x_global2_currency_mau => g_global2_currency_mau ) ;
2896:
2897:
2898: PJI_PJP_FP_CURR_WRAP.get_ent_dates_info (
2899: x_global_start_date => g_global_start_date
2900: , x_ent_start_period_id => g_ent_start_period_id
2901: , x_ent_start_period_name => g_ent_start_period_name
2902: , x_ent_start_date => g_ent_start_date
2938: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2939:
2940: BEGIN
2941:
2942: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2943:
2944: INSERT INTO pji_pjp_rbs_header
2945: (
2946: project_id
2997: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2998:
2999: BEGIN
3000:
3001: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
3002:
3003: commit;
3004: delete from pji_fp_aggr_pjp1_t; -- 5309891
3005:
3071:
3072: PROCEDURE EXTRACT_PLAN_AMTS_PRIRBS_GLC12 IS
3073: BEGIN
3074:
3075: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
3076:
3077: PJI_PJP_FP_CURR_WRAP.get_global_currency_info (
3078: x_currency_conversion_rule => g_currency_conversion_rule
3079: , x_prorating_format => g_prorating_format
3073: BEGIN
3074:
3075: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
3076:
3077: PJI_PJP_FP_CURR_WRAP.get_global_currency_info (
3078: x_currency_conversion_rule => g_currency_conversion_rule
3079: , x_prorating_format => g_prorating_format
3080: , x_global1_currency_code => g_global1_currency_code
3081: , x_global2_currency_code => g_global2_currency_code
4187:
4188: PROCEDURE EXTRACT_DANGL_REVERSAL IS
4189: BEGIN
4190:
4191: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4192:
4193: INSERT INTO PJI_FP_AGGR_PJP1
4194: (
4195: WORKER_ID
4452: max_txn_date_tab max_txn_date_tab_type;
4453:
4454: BEGIN
4455:
4456: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4457: OPEN wbs_cur;
4458:
4459: LOOP
4460: FETCH wbs_cur BULK COLLECT
4512: l_pji_rowid_tab l_pji_rowid_tbl_type;
4513:
4514: BEGIN
4515:
4516: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4517:
4518: -- gather statistics for PJI metadata tables
4519: GATHER_TEMP_STATS1(p_ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4520: p_tabname => 'PJI_FP_AGGR_PJP2',
25853: end EXECUTE_AGGREGATE_PLAN_DATA;
25854:
25855: BEGIN -- this portion is executed WHENever the package is initialized
25856:
25857: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
25858:
25859: END PJI_PJP_PRG_PERF_ALL;