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_AVL2

Line 39: g_avl_res_cnt_1 PJI_RM_AGGR_AVL2.avl_res_count_bkt1%TYPE;

35: gw_total_res_cnt_in_tbl N_TYPE_TAB;
36:
37: --Defining Global variables for storing buckets
38:
39: g_avl_res_cnt_1 PJI_RM_AGGR_AVL2.avl_res_count_bkt1%TYPE;
40: g_avl_res_cnt_2 PJI_RM_AGGR_AVL2.avl_res_count_bkt2%TYPE;
41: g_avl_res_cnt_3 PJI_RM_AGGR_AVL2.avl_res_count_bkt3%TYPE;
42: g_avl_res_cnt_4 PJI_RM_AGGR_AVL2.avl_res_count_bkt4%TYPE;
43: g_avl_res_cnt_5 PJI_RM_AGGR_AVL2.avl_res_count_bkt5%TYPE;

Line 40: g_avl_res_cnt_2 PJI_RM_AGGR_AVL2.avl_res_count_bkt2%TYPE;

36:
37: --Defining Global variables for storing buckets
38:
39: g_avl_res_cnt_1 PJI_RM_AGGR_AVL2.avl_res_count_bkt1%TYPE;
40: g_avl_res_cnt_2 PJI_RM_AGGR_AVL2.avl_res_count_bkt2%TYPE;
41: g_avl_res_cnt_3 PJI_RM_AGGR_AVL2.avl_res_count_bkt3%TYPE;
42: g_avl_res_cnt_4 PJI_RM_AGGR_AVL2.avl_res_count_bkt4%TYPE;
43: g_avl_res_cnt_5 PJI_RM_AGGR_AVL2.avl_res_count_bkt5%TYPE;
44:

Line 41: g_avl_res_cnt_3 PJI_RM_AGGR_AVL2.avl_res_count_bkt3%TYPE;

37: --Defining Global variables for storing buckets
38:
39: g_avl_res_cnt_1 PJI_RM_AGGR_AVL2.avl_res_count_bkt1%TYPE;
40: g_avl_res_cnt_2 PJI_RM_AGGR_AVL2.avl_res_count_bkt2%TYPE;
41: g_avl_res_cnt_3 PJI_RM_AGGR_AVL2.avl_res_count_bkt3%TYPE;
42: g_avl_res_cnt_4 PJI_RM_AGGR_AVL2.avl_res_count_bkt4%TYPE;
43: g_avl_res_cnt_5 PJI_RM_AGGR_AVL2.avl_res_count_bkt5%TYPE;
44:
45: --Package level global Variables to store the resource

Line 42: g_avl_res_cnt_4 PJI_RM_AGGR_AVL2.avl_res_count_bkt4%TYPE;

38:
39: g_avl_res_cnt_1 PJI_RM_AGGR_AVL2.avl_res_count_bkt1%TYPE;
40: g_avl_res_cnt_2 PJI_RM_AGGR_AVL2.avl_res_count_bkt2%TYPE;
41: g_avl_res_cnt_3 PJI_RM_AGGR_AVL2.avl_res_count_bkt3%TYPE;
42: g_avl_res_cnt_4 PJI_RM_AGGR_AVL2.avl_res_count_bkt4%TYPE;
43: g_avl_res_cnt_5 PJI_RM_AGGR_AVL2.avl_res_count_bkt5%TYPE;
44:
45: --Package level global Variables to store the resource
46: --availability buckets values

Line 43: g_avl_res_cnt_5 PJI_RM_AGGR_AVL2.avl_res_count_bkt5%TYPE;

39: g_avl_res_cnt_1 PJI_RM_AGGR_AVL2.avl_res_count_bkt1%TYPE;
40: g_avl_res_cnt_2 PJI_RM_AGGR_AVL2.avl_res_count_bkt2%TYPE;
41: g_avl_res_cnt_3 PJI_RM_AGGR_AVL2.avl_res_count_bkt3%TYPE;
42: g_avl_res_cnt_4 PJI_RM_AGGR_AVL2.avl_res_count_bkt4%TYPE;
43: g_avl_res_cnt_5 PJI_RM_AGGR_AVL2.avl_res_count_bkt5%TYPE;
44:
45: --Package level global Variables to store the resource
46: --availability buckets values
47: g_bucket_1_min NUMBER(15);

Line 581: p_exp_organization_id IN PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE,

577: END BULK_INSERT_RS_AVL3;
578:
579: PROCEDURE PREPARE_TO_INS_INTO_AVL3
580: (
581: p_exp_organization_id IN PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE,
582: p_exp_org_id IN PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE,
583: p_person_id IN PJI_RM_AGGR_AVL2.person_id%TYPE,
584: p_time_id IN PJI_RM_AGGR_AVL2.time_id%TYPE,
585: p_curr_pd IN NUMBER,

Line 582: p_exp_org_id IN PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE,

578:
579: PROCEDURE PREPARE_TO_INS_INTO_AVL3
580: (
581: p_exp_organization_id IN PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE,
582: p_exp_org_id IN PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE,
583: p_person_id IN PJI_RM_AGGR_AVL2.person_id%TYPE,
584: p_time_id IN PJI_RM_AGGR_AVL2.time_id%TYPE,
585: p_curr_pd IN NUMBER,
586: p_as_of_date IN NUMBER,

Line 583: p_person_id IN PJI_RM_AGGR_AVL2.person_id%TYPE,

579: PROCEDURE PREPARE_TO_INS_INTO_AVL3
580: (
581: p_exp_organization_id IN PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE,
582: p_exp_org_id IN PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE,
583: p_person_id IN PJI_RM_AGGR_AVL2.person_id%TYPE,
584: p_time_id IN PJI_RM_AGGR_AVL2.time_id%TYPE,
585: p_curr_pd IN NUMBER,
586: p_as_of_date IN NUMBER,
587: p_pd_org_st_date IN NUMBER,

Line 584: p_time_id IN PJI_RM_AGGR_AVL2.time_id%TYPE,

580: (
581: p_exp_organization_id IN PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE,
582: p_exp_org_id IN PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE,
583: p_person_id IN PJI_RM_AGGR_AVL2.person_id%TYPE,
584: p_time_id IN PJI_RM_AGGR_AVL2.time_id%TYPE,
585: p_curr_pd IN NUMBER,
586: p_as_of_date IN NUMBER,
587: p_pd_org_st_date IN NUMBER,
588: p_period_type_id IN NUMBER,

Line 1004: p_exp_organization_id IN PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE,

1000: END BULK_INSERT_RS_AVL4;
1001:
1002: PROCEDURE PREPARE_TO_INS_INTO_AVL4
1003: (
1004: p_exp_organization_id IN PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE,
1005: p_exp_org_id IN PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE,
1006: p_person_id IN PJI_RM_AGGR_AVL2.person_id%TYPE,
1007: p_time_id IN PJI_RM_AGGR_AVL2.time_id%TYPE,
1008: p_curr_pd IN NUMBER,

Line 1005: p_exp_org_id IN PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE,

1001:
1002: PROCEDURE PREPARE_TO_INS_INTO_AVL4
1003: (
1004: p_exp_organization_id IN PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE,
1005: p_exp_org_id IN PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE,
1006: p_person_id IN PJI_RM_AGGR_AVL2.person_id%TYPE,
1007: p_time_id IN PJI_RM_AGGR_AVL2.time_id%TYPE,
1008: p_curr_pd IN NUMBER,
1009: p_as_of_date IN NUMBER,

Line 1006: p_person_id IN PJI_RM_AGGR_AVL2.person_id%TYPE,

1002: PROCEDURE PREPARE_TO_INS_INTO_AVL4
1003: (
1004: p_exp_organization_id IN PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE,
1005: p_exp_org_id IN PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE,
1006: p_person_id IN PJI_RM_AGGR_AVL2.person_id%TYPE,
1007: p_time_id IN PJI_RM_AGGR_AVL2.time_id%TYPE,
1008: p_curr_pd IN NUMBER,
1009: p_as_of_date IN NUMBER,
1010: p_pd_org_st_date IN NUMBER,

Line 1007: p_time_id IN PJI_RM_AGGR_AVL2.time_id%TYPE,

1003: (
1004: p_exp_organization_id IN PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE,
1005: p_exp_org_id IN PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE,
1006: p_person_id IN PJI_RM_AGGR_AVL2.person_id%TYPE,
1007: p_time_id IN PJI_RM_AGGR_AVL2.time_id%TYPE,
1008: p_curr_pd IN NUMBER,
1009: p_as_of_date IN NUMBER,
1010: p_pd_org_st_date IN NUMBER,
1011: p_period_type_id IN NUMBER,

Line 1192: l_worker_id PJI_RM_AGGR_AVL2.worker_id%TYPE;

1188: l_avl_res_cnt_4_tbl N_TYPE_TAB;
1189: l_avl_res_cnt_5_tbl N_TYPE_TAB;
1190:
1191: --Defining Local variables for local use
1192: l_worker_id PJI_RM_AGGR_AVL2.worker_id%TYPE;
1193: l_exp_organization_id PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE;
1194: l_exp_org_id PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE;
1195: l_person_id PJI_RM_AGGR_AVL2.person_id%TYPE;
1196: l_time_id PJI_RM_AGGR_AVL2.time_id%TYPE;

Line 1193: l_exp_organization_id PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE;

1189: l_avl_res_cnt_5_tbl N_TYPE_TAB;
1190:
1191: --Defining Local variables for local use
1192: l_worker_id PJI_RM_AGGR_AVL2.worker_id%TYPE;
1193: l_exp_organization_id PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE;
1194: l_exp_org_id PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE;
1195: l_person_id PJI_RM_AGGR_AVL2.person_id%TYPE;
1196: l_time_id PJI_RM_AGGR_AVL2.time_id%TYPE;
1197: l_week_id PJI_RM_AGGR_AVL2.week_id%TYPE;

Line 1194: l_exp_org_id PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE;

1190:
1191: --Defining Local variables for local use
1192: l_worker_id PJI_RM_AGGR_AVL2.worker_id%TYPE;
1193: l_exp_organization_id PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE;
1194: l_exp_org_id PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE;
1195: l_person_id PJI_RM_AGGR_AVL2.person_id%TYPE;
1196: l_time_id PJI_RM_AGGR_AVL2.time_id%TYPE;
1197: l_week_id PJI_RM_AGGR_AVL2.week_id%TYPE;
1198: l_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE;

Line 1195: l_person_id PJI_RM_AGGR_AVL2.person_id%TYPE;

1191: --Defining Local variables for local use
1192: l_worker_id PJI_RM_AGGR_AVL2.worker_id%TYPE;
1193: l_exp_organization_id PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE;
1194: l_exp_org_id PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE;
1195: l_person_id PJI_RM_AGGR_AVL2.person_id%TYPE;
1196: l_time_id PJI_RM_AGGR_AVL2.time_id%TYPE;
1197: l_week_id PJI_RM_AGGR_AVL2.week_id%TYPE;
1198: l_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE;
1199: l_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE;

Line 1196: l_time_id PJI_RM_AGGR_AVL2.time_id%TYPE;

1192: l_worker_id PJI_RM_AGGR_AVL2.worker_id%TYPE;
1193: l_exp_organization_id PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE;
1194: l_exp_org_id PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE;
1195: l_person_id PJI_RM_AGGR_AVL2.person_id%TYPE;
1196: l_time_id PJI_RM_AGGR_AVL2.time_id%TYPE;
1197: l_week_id PJI_RM_AGGR_AVL2.week_id%TYPE;
1198: l_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE;
1199: l_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE;
1200: l_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE;

Line 1197: l_week_id PJI_RM_AGGR_AVL2.week_id%TYPE;

1193: l_exp_organization_id PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE;
1194: l_exp_org_id PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE;
1195: l_person_id PJI_RM_AGGR_AVL2.person_id%TYPE;
1196: l_time_id PJI_RM_AGGR_AVL2.time_id%TYPE;
1197: l_week_id PJI_RM_AGGR_AVL2.week_id%TYPE;
1198: l_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE;
1199: l_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE;
1200: l_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE;
1201: l_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE;

Line 1198: l_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE;

1194: l_exp_org_id PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE;
1195: l_person_id PJI_RM_AGGR_AVL2.person_id%TYPE;
1196: l_time_id PJI_RM_AGGR_AVL2.time_id%TYPE;
1197: l_week_id PJI_RM_AGGR_AVL2.week_id%TYPE;
1198: l_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE;
1199: l_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE;
1200: l_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE;
1201: l_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE;
1202: l_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE;

Line 1199: l_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE;

1195: l_person_id PJI_RM_AGGR_AVL2.person_id%TYPE;
1196: l_time_id PJI_RM_AGGR_AVL2.time_id%TYPE;
1197: l_week_id PJI_RM_AGGR_AVL2.week_id%TYPE;
1198: l_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE;
1199: l_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE;
1200: l_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE;
1201: l_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE;
1202: l_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE;
1203: l_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE;

Line 1200: l_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE;

1196: l_time_id PJI_RM_AGGR_AVL2.time_id%TYPE;
1197: l_week_id PJI_RM_AGGR_AVL2.week_id%TYPE;
1198: l_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE;
1199: l_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE;
1200: l_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE;
1201: l_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE;
1202: l_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE;
1203: l_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE;
1204: l_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE;

Line 1201: l_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE;

1197: l_week_id PJI_RM_AGGR_AVL2.week_id%TYPE;
1198: l_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE;
1199: l_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE;
1200: l_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE;
1201: l_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE;
1202: l_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE;
1203: l_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE;
1204: l_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE;
1205: l_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE;

Line 1202: l_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE;

1198: l_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE;
1199: l_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE;
1200: l_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE;
1201: l_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE;
1202: l_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE;
1203: l_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE;
1204: l_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE;
1205: l_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE;
1206: l_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE;

Line 1203: l_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE;

1199: l_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE;
1200: l_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE;
1201: l_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE;
1202: l_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE;
1203: l_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE;
1204: l_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE;
1205: l_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE;
1206: l_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE;
1207: l_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE;

Line 1204: l_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE;

1200: l_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE;
1201: l_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE;
1202: l_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE;
1203: l_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE;
1204: l_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE;
1205: l_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE;
1206: l_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE;
1207: l_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE;
1208: l_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE;

Line 1205: l_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE;

1201: l_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE;
1202: l_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE;
1203: l_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE;
1204: l_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE;
1205: l_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE;
1206: l_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE;
1207: l_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE;
1208: l_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE;
1209: l_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE;

Line 1206: l_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE;

1202: l_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE;
1203: l_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE;
1204: l_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE;
1205: l_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE;
1206: l_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE;
1207: l_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE;
1208: l_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE;
1209: l_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE;
1210: l_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE;

Line 1207: l_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE;

1203: l_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE;
1204: l_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE;
1205: l_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE;
1206: l_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE;
1207: l_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE;
1208: l_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE;
1209: l_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE;
1210: l_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE;
1211: l_roll_x_week10 PJI_RM_AGGR_AVL2.roll_x_week_10%TYPE;

Line 1208: l_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE;

1204: l_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE;
1205: l_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE;
1206: l_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE;
1207: l_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE;
1208: l_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE;
1209: l_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE;
1210: l_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE;
1211: l_roll_x_week10 PJI_RM_AGGR_AVL2.roll_x_week_10%TYPE;
1212: l_roll_x_week11 PJI_RM_AGGR_AVL2.roll_x_week_11%TYPE;

Line 1209: l_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE;

1205: l_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE;
1206: l_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE;
1207: l_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE;
1208: l_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE;
1209: l_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE;
1210: l_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE;
1211: l_roll_x_week10 PJI_RM_AGGR_AVL2.roll_x_week_10%TYPE;
1212: l_roll_x_week11 PJI_RM_AGGR_AVL2.roll_x_week_11%TYPE;
1213: l_roll_x_week12 PJI_RM_AGGR_AVL2.roll_x_week_12%TYPE;

Line 1210: l_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE;

1206: l_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE;
1207: l_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE;
1208: l_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE;
1209: l_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE;
1210: l_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE;
1211: l_roll_x_week10 PJI_RM_AGGR_AVL2.roll_x_week_10%TYPE;
1212: l_roll_x_week11 PJI_RM_AGGR_AVL2.roll_x_week_11%TYPE;
1213: l_roll_x_week12 PJI_RM_AGGR_AVL2.roll_x_week_12%TYPE;
1214: l_roll_x_week13 PJI_RM_AGGR_AVL2.roll_x_week_13%TYPE;

Line 1211: l_roll_x_week10 PJI_RM_AGGR_AVL2.roll_x_week_10%TYPE;

1207: l_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE;
1208: l_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE;
1209: l_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE;
1210: l_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE;
1211: l_roll_x_week10 PJI_RM_AGGR_AVL2.roll_x_week_10%TYPE;
1212: l_roll_x_week11 PJI_RM_AGGR_AVL2.roll_x_week_11%TYPE;
1213: l_roll_x_week12 PJI_RM_AGGR_AVL2.roll_x_week_12%TYPE;
1214: l_roll_x_week13 PJI_RM_AGGR_AVL2.roll_x_week_13%TYPE;
1215:

Line 1212: l_roll_x_week11 PJI_RM_AGGR_AVL2.roll_x_week_11%TYPE;

1208: l_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE;
1209: l_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE;
1210: l_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE;
1211: l_roll_x_week10 PJI_RM_AGGR_AVL2.roll_x_week_10%TYPE;
1212: l_roll_x_week11 PJI_RM_AGGR_AVL2.roll_x_week_11%TYPE;
1213: l_roll_x_week12 PJI_RM_AGGR_AVL2.roll_x_week_12%TYPE;
1214: l_roll_x_week13 PJI_RM_AGGR_AVL2.roll_x_week_13%TYPE;
1215:
1216: --Defining PL/SQL Local variables for local use

Line 1213: l_roll_x_week12 PJI_RM_AGGR_AVL2.roll_x_week_12%TYPE;

1209: l_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE;
1210: l_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE;
1211: l_roll_x_week10 PJI_RM_AGGR_AVL2.roll_x_week_10%TYPE;
1212: l_roll_x_week11 PJI_RM_AGGR_AVL2.roll_x_week_11%TYPE;
1213: l_roll_x_week12 PJI_RM_AGGR_AVL2.roll_x_week_12%TYPE;
1214: l_roll_x_week13 PJI_RM_AGGR_AVL2.roll_x_week_13%TYPE;
1215:
1216: --Defining PL/SQL Local variables for local use
1217: --Need to store old value of the previous row

Line 1214: l_roll_x_week13 PJI_RM_AGGR_AVL2.roll_x_week_13%TYPE;

1210: l_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE;
1211: l_roll_x_week10 PJI_RM_AGGR_AVL2.roll_x_week_10%TYPE;
1212: l_roll_x_week11 PJI_RM_AGGR_AVL2.roll_x_week_11%TYPE;
1213: l_roll_x_week12 PJI_RM_AGGR_AVL2.roll_x_week_12%TYPE;
1214: l_roll_x_week13 PJI_RM_AGGR_AVL2.roll_x_week_13%TYPE;
1215:
1216: --Defining PL/SQL Local variables for local use
1217: --Need to store old value of the previous row
1218: --when processing records row by row from

Line 1219: --PJI_RM_AGGR_AVL2 table

1215:
1216: --Defining PL/SQL Local variables for local use
1217: --Need to store old value of the previous row
1218: --when processing records row by row from
1219: --PJI_RM_AGGR_AVL2 table
1220: l_old_worker_id PJI_RM_AGGR_AVL2.worker_id%TYPE := -1;
1221: l_old_exp_orgnztion_id PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE := -1;
1222: l_old_exp_org_id PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE := -1;
1223: l_old_person_id PJI_RM_AGGR_AVL2.person_id%TYPE := -1;

Line 1220: l_old_worker_id PJI_RM_AGGR_AVL2.worker_id%TYPE := -1;

1216: --Defining PL/SQL Local variables for local use
1217: --Need to store old value of the previous row
1218: --when processing records row by row from
1219: --PJI_RM_AGGR_AVL2 table
1220: l_old_worker_id PJI_RM_AGGR_AVL2.worker_id%TYPE := -1;
1221: l_old_exp_orgnztion_id PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE := -1;
1222: l_old_exp_org_id PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE := -1;
1223: l_old_person_id PJI_RM_AGGR_AVL2.person_id%TYPE := -1;
1224: l_old_week_id PJI_RM_AGGR_AVL2.week_id%TYPE := -1;

Line 1221: l_old_exp_orgnztion_id PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE := -1;

1217: --Need to store old value of the previous row
1218: --when processing records row by row from
1219: --PJI_RM_AGGR_AVL2 table
1220: l_old_worker_id PJI_RM_AGGR_AVL2.worker_id%TYPE := -1;
1221: l_old_exp_orgnztion_id PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE := -1;
1222: l_old_exp_org_id PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE := -1;
1223: l_old_person_id PJI_RM_AGGR_AVL2.person_id%TYPE := -1;
1224: l_old_week_id PJI_RM_AGGR_AVL2.week_id%TYPE := -1;
1225: l_old_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE := -1;

Line 1222: l_old_exp_org_id PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE := -1;

1218: --when processing records row by row from
1219: --PJI_RM_AGGR_AVL2 table
1220: l_old_worker_id PJI_RM_AGGR_AVL2.worker_id%TYPE := -1;
1221: l_old_exp_orgnztion_id PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE := -1;
1222: l_old_exp_org_id PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE := -1;
1223: l_old_person_id PJI_RM_AGGR_AVL2.person_id%TYPE := -1;
1224: l_old_week_id PJI_RM_AGGR_AVL2.week_id%TYPE := -1;
1225: l_old_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE := -1;
1226: l_old_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE := -1;

Line 1223: l_old_person_id PJI_RM_AGGR_AVL2.person_id%TYPE := -1;

1219: --PJI_RM_AGGR_AVL2 table
1220: l_old_worker_id PJI_RM_AGGR_AVL2.worker_id%TYPE := -1;
1221: l_old_exp_orgnztion_id PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE := -1;
1222: l_old_exp_org_id PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE := -1;
1223: l_old_person_id PJI_RM_AGGR_AVL2.person_id%TYPE := -1;
1224: l_old_week_id PJI_RM_AGGR_AVL2.week_id%TYPE := -1;
1225: l_old_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE := -1;
1226: l_old_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE := -1;
1227: l_old_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE := -1;

Line 1224: l_old_week_id PJI_RM_AGGR_AVL2.week_id%TYPE := -1;

1220: l_old_worker_id PJI_RM_AGGR_AVL2.worker_id%TYPE := -1;
1221: l_old_exp_orgnztion_id PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE := -1;
1222: l_old_exp_org_id PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE := -1;
1223: l_old_person_id PJI_RM_AGGR_AVL2.person_id%TYPE := -1;
1224: l_old_week_id PJI_RM_AGGR_AVL2.week_id%TYPE := -1;
1225: l_old_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE := -1;
1226: l_old_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE := -1;
1227: l_old_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE := -1;
1228: l_old_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE := -1;

Line 1225: l_old_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE := -1;

1221: l_old_exp_orgnztion_id PJI_RM_AGGR_AVL2.expenditure_organization_id%TYPE := -1;
1222: l_old_exp_org_id PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE := -1;
1223: l_old_person_id PJI_RM_AGGR_AVL2.person_id%TYPE := -1;
1224: l_old_week_id PJI_RM_AGGR_AVL2.week_id%TYPE := -1;
1225: l_old_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE := -1;
1226: l_old_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE := -1;
1227: l_old_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE := -1;
1228: l_old_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE := -1;
1229: l_old_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE := -1;

Line 1226: l_old_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE := -1;

1222: l_old_exp_org_id PJI_RM_AGGR_AVL2.expenditure_org_id%TYPE := -1;
1223: l_old_person_id PJI_RM_AGGR_AVL2.person_id%TYPE := -1;
1224: l_old_week_id PJI_RM_AGGR_AVL2.week_id%TYPE := -1;
1225: l_old_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE := -1;
1226: l_old_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE := -1;
1227: l_old_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE := -1;
1228: l_old_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE := -1;
1229: l_old_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE := -1;
1230: l_old_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE := -1;

Line 1227: l_old_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE := -1;

1223: l_old_person_id PJI_RM_AGGR_AVL2.person_id%TYPE := -1;
1224: l_old_week_id PJI_RM_AGGR_AVL2.week_id%TYPE := -1;
1225: l_old_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE := -1;
1226: l_old_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE := -1;
1227: l_old_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE := -1;
1228: l_old_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE := -1;
1229: l_old_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE := -1;
1230: l_old_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE := -1;
1231: l_old_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE := -1;

Line 1228: l_old_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE := -1;

1224: l_old_week_id PJI_RM_AGGR_AVL2.week_id%TYPE := -1;
1225: l_old_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE := -1;
1226: l_old_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE := -1;
1227: l_old_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE := -1;
1228: l_old_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE := -1;
1229: l_old_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE := -1;
1230: l_old_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE := -1;
1231: l_old_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE := -1;
1232: l_old_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE := -1;

Line 1229: l_old_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE := -1;

1225: l_old_ent_period_id PJI_RM_AGGR_AVL2.ent_period%TYPE := -1;
1226: l_old_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE := -1;
1227: l_old_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE := -1;
1228: l_old_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE := -1;
1229: l_old_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE := -1;
1230: l_old_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE := -1;
1231: l_old_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE := -1;
1232: l_old_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE := -1;
1233: l_old_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE := -1;

Line 1230: l_old_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE := -1;

1226: l_old_ent_qtr_id PJI_RM_AGGR_AVL2.ent_qtr%TYPE := -1;
1227: l_old_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE := -1;
1228: l_old_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE := -1;
1229: l_old_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE := -1;
1230: l_old_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE := -1;
1231: l_old_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE := -1;
1232: l_old_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE := -1;
1233: l_old_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE := -1;
1234: l_old_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE := -1;

Line 1231: l_old_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE := -1;

1227: l_old_gl_period_id PJI_RM_AGGR_AVL2.gl_period%TYPE := -1;
1228: l_old_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE := -1;
1229: l_old_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE := -1;
1230: l_old_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE := -1;
1231: l_old_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE := -1;
1232: l_old_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE := -1;
1233: l_old_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE := -1;
1234: l_old_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE := -1;
1235: l_old_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE := -1;

Line 1232: l_old_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE := -1;

1228: l_old_gl_qtr_id PJI_RM_AGGR_AVL2.gl_qtr%TYPE := -1;
1229: l_old_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE := -1;
1230: l_old_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE := -1;
1231: l_old_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE := -1;
1232: l_old_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE := -1;
1233: l_old_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE := -1;
1234: l_old_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE := -1;
1235: l_old_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE := -1;
1236: l_old_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE := -1;

Line 1233: l_old_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE := -1;

1229: l_old_roll_x_week1 PJI_RM_AGGR_AVL2.roll_x_week_1%TYPE := -1;
1230: l_old_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE := -1;
1231: l_old_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE := -1;
1232: l_old_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE := -1;
1233: l_old_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE := -1;
1234: l_old_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE := -1;
1235: l_old_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE := -1;
1236: l_old_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE := -1;
1237: l_old_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE := -1;

Line 1234: l_old_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE := -1;

1230: l_old_roll_x_week2 PJI_RM_AGGR_AVL2.roll_x_week_2%TYPE := -1;
1231: l_old_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE := -1;
1232: l_old_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE := -1;
1233: l_old_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE := -1;
1234: l_old_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE := -1;
1235: l_old_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE := -1;
1236: l_old_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE := -1;
1237: l_old_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE := -1;
1238: l_old_roll_x_week10 PJI_RM_AGGR_AVL2.roll_x_week_10%TYPE := -1;

Line 1235: l_old_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE := -1;

1231: l_old_roll_x_week3 PJI_RM_AGGR_AVL2.roll_x_week_3%TYPE := -1;
1232: l_old_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE := -1;
1233: l_old_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE := -1;
1234: l_old_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE := -1;
1235: l_old_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE := -1;
1236: l_old_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE := -1;
1237: l_old_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE := -1;
1238: l_old_roll_x_week10 PJI_RM_AGGR_AVL2.roll_x_week_10%TYPE := -1;
1239: l_old_roll_x_week11 PJI_RM_AGGR_AVL2.roll_x_week_11%TYPE := -1;

Line 1236: l_old_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE := -1;

1232: l_old_roll_x_week4 PJI_RM_AGGR_AVL2.roll_x_week_4%TYPE := -1;
1233: l_old_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE := -1;
1234: l_old_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE := -1;
1235: l_old_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE := -1;
1236: l_old_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE := -1;
1237: l_old_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE := -1;
1238: l_old_roll_x_week10 PJI_RM_AGGR_AVL2.roll_x_week_10%TYPE := -1;
1239: l_old_roll_x_week11 PJI_RM_AGGR_AVL2.roll_x_week_11%TYPE := -1;
1240: l_old_roll_x_week12 PJI_RM_AGGR_AVL2.roll_x_week_12%TYPE := -1;

Line 1237: l_old_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE := -1;

1233: l_old_roll_x_week5 PJI_RM_AGGR_AVL2.roll_x_week_5%TYPE := -1;
1234: l_old_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE := -1;
1235: l_old_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE := -1;
1236: l_old_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE := -1;
1237: l_old_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE := -1;
1238: l_old_roll_x_week10 PJI_RM_AGGR_AVL2.roll_x_week_10%TYPE := -1;
1239: l_old_roll_x_week11 PJI_RM_AGGR_AVL2.roll_x_week_11%TYPE := -1;
1240: l_old_roll_x_week12 PJI_RM_AGGR_AVL2.roll_x_week_12%TYPE := -1;
1241: l_old_roll_x_week13 PJI_RM_AGGR_AVL2.roll_x_week_13%TYPE := -1;

Line 1238: l_old_roll_x_week10 PJI_RM_AGGR_AVL2.roll_x_week_10%TYPE := -1;

1234: l_old_roll_x_week6 PJI_RM_AGGR_AVL2.roll_x_week_6%TYPE := -1;
1235: l_old_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE := -1;
1236: l_old_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE := -1;
1237: l_old_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE := -1;
1238: l_old_roll_x_week10 PJI_RM_AGGR_AVL2.roll_x_week_10%TYPE := -1;
1239: l_old_roll_x_week11 PJI_RM_AGGR_AVL2.roll_x_week_11%TYPE := -1;
1240: l_old_roll_x_week12 PJI_RM_AGGR_AVL2.roll_x_week_12%TYPE := -1;
1241: l_old_roll_x_week13 PJI_RM_AGGR_AVL2.roll_x_week_13%TYPE := -1;
1242:

Line 1239: l_old_roll_x_week11 PJI_RM_AGGR_AVL2.roll_x_week_11%TYPE := -1;

1235: l_old_roll_x_week7 PJI_RM_AGGR_AVL2.roll_x_week_7%TYPE := -1;
1236: l_old_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE := -1;
1237: l_old_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE := -1;
1238: l_old_roll_x_week10 PJI_RM_AGGR_AVL2.roll_x_week_10%TYPE := -1;
1239: l_old_roll_x_week11 PJI_RM_AGGR_AVL2.roll_x_week_11%TYPE := -1;
1240: l_old_roll_x_week12 PJI_RM_AGGR_AVL2.roll_x_week_12%TYPE := -1;
1241: l_old_roll_x_week13 PJI_RM_AGGR_AVL2.roll_x_week_13%TYPE := -1;
1242:
1243: --Defining local variables for storing resource counts for ALL periods

Line 1240: l_old_roll_x_week12 PJI_RM_AGGR_AVL2.roll_x_week_12%TYPE := -1;

1236: l_old_roll_x_week8 PJI_RM_AGGR_AVL2.roll_x_week_8%TYPE := -1;
1237: l_old_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE := -1;
1238: l_old_roll_x_week10 PJI_RM_AGGR_AVL2.roll_x_week_10%TYPE := -1;
1239: l_old_roll_x_week11 PJI_RM_AGGR_AVL2.roll_x_week_11%TYPE := -1;
1240: l_old_roll_x_week12 PJI_RM_AGGR_AVL2.roll_x_week_12%TYPE := -1;
1241: l_old_roll_x_week13 PJI_RM_AGGR_AVL2.roll_x_week_13%TYPE := -1;
1242:
1243: --Defining local variables for storing resource counts for ALL periods
1244: /* Important Point */

Line 1241: l_old_roll_x_week13 PJI_RM_AGGR_AVL2.roll_x_week_13%TYPE := -1;

1237: l_old_roll_x_week9 PJI_RM_AGGR_AVL2.roll_x_week_9%TYPE := -1;
1238: l_old_roll_x_week10 PJI_RM_AGGR_AVL2.roll_x_week_10%TYPE := -1;
1239: l_old_roll_x_week11 PJI_RM_AGGR_AVL2.roll_x_week_11%TYPE := -1;
1240: l_old_roll_x_week12 PJI_RM_AGGR_AVL2.roll_x_week_12%TYPE := -1;
1241: l_old_roll_x_week13 PJI_RM_AGGR_AVL2.roll_x_week_13%TYPE := -1;
1242:
1243: --Defining local variables for storing resource counts for ALL periods
1244: /* Important Point */
1245: /* We are maintaing PL/SQL tables for storing

Line 1399: PJI_RM_AGGR_AVL2 avl2

1395: AVL_RES_COUNT_BKT3,
1396: AVL_RES_COUNT_BKT4,
1397: AVL_RES_COUNT_BKT5
1398: FROM
1399: PJI_RM_AGGR_AVL2 avl2
1400: WHERE avl2.person_id = p_person_id
1401: UNION ALL
1402: SELECT
1403: p_worker_id as WORKER_ID,

Line 1439: delete from PJI_RM_AGGR_AVL2 where worker_id = p_worker_id;

1435:
1436: BEGIN
1437:
1438: delete from PJI_RM_AGGR_AVL1 where worker_id = p_worker_id;
1439: delete from PJI_RM_AGGR_AVL2 where worker_id = p_worker_id;
1440:
1441: x_return_status := FND_API.G_RET_STS_SUCCESS;
1442: savepoint before_calc_starts;
1443: /*PHASE 1*/

Line 1627: INSERT INTO PJI_RM_AGGR_AVL2

1623: may not affect a period in GL. We store that information
1624: in a matrix table that has a completely denormalized schema.
1625: */
1626: --Populate TMP2 table
1627: INSERT INTO PJI_RM_AGGR_AVL2
1628: (
1629: WORKER_ID,
1630: EXPENDITURE_ORGANIZATION_ID,
1631: EXPENDITURE_ORG_ID,

Line 1917: entered in PJI_RM_AGGR_AVL2 table and based on the affect

1913: /*
1914: The basic idea for phase 3 is to determine the availability
1915: of resources for the user defined buckets for each period
1916: type. So, we do a row by row processing for all the records
1917: entered in PJI_RM_AGGR_AVL2 table and based on the affect
1918: it has on each period (enterprise quarter, enterprise period,
1919: GL period, GL quarter, Rolling Weeks), we process for each
1920: period type separately.
1921: Different processing is done for Cumulative buckets and

Line 4456: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL2');

4452: END IF;
4453:
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');