eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_RM_SUM_AVL dependencies on PJI_RM_AGGR_AVL3

Line 4: --Defining Global PL/SQL Table variables for bulk insert in PJI_RM_AGGR_AVL3

1: PACKAGE BODY PJI_RM_SUM_AVL AS
2: /* $Header: PJISR04B.pls 120.7 2006/05/03 17:15:08 appldev noship $ */
3:
4: --Defining Global PL/SQL Table variables for bulk insert in PJI_RM_AGGR_AVL3
5: g_exp_organization_id_in_tbl N_TYPE_TAB;
6: g_exp_org_id_in_tbl N_TYPE_TAB;
7: g_period_type_id_in_tbl N_TYPE_TAB;
8: g_time_id_in_tbl N_TYPE_TAB;

Line 354: INSERT INTO PJI_RM_AGGR_AVL3

350: BEGIN
351: IF (p_blind_insert_flag = 'Y') THEN
352: IF (p_run_mode = 'OLD_FACT_RECORDS') THEN
353: FORALL k IN 1.. g_exp_organization_id_in_tbl.count
354: INSERT INTO PJI_RM_AGGR_AVL3
355: (
356: EXPENDITURE_ORGANIZATION_ID,
357: EXPENDITURE_ORG_ID,
358: PERIOD_TYPE_ID,

Line 400: INSERT INTO PJI_RM_AGGR_AVL3

396: -g_total_res_cnt_in_tbl(k)
397: );
398: ELSE
399: FORALL k IN 1.. g_exp_organization_id_in_tbl.count
400: INSERT INTO PJI_RM_AGGR_AVL3
401: (
402: EXPENDITURE_ORGANIZATION_ID,
403: EXPENDITURE_ORG_ID,
404: PERIOD_TYPE_ID,

Line 482: INSERT INTO PJI_RM_AGGR_AVL3

478:
479: IF (g_exp_organization_id_in_tbl.COUNT >= l_max_count) THEN
480: IF (p_run_mode = 'OLD_FACT_RECORDS') THEN
481: FORALL k IN 1.. g_exp_organization_id_in_tbl.count
482: INSERT INTO PJI_RM_AGGR_AVL3
483: (
484: EXPENDITURE_ORGANIZATION_ID,
485: EXPENDITURE_ORG_ID,
486: PERIOD_TYPE_ID,

Line 528: INSERT INTO PJI_RM_AGGR_AVL3

524: -g_total_res_cnt_in_tbl(k)
525: );
526: ELSE
527: FORALL k IN 1.. g_exp_organization_id_in_tbl.count
528: INSERT INTO PJI_RM_AGGR_AVL3
529: (
530: EXPENDITURE_ORGANIZATION_ID,
531: EXPENDITURE_ORG_ID,
532: PERIOD_TYPE_ID,

Line 597: --Defining PL/SQL Table variables for bulk insert in PJI_RM_AGGR_AVL3

593: x_zero_bkt_cnt_flag OUT NOCOPY VARCHAR2
594: )
595: IS
596:
597: --Defining PL/SQL Table variables for bulk insert in PJI_RM_AGGR_AVL3
598: l_worker_id_in_tbl N_TYPE_TAB;
599: l_exp_organization_id_in_tbl N_TYPE_TAB;
600: l_exp_org_id_in_tbl N_TYPE_TAB;
601: l_period_type_id_in_tbl N_TYPE_TAB;

Line 2091: --PJI_RM_AGGR_AVL3 table

2087: l_ent_pd_res_cnt_tbl(15) := GREATEST (l_ent_pd_res_cnt_tbl(10), NVL(l_ent_pd_res_cnt_tbl(15),0));
2088:
2089: --INSERT Records for this particular
2090: --person id and enterprise period in
2091: --PJI_RM_AGGR_AVL3 table
2092:
2093: PREPARE_TO_INS_INTO_AVL3
2094: (
2095: p_exp_organization_id => l_old_exp_orgnztion_id,

Line 2198: --PJI_RM_AGGR_AVL3 table

2194: l_ent_qtr_res_cnt_tbl(15) := GREATEST (l_ent_qtr_res_cnt_tbl(10), NVL(l_ent_qtr_res_cnt_tbl(15),0));
2195:
2196: --INSERT Records for this particular
2197: --person id and ENTERPRISE QUARTER in
2198: --PJI_RM_AGGR_AVL3 table
2199:
2200: PREPARE_TO_INS_INTO_AVL3
2201: (
2202: p_exp_organization_id => l_old_exp_orgnztion_id,

Line 2305: --PJI_RM_AGGR_AVL3 table

2301: l_gl_pd_res_cnt_tbl(15) := GREATEST (l_gl_pd_res_cnt_tbl(10), NVL(l_gl_pd_res_cnt_tbl(15),0));
2302:
2303: --INSERT Records for this particular
2304: --person id and GL PERIOD in
2305: --PJI_RM_AGGR_AVL3 table
2306:
2307: PREPARE_TO_INS_INTO_AVL3
2308: (
2309: p_exp_organization_id => l_old_exp_orgnztion_id,

Line 2412: --PJI_RM_AGGR_AVL3 table

2408: l_gl_qtr_res_cnt_tbl(15) := GREATEST (l_gl_qtr_res_cnt_tbl(10), NVL(l_gl_qtr_res_cnt_tbl(15),0));
2409:
2410: --INSERT Records for this particular
2411: --person id and GL QUARTER in
2412: --PJI_RM_AGGR_AVL3 table
2413:
2414: PREPARE_TO_INS_INTO_AVL3
2415: (
2416: p_exp_organization_id => l_old_exp_orgnztion_id,

Line 2519: --PJI_RM_AGGR_AVL3 table

2515: l_roll_x_wk1_res_cnt_tbl(15) := GREATEST (l_roll_x_wk1_res_cnt_tbl(10), NVL(l_roll_x_wk1_res_cnt_tbl(15),0));
2516:
2517: --INSERT Records for this particular
2518: --person id and ROLLING WEEK 1 in
2519: --PJI_RM_AGGR_AVL3 table
2520:
2521: PREPARE_TO_INS_INTO_AVL3
2522: (
2523: p_exp_organization_id => l_old_exp_orgnztion_id,

Line 2627: --PJI_RM_AGGR_AVL3 table

2623: l_roll_x_wk2_res_cnt_tbl(15) := GREATEST (l_roll_x_wk2_res_cnt_tbl(10), NVL(l_roll_x_wk2_res_cnt_tbl(15),0));
2624:
2625: --INSERT Records for this particular
2626: --person id and ROLLING WEEK 2 in
2627: --PJI_RM_AGGR_AVL3 table
2628:
2629: PREPARE_TO_INS_INTO_AVL3
2630: (
2631: p_exp_organization_id => l_old_exp_orgnztion_id,

Line 2735: --PJI_RM_AGGR_AVL3 table

2731: l_roll_x_wk3_res_cnt_tbl(15) := GREATEST (l_roll_x_wk3_res_cnt_tbl(10), NVL(l_roll_x_wk3_res_cnt_tbl(15),0));
2732:
2733: --INSERT Records for this particular
2734: --person id and ROLLING WEEK 3 in
2735: --PJI_RM_AGGR_AVL3 table
2736:
2737: PREPARE_TO_INS_INTO_AVL3
2738: (
2739: p_exp_organization_id => l_old_exp_orgnztion_id,

Line 2843: --PJI_RM_AGGR_AVL3 table

2839: l_roll_x_wk4_res_cnt_tbl(15) := GREATEST (l_roll_x_wk4_res_cnt_tbl(10), NVL(l_roll_x_wk4_res_cnt_tbl(15),0));
2840:
2841: --INSERT Records for this particular
2842: --person id and ROLLING WEEK 4 in
2843: --PJI_RM_AGGR_AVL3 table
2844:
2845: PREPARE_TO_INS_INTO_AVL3
2846: (
2847: p_exp_organization_id => l_old_exp_orgnztion_id,

Line 2951: --PJI_RM_AGGR_AVL3 table

2947: l_roll_x_wk5_res_cnt_tbl(15) := GREATEST (l_roll_x_wk5_res_cnt_tbl(10), NVL(l_roll_x_wk5_res_cnt_tbl(15),0));
2948:
2949: --INSERT Records for this particular
2950: --person id and ROLLING WEEK 5 in
2951: --PJI_RM_AGGR_AVL3 table
2952:
2953: PREPARE_TO_INS_INTO_AVL3
2954: (
2955: p_exp_organization_id => l_old_exp_orgnztion_id,

Line 3059: --PJI_RM_AGGR_AVL3 table

3055: l_roll_x_wk6_res_cnt_tbl(15) := GREATEST (l_roll_x_wk6_res_cnt_tbl(10), NVL(l_roll_x_wk6_res_cnt_tbl(15),0));
3056:
3057: --INSERT Records for this particular
3058: --person id and ROLLING WEEK 6 in
3059: --PJI_RM_AGGR_AVL3 table
3060:
3061: PREPARE_TO_INS_INTO_AVL3
3062: (
3063: p_exp_organization_id => l_old_exp_orgnztion_id,

Line 3167: --PJI_RM_AGGR_AVL3 table

3163: l_roll_x_wk7_res_cnt_tbl(15) := GREATEST (l_roll_x_wk7_res_cnt_tbl(10), NVL(l_roll_x_wk7_res_cnt_tbl(15),0));
3164:
3165: --INSERT Records for this particular
3166: --person id and ROLLING WEEK 7 in
3167: --PJI_RM_AGGR_AVL3 table
3168:
3169: PREPARE_TO_INS_INTO_AVL3
3170: (
3171: p_exp_organization_id => l_old_exp_orgnztion_id,

Line 3275: --PJI_RM_AGGR_AVL3 table

3271: l_roll_x_wk8_res_cnt_tbl(15) := GREATEST (l_roll_x_wk8_res_cnt_tbl(10), NVL(l_roll_x_wk8_res_cnt_tbl(15),0));
3272:
3273: --INSERT Records for this particular
3274: --person id and ROLLING WEEK 8 in
3275: --PJI_RM_AGGR_AVL3 table
3276:
3277: PREPARE_TO_INS_INTO_AVL3
3278: (
3279: p_exp_organization_id => l_old_exp_orgnztion_id,

Line 3383: --PJI_RM_AGGR_AVL3 table

3379: l_roll_x_wk9_res_cnt_tbl(15) := GREATEST (l_roll_x_wk9_res_cnt_tbl(10), NVL(l_roll_x_wk9_res_cnt_tbl(15),0));
3380:
3381: --INSERT Records for this particular
3382: --person id and ROLLING WEEK 9 in
3383: --PJI_RM_AGGR_AVL3 table
3384:
3385: PREPARE_TO_INS_INTO_AVL3
3386: (
3387: p_exp_organization_id => l_old_exp_orgnztion_id,

Line 3491: --PJI_RM_AGGR_AVL3 table

3487: l_roll_x_wk10_res_cnt_tbl(15) := GREATEST (l_roll_x_wk10_res_cnt_tbl(10), NVL(l_roll_x_wk10_res_cnt_tbl(15),0));
3488:
3489: --INSERT Records for this particular
3490: --person id and ROLLING WEEK 10 in
3491: --PJI_RM_AGGR_AVL3 table
3492:
3493: PREPARE_TO_INS_INTO_AVL3
3494: (
3495: p_exp_organization_id => l_old_exp_orgnztion_id,

Line 3599: --PJI_RM_AGGR_AVL3 table

3595: l_roll_x_wk11_res_cnt_tbl(15) := GREATEST (l_roll_x_wk11_res_cnt_tbl(10), NVL(l_roll_x_wk11_res_cnt_tbl(15),0));
3596:
3597: --INSERT Records for this particular
3598: --person id and ROLLING WEEK 11 in
3599: --PJI_RM_AGGR_AVL3 table
3600:
3601: PREPARE_TO_INS_INTO_AVL3
3602: (
3603: p_exp_organization_id => l_old_exp_orgnztion_id,

Line 3707: --PJI_RM_AGGR_AVL3 table

3703: l_roll_x_wk12_res_cnt_tbl(15) := GREATEST (l_roll_x_wk12_res_cnt_tbl(10), NVL(l_roll_x_wk12_res_cnt_tbl(15),0));
3704:
3705: --INSERT Records for this particular
3706: --person id and ROLLING WEEK 12 in
3707: --PJI_RM_AGGR_AVL3 table
3708:
3709: PREPARE_TO_INS_INTO_AVL3
3710: (
3711: p_exp_organization_id => l_old_exp_orgnztion_id,

Line 3815: --PJI_RM_AGGR_AVL3 table

3811: l_roll_x_wk13_res_cnt_tbl(15) := GREATEST (l_roll_x_wk13_res_cnt_tbl(10), NVL(l_roll_x_wk13_res_cnt_tbl(15),0));
3812:
3813: --INSERT Records for this particular
3814: --person id and ROLLING WEEK 13 in
3815: --PJI_RM_AGGR_AVL3 table
3816:
3817: PREPARE_TO_INS_INTO_AVL3
3818: (
3819: p_exp_organization_id => l_old_exp_orgnztion_id,

Line 3986: inserting in PJI_RM_AGGR_AVL3 and PJI_RM_AGGR_AVL4 table are inserted.

3982: END LOOP;
3983: CLOSE Res_cur;
3984: /*
3985: Make sure that the current records in PL/SQL tables for
3986: inserting in PJI_RM_AGGR_AVL3 and PJI_RM_AGGR_AVL4 table are inserted.
3987: If the number of PL/SQL records did not reach 200
3988: it may not be inserted. So, call the Bulk insert API
3989: with blind insert flag = 'Y' and all variables and
3990: tables as empty. Also, no processing is done on any

Line 4169: PJI_RM_AGGR_AVL3

4165: BCKT_4_CM,
4166: BCKT_5_CM,
4167: TOTAL_RES_COUNT
4168: FROM
4169: PJI_RM_AGGR_AVL3
4170: ) rtmp1,
4171: (
4172: SELECT
4173: fiit.WEEK_ID as WEEK_ID,

Line 4458: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL3');

4454: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL1');
4455:
4456: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL2');
4457:
4458: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL3');
4459:
4460: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL4');
4461:
4462: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL5');