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.PSP_ENC_CREATE_LINES dependencies on PSP_MATRIX_DRIVER

Line 3975: FROM psp_matrix_driver pmd

3971: CURSOR ls_matrix_cur IS
3972: SELECT GREATEST(l_min_start_date, period_start_date) period_start_date,
3973: LEAST(l_max_end_date, period_end_date) period_end_date,
3974: SUM(period_schedule_percent) schedule_percent
3975: FROM psp_matrix_driver pmd
3976: WHERE run_id = l_run_id
3977: AND period_start_date <= l_max_end_date
3978: AND period_end_date >= l_min_start_date
3979: GROUP BY GREATEST(l_min_start_date, period_start_date),

Line 3987: FROM psp_matrix_driver pmd,

3983: CURSOR eg_matrix_cur IS
3984: SELECT GREATEST(l_min_start_date, peg.start_date_active, period_start_date) period_start_date,
3985: LEAST(l_max_end_date, peg.end_date_active, period_end_date) period_end_date,
3986: SUM(period_schedule_percent) schedule_percent
3987: FROM psp_matrix_driver pmd,
3988: psp_schedule_lines psl,
3989: psp_schedule_hierarchy psh,
3990: psp_element_groups peg
3991: WHERE run_id = l_run_id

Line 4049: psp_matrix_driver_pkg.set_runid;

4045:
4046: recno INTEGER;
4047: -- End of bug fix 3970852
4048: BEGIN
4049: psp_matrix_driver_pkg.set_runid;
4050: l_run_id := psp_matrix_driver_pkg.get_run_id;
4051:
4052: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
4053: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||

Line 4050: l_run_id := psp_matrix_driver_pkg.get_run_id;

4046: recno INTEGER;
4047: -- End of bug fix 3970852
4048: BEGIN
4049: psp_matrix_driver_pkg.set_runid;
4050: l_run_id := psp_matrix_driver_pkg.get_run_id;
4051:
4052: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
4053: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
4054: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||

Line 4366: psp_matrix_driver_pkg.clear_table('REFRESH');

4362: FETCH ls_hier_cur INTO l_schedule_hierarchy_id;
4363: CLOSE ls_hier_cur;
4364:
4365: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
4366: psp_matrix_driver_pkg.clear_table('REFRESH');
4367: psp_matrix_driver_pkg.purge_table;
4368: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
4369:
4370: DELETE psp_matrix_driver

Line 4367: psp_matrix_driver_pkg.purge_table;

4363: CLOSE ls_hier_cur;
4364:
4365: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
4366: psp_matrix_driver_pkg.clear_table('REFRESH');
4367: psp_matrix_driver_pkg.purge_table;
4368: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
4369:
4370: DELETE psp_matrix_driver
4371: WHERE run_id = l_run_id

Line 4368: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);

4364:
4365: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
4366: psp_matrix_driver_pkg.clear_table('REFRESH');
4367: psp_matrix_driver_pkg.purge_table;
4368: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
4369:
4370: DELETE psp_matrix_driver
4371: WHERE run_id = l_run_id
4372: AND (period_start_date > l_max_end_date

Line 4370: DELETE psp_matrix_driver

4366: psp_matrix_driver_pkg.clear_table('REFRESH');
4367: psp_matrix_driver_pkg.purge_table;
4368: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
4369:
4370: DELETE psp_matrix_driver
4371: WHERE run_id = l_run_id
4372: AND (period_start_date > l_max_end_date
4373: OR period_end_date < l_min_start_date
4374: OR period_schedule_percent = 0);

Line 4376: UPDATE psp_matrix_driver pmd

4372: AND (period_start_date > l_max_end_date
4373: OR period_end_date < l_min_start_date
4374: OR period_schedule_percent = 0);
4375:
4376: UPDATE psp_matrix_driver pmd
4377: SET period_end_date = period_end_date - 1
4378: WHERE run_id = l_run_id
4379: AND period_start_date < period_end_date
4380: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)

Line 4389: UPDATE psp_matrix_driver pmd

4385: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
4386: AND psl1.schedule_begin_date = pmd.period_end_date
4387: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4388:
4389: UPDATE psp_matrix_driver pmd
4390: SET period_end_date = period_end_date - 1
4391: WHERE run_id = l_run_id
4392: AND period_start_date < period_end_date
4393: AND NOT (NOT EXISTS (SELECT 1

Line 4406: UPDATE psp_matrix_driver pmd

4402: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4403: FROM psp_schedule_lines psl1
4404: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4405:
4406: UPDATE psp_matrix_driver pmd
4407: SET period_start_date = period_start_date + 1
4408: WHERE run_id = l_run_id
4409: AND period_start_date < period_end_date
4410: AND NOT EXISTS (SELECT 1

Line 4418: UPDATE psp_matrix_driver pmd

4414: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4415: FROM psp_schedule_lines psl1
4416: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4417:
4418: UPDATE psp_matrix_driver pmd
4419: SET period_start_date = period_start_date + 1
4420: WHERE run_id = l_run_id
4421: AND period_start_date < period_end_date
4422: AND EXISTS (SELECT 1

Line 4465: INSERT INTO psp_matrix_driver

4461: END IF;
4462: END LOOP;
4463:
4464: FORALL rowno IN 1..schedule_chunk.schedule_begin_date.COUNT
4465: INSERT INTO psp_matrix_driver
4466: (RUN_ID, SCHEDULE_LINE_ID,
4467: PERIOD_START_DATE,
4468: PERIOD_END_DATE,
4469: PERIOD_SCHEDULE_PERCENT)

Line 4758: psp_matrix_driver_pkg.clear_table('REFRESH');

4754: RPAD(r_enc_period.r_reason_code(recno), 50, ' '));
4755: END LOOP;
4756: hr_utility.trace('Element Group Processing ...');
4757:
4758: psp_matrix_driver_pkg.clear_table('REFRESH');
4759: psp_matrix_driver_pkg.purge_table;
4760: l_period_count := r_enc_period.r_time_period_id.COUNT;
4761: OPEN eg_hier_cur;
4762: LOOP

Line 4759: psp_matrix_driver_pkg.purge_table;

4755: END LOOP;
4756: hr_utility.trace('Element Group Processing ...');
4757:
4758: psp_matrix_driver_pkg.clear_table('REFRESH');
4759: psp_matrix_driver_pkg.purge_table;
4760: l_period_count := r_enc_period.r_time_period_id.COUNT;
4761: OPEN eg_hier_cur;
4762: LOOP
4763: FETCH eg_hier_cur INTO l_schedule_hierarchy_id;

Line 4767: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);

4763: FETCH eg_hier_cur INTO l_schedule_hierarchy_id;
4764: EXIT WHEN eg_hier_cur%NOTFOUND;
4765:
4766: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
4767: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
4768:
4769: DELETE psp_matrix_driver
4770: WHERE run_id = l_run_id
4771: AND (period_start_date > l_max_end_date

Line 4769: DELETE psp_matrix_driver

4765:
4766: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
4767: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
4768:
4769: DELETE psp_matrix_driver
4770: WHERE run_id = l_run_id
4771: AND (period_start_date > l_max_end_date
4772: OR period_end_date < l_min_start_date
4773: OR period_schedule_percent = 0);

Line 4775: UPDATE psp_matrix_driver pmd

4771: AND (period_start_date > l_max_end_date
4772: OR period_end_date < l_min_start_date
4773: OR period_schedule_percent = 0);
4774:
4775: UPDATE psp_matrix_driver pmd
4776: SET period_end_date = period_end_date - 1
4777: WHERE run_id = l_run_id
4778: AND period_start_date < period_end_date
4779: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)

Line 4788: UPDATE psp_matrix_driver pmd

4784: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
4785: AND psl1.schedule_begin_date = pmd.period_end_date
4786: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4787:
4788: UPDATE psp_matrix_driver pmd
4789: SET period_end_date = period_end_date - 1
4790: WHERE run_id = l_run_id
4791: AND period_start_date < period_end_date
4792: AND NOT (NOT EXISTS (SELECT 1

Line 4805: UPDATE psp_matrix_driver pmd

4801: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4802: FROM psp_schedule_lines psl1
4803: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4804:
4805: UPDATE psp_matrix_driver pmd
4806: SET period_start_date = period_start_date + 1
4807: WHERE run_id = l_run_id
4808: AND period_start_date < period_end_date
4809: AND NOT EXISTS (SELECT 1

Line 4817: UPDATE psp_matrix_driver pmd

4813: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4814: FROM psp_schedule_lines psl1
4815: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4816:
4817: UPDATE psp_matrix_driver pmd
4818: SET period_start_date = period_start_date + 1
4819: WHERE run_id = l_run_id
4820: AND period_start_date < period_end_date
4821: AND EXISTS (SELECT 1

Line 4864: INSERT INTO psp_matrix_driver

4860: END IF;
4861: END LOOP;
4862:
4863: FORALL rowno IN 1..schedule_chunk.schedule_begin_date.COUNT
4864: INSERT INTO psp_matrix_driver
4865: (RUN_ID, SCHEDULE_LINE_ID,
4866: PERIOD_START_DATE,
4867: PERIOD_END_DATE,
4868: PERIOD_SCHEDULE_PERCENT)

Line 5156: psp_matrix_driver_pkg.clear_table('REFRESH');

5152: RPAD(r_enc_period_tmp1.r_reason_code(recno), 50, ' '));
5153: END LOOP;
5154: hr_utility.trace('Assignment Processing ...');
5155:
5156: psp_matrix_driver_pkg.clear_table('REFRESH');
5157: psp_matrix_driver_pkg.purge_table;
5158: l_period_count := r_enc_period.r_time_period_id.COUNT;
5159: OPEN ls_hier_cur('A');
5160: FETCH ls_hier_cur INTO l_schedule_hierarchy_id;

Line 5157: psp_matrix_driver_pkg.purge_table;

5153: END LOOP;
5154: hr_utility.trace('Assignment Processing ...');
5155:
5156: psp_matrix_driver_pkg.clear_table('REFRESH');
5157: psp_matrix_driver_pkg.purge_table;
5158: l_period_count := r_enc_period.r_time_period_id.COUNT;
5159: OPEN ls_hier_cur('A');
5160: FETCH ls_hier_cur INTO l_schedule_hierarchy_id;
5161: CLOSE ls_hier_cur;

Line 5164: psp_matrix_driver_pkg.clear_table('REFRESH');

5160: FETCH ls_hier_cur INTO l_schedule_hierarchy_id;
5161: CLOSE ls_hier_cur;
5162:
5163: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
5164: psp_matrix_driver_pkg.clear_table('REFRESH');
5165: psp_matrix_driver_pkg.purge_table;
5166: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
5167:
5168: DELETE psp_matrix_driver

Line 5165: psp_matrix_driver_pkg.purge_table;

5161: CLOSE ls_hier_cur;
5162:
5163: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
5164: psp_matrix_driver_pkg.clear_table('REFRESH');
5165: psp_matrix_driver_pkg.purge_table;
5166: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
5167:
5168: DELETE psp_matrix_driver
5169: WHERE run_id = l_run_id

Line 5166: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);

5162:
5163: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
5164: psp_matrix_driver_pkg.clear_table('REFRESH');
5165: psp_matrix_driver_pkg.purge_table;
5166: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
5167:
5168: DELETE psp_matrix_driver
5169: WHERE run_id = l_run_id
5170: AND (period_start_date > l_max_end_date

Line 5168: DELETE psp_matrix_driver

5164: psp_matrix_driver_pkg.clear_table('REFRESH');
5165: psp_matrix_driver_pkg.purge_table;
5166: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
5167:
5168: DELETE psp_matrix_driver
5169: WHERE run_id = l_run_id
5170: AND (period_start_date > l_max_end_date
5171: OR period_end_date < l_min_start_date
5172: OR period_schedule_percent = 0);

Line 5174: UPDATE psp_matrix_driver pmd

5170: AND (period_start_date > l_max_end_date
5171: OR period_end_date < l_min_start_date
5172: OR period_schedule_percent = 0);
5173:
5174: UPDATE psp_matrix_driver pmd
5175: SET period_end_date = period_end_date - 1
5176: WHERE run_id = l_run_id
5177: AND period_start_date < period_end_date
5178: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)

Line 5187: UPDATE psp_matrix_driver pmd

5183: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
5184: AND psl1.schedule_begin_date = pmd.period_end_date
5185: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5186:
5187: UPDATE psp_matrix_driver pmd
5188: SET period_end_date = period_end_date - 1
5189: WHERE run_id = l_run_id
5190: AND period_start_date < period_end_date
5191: AND NOT (NOT EXISTS (SELECT 1

Line 5204: UPDATE psp_matrix_driver pmd

5200: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5201: FROM psp_schedule_lines psl1
5202: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5203:
5204: UPDATE psp_matrix_driver pmd
5205: SET period_start_date = period_start_date + 1
5206: WHERE run_id = l_run_id
5207: AND period_start_date < period_end_date
5208: AND NOT EXISTS (SELECT 1

Line 5216: UPDATE psp_matrix_driver pmd

5212: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5213: FROM psp_schedule_lines psl1
5214: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5215:
5216: UPDATE psp_matrix_driver pmd
5217: SET period_start_date = period_start_date + 1
5218: WHERE run_id = l_run_id
5219: AND period_start_date < period_end_date
5220: AND EXISTS (SELECT 1

Line 5263: INSERT INTO psp_matrix_driver

5259: END IF;
5260: END LOOP;
5261:
5262: FORALL rowno IN 1..schedule_chunk.schedule_begin_date.COUNT
5263: INSERT INTO psp_matrix_driver
5264: (RUN_ID, SCHEDULE_LINE_ID,
5265: PERIOD_START_DATE, PERIOD_END_DATE,
5266: PERIOD_SCHEDULE_PERCENT)
5267: SELECT l_run_id, schedule_line_id,

Line 5526: -- psp_matrix_driver_pkg.clear_table('REFRESH'); Commented for bug fix 3970852

5522: r_enc_period_tmp1.r_effective_date.DELETE;
5523: l_rec_no := 1;
5524: l_proc_step := 130;
5525:
5526: -- psp_matrix_driver_pkg.clear_table('REFRESH'); Commented for bug fix 3970852
5527: -- psp_matrix_driver_pkg.purge_table; Commented for bug fix 3970852
5528:
5529: hr_utility.trace('Dumping Assignment Chunk After Assignment Processing ...');
5530: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||

Line 5527: -- psp_matrix_driver_pkg.purge_table; Commented for bug fix 3970852

5523: l_rec_no := 1;
5524: l_proc_step := 130;
5525:
5526: -- psp_matrix_driver_pkg.clear_table('REFRESH'); Commented for bug fix 3970852
5527: -- psp_matrix_driver_pkg.purge_table; Commented for bug fix 3970852
5528:
5529: hr_utility.trace('Dumping Assignment Chunk After Assignment Processing ...');
5530: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
5531: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||