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 4211: FROM psp_matrix_driver pmd

4207: CURSOR ls_matrix_cur IS
4208: SELECT GREATEST(l_min_start_date, period_start_date) period_start_date,
4209: LEAST(l_max_end_date, period_end_date) period_end_date,
4210: SUM(period_schedule_percent) schedule_percent
4211: FROM psp_matrix_driver pmd
4212: WHERE run_id = l_run_id
4213: AND period_start_date <= l_max_end_date
4214: AND period_end_date >= l_min_start_date
4215: GROUP BY GREATEST(l_min_start_date, period_start_date),

Line 4223: FROM psp_matrix_driver pmd,

4219: CURSOR eg_matrix_cur IS
4220: SELECT GREATEST(l_min_start_date, peg.start_date_active, period_start_date) period_start_date,
4221: LEAST(l_max_end_date, peg.end_date_active, period_end_date) period_end_date,
4222: SUM(period_schedule_percent) schedule_percent
4223: FROM psp_matrix_driver pmd,
4224: psp_schedule_lines psl,
4225: psp_schedule_hierarchy psh,
4226: psp_element_groups peg
4227: WHERE run_id = l_run_id

Line 4285: psp_matrix_driver_pkg.set_runid;

4281:
4282: recno INTEGER;
4283: -- End of bug fix 3970852
4284: BEGIN
4285: psp_matrix_driver_pkg.set_runid;
4286: l_run_id := psp_matrix_driver_pkg.get_run_id;
4287:
4288: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
4289: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||

Line 4286: l_run_id := psp_matrix_driver_pkg.get_run_id;

4282: recno INTEGER;
4283: -- End of bug fix 3970852
4284: BEGIN
4285: psp_matrix_driver_pkg.set_runid;
4286: l_run_id := psp_matrix_driver_pkg.get_run_id;
4287:
4288: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
4289: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
4290: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||

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

4598: FETCH ls_hier_cur INTO l_schedule_hierarchy_id;
4599: CLOSE ls_hier_cur;
4600:
4601: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
4602: psp_matrix_driver_pkg.clear_table('REFRESH');
4603: psp_matrix_driver_pkg.purge_table;
4604: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
4605:
4606: DELETE psp_matrix_driver

Line 4603: psp_matrix_driver_pkg.purge_table;

4599: CLOSE ls_hier_cur;
4600:
4601: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
4602: psp_matrix_driver_pkg.clear_table('REFRESH');
4603: psp_matrix_driver_pkg.purge_table;
4604: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
4605:
4606: DELETE psp_matrix_driver
4607: WHERE run_id = l_run_id

Line 4604: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);

4600:
4601: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
4602: psp_matrix_driver_pkg.clear_table('REFRESH');
4603: psp_matrix_driver_pkg.purge_table;
4604: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
4605:
4606: DELETE psp_matrix_driver
4607: WHERE run_id = l_run_id
4608: AND (period_start_date > l_max_end_date

Line 4606: DELETE psp_matrix_driver

4602: psp_matrix_driver_pkg.clear_table('REFRESH');
4603: psp_matrix_driver_pkg.purge_table;
4604: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
4605:
4606: DELETE psp_matrix_driver
4607: WHERE run_id = l_run_id
4608: AND (period_start_date > l_max_end_date
4609: OR period_end_date < l_min_start_date
4610: OR period_schedule_percent = 0);

Line 4612: UPDATE psp_matrix_driver pmd

4608: AND (period_start_date > l_max_end_date
4609: OR period_end_date < l_min_start_date
4610: OR period_schedule_percent = 0);
4611:
4612: UPDATE psp_matrix_driver pmd
4613: SET period_end_date = period_end_date - 1
4614: WHERE run_id = l_run_id
4615: AND period_start_date < period_end_date
4616: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)

Line 4625: UPDATE psp_matrix_driver pmd

4621: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
4622: AND psl1.schedule_begin_date = pmd.period_end_date
4623: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4624:
4625: UPDATE psp_matrix_driver pmd
4626: SET period_end_date = period_end_date - 1
4627: WHERE run_id = l_run_id
4628: AND period_start_date < period_end_date
4629: AND NOT (NOT EXISTS (SELECT 1

Line 4642: UPDATE psp_matrix_driver pmd

4638: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4639: FROM psp_schedule_lines psl1
4640: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4641:
4642: UPDATE psp_matrix_driver pmd
4643: SET period_start_date = period_start_date + 1
4644: WHERE run_id = l_run_id
4645: AND period_start_date < period_end_date
4646: AND NOT EXISTS (SELECT 1

Line 4654: UPDATE psp_matrix_driver pmd

4650: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4651: FROM psp_schedule_lines psl1
4652: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4653:
4654: UPDATE psp_matrix_driver pmd
4655: SET period_start_date = period_start_date + 1
4656: WHERE run_id = l_run_id
4657: AND period_start_date < period_end_date
4658: AND EXISTS (SELECT 1

Line 4701: INSERT INTO psp_matrix_driver

4697: END IF;
4698: END LOOP;
4699:
4700: FORALL rowno IN 1..schedule_chunk.schedule_begin_date.COUNT
4701: INSERT INTO psp_matrix_driver
4702: (RUN_ID, SCHEDULE_LINE_ID,
4703: PERIOD_START_DATE,
4704: PERIOD_END_DATE,
4705: PERIOD_SCHEDULE_PERCENT)

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

4990: RPAD(r_enc_period.r_reason_code(recno), 50, ' '));
4991: END LOOP;
4992: hr_utility.trace('Element Group Processing ...');
4993:
4994: psp_matrix_driver_pkg.clear_table('REFRESH');
4995: psp_matrix_driver_pkg.purge_table;
4996: l_period_count := r_enc_period.r_time_period_id.COUNT;
4997: OPEN eg_hier_cur;
4998: LOOP

Line 4995: psp_matrix_driver_pkg.purge_table;

4991: END LOOP;
4992: hr_utility.trace('Element Group Processing ...');
4993:
4994: psp_matrix_driver_pkg.clear_table('REFRESH');
4995: psp_matrix_driver_pkg.purge_table;
4996: l_period_count := r_enc_period.r_time_period_id.COUNT;
4997: OPEN eg_hier_cur;
4998: LOOP
4999: FETCH eg_hier_cur INTO l_schedule_hierarchy_id;

Line 5003: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);

4999: FETCH eg_hier_cur INTO l_schedule_hierarchy_id;
5000: EXIT WHEN eg_hier_cur%NOTFOUND;
5001:
5002: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
5003: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
5004:
5005: DELETE psp_matrix_driver
5006: WHERE run_id = l_run_id
5007: AND (period_start_date > l_max_end_date

Line 5005: DELETE psp_matrix_driver

5001:
5002: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
5003: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
5004:
5005: DELETE psp_matrix_driver
5006: WHERE run_id = l_run_id
5007: AND (period_start_date > l_max_end_date
5008: OR period_end_date < l_min_start_date
5009: OR period_schedule_percent = 0);

Line 5011: UPDATE psp_matrix_driver pmd

5007: AND (period_start_date > l_max_end_date
5008: OR period_end_date < l_min_start_date
5009: OR period_schedule_percent = 0);
5010:
5011: UPDATE psp_matrix_driver pmd
5012: SET period_end_date = period_end_date - 1
5013: WHERE run_id = l_run_id
5014: AND period_start_date < period_end_date
5015: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)

Line 5024: UPDATE psp_matrix_driver pmd

5020: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
5021: AND psl1.schedule_begin_date = pmd.period_end_date
5022: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5023:
5024: UPDATE psp_matrix_driver pmd
5025: SET period_end_date = period_end_date - 1
5026: WHERE run_id = l_run_id
5027: AND period_start_date < period_end_date
5028: AND NOT (NOT EXISTS (SELECT 1

Line 5041: UPDATE psp_matrix_driver pmd

5037: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5038: FROM psp_schedule_lines psl1
5039: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5040:
5041: UPDATE psp_matrix_driver pmd
5042: SET period_start_date = period_start_date + 1
5043: WHERE run_id = l_run_id
5044: AND period_start_date < period_end_date
5045: AND NOT EXISTS (SELECT 1

Line 5053: UPDATE psp_matrix_driver pmd

5049: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5050: FROM psp_schedule_lines psl1
5051: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5052:
5053: UPDATE psp_matrix_driver pmd
5054: SET period_start_date = period_start_date + 1
5055: WHERE run_id = l_run_id
5056: AND period_start_date < period_end_date
5057: AND EXISTS (SELECT 1

Line 5100: INSERT INTO psp_matrix_driver

5096: END IF;
5097: END LOOP;
5098:
5099: FORALL rowno IN 1..schedule_chunk.schedule_begin_date.COUNT
5100: INSERT INTO psp_matrix_driver
5101: (RUN_ID, SCHEDULE_LINE_ID,
5102: PERIOD_START_DATE,
5103: PERIOD_END_DATE,
5104: PERIOD_SCHEDULE_PERCENT)

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

5388: RPAD(r_enc_period_tmp1.r_reason_code(recno), 50, ' '));
5389: END LOOP;
5390: hr_utility.trace('Assignment Processing ...');
5391:
5392: psp_matrix_driver_pkg.clear_table('REFRESH');
5393: psp_matrix_driver_pkg.purge_table;
5394: l_period_count := r_enc_period.r_time_period_id.COUNT;
5395: OPEN ls_hier_cur('A');
5396: FETCH ls_hier_cur INTO l_schedule_hierarchy_id;

Line 5393: psp_matrix_driver_pkg.purge_table;

5389: END LOOP;
5390: hr_utility.trace('Assignment Processing ...');
5391:
5392: psp_matrix_driver_pkg.clear_table('REFRESH');
5393: psp_matrix_driver_pkg.purge_table;
5394: l_period_count := r_enc_period.r_time_period_id.COUNT;
5395: OPEN ls_hier_cur('A');
5396: FETCH ls_hier_cur INTO l_schedule_hierarchy_id;
5397: CLOSE ls_hier_cur;

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

5396: FETCH ls_hier_cur INTO l_schedule_hierarchy_id;
5397: CLOSE ls_hier_cur;
5398:
5399: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
5400: psp_matrix_driver_pkg.clear_table('REFRESH');
5401: psp_matrix_driver_pkg.purge_table;
5402: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
5403:
5404: DELETE psp_matrix_driver

Line 5401: psp_matrix_driver_pkg.purge_table;

5397: CLOSE ls_hier_cur;
5398:
5399: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
5400: psp_matrix_driver_pkg.clear_table('REFRESH');
5401: psp_matrix_driver_pkg.purge_table;
5402: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
5403:
5404: DELETE psp_matrix_driver
5405: WHERE run_id = l_run_id

Line 5402: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);

5398:
5399: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
5400: psp_matrix_driver_pkg.clear_table('REFRESH');
5401: psp_matrix_driver_pkg.purge_table;
5402: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
5403:
5404: DELETE psp_matrix_driver
5405: WHERE run_id = l_run_id
5406: AND (period_start_date > l_max_end_date

Line 5404: DELETE psp_matrix_driver

5400: psp_matrix_driver_pkg.clear_table('REFRESH');
5401: psp_matrix_driver_pkg.purge_table;
5402: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
5403:
5404: DELETE psp_matrix_driver
5405: WHERE run_id = l_run_id
5406: AND (period_start_date > l_max_end_date
5407: OR period_end_date < l_min_start_date
5408: OR period_schedule_percent = 0);

Line 5410: UPDATE psp_matrix_driver pmd

5406: AND (period_start_date > l_max_end_date
5407: OR period_end_date < l_min_start_date
5408: OR period_schedule_percent = 0);
5409:
5410: UPDATE psp_matrix_driver pmd
5411: SET period_end_date = period_end_date - 1
5412: WHERE run_id = l_run_id
5413: AND period_start_date < period_end_date
5414: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)

Line 5423: UPDATE psp_matrix_driver pmd

5419: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
5420: AND psl1.schedule_begin_date = pmd.period_end_date
5421: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5422:
5423: UPDATE psp_matrix_driver pmd
5424: SET period_end_date = period_end_date - 1
5425: WHERE run_id = l_run_id
5426: AND period_start_date < period_end_date
5427: AND NOT (NOT EXISTS (SELECT 1

Line 5440: UPDATE psp_matrix_driver pmd

5436: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5437: FROM psp_schedule_lines psl1
5438: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5439:
5440: UPDATE psp_matrix_driver pmd
5441: SET period_start_date = period_start_date + 1
5442: WHERE run_id = l_run_id
5443: AND period_start_date < period_end_date
5444: AND NOT EXISTS (SELECT 1

Line 5452: UPDATE psp_matrix_driver pmd

5448: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5449: FROM psp_schedule_lines psl1
5450: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5451:
5452: UPDATE psp_matrix_driver pmd
5453: SET period_start_date = period_start_date + 1
5454: WHERE run_id = l_run_id
5455: AND period_start_date < period_end_date
5456: AND EXISTS (SELECT 1

Line 5499: INSERT INTO psp_matrix_driver

5495: END IF;
5496: END LOOP;
5497:
5498: FORALL rowno IN 1..schedule_chunk.schedule_begin_date.COUNT
5499: INSERT INTO psp_matrix_driver
5500: (RUN_ID, SCHEDULE_LINE_ID,
5501: PERIOD_START_DATE, PERIOD_END_DATE,
5502: PERIOD_SCHEDULE_PERCENT)
5503: SELECT l_run_id, schedule_line_id,

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

5758: r_enc_period_tmp1.r_effective_date.DELETE;
5759: l_rec_no := 1;
5760: l_proc_step := 130;
5761:
5762: -- psp_matrix_driver_pkg.clear_table('REFRESH'); Commented for bug fix 3970852
5763: -- psp_matrix_driver_pkg.purge_table; Commented for bug fix 3970852
5764:
5765: hr_utility.trace('Dumping Assignment Chunk After Assignment Processing ...');
5766: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||

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

5759: l_rec_no := 1;
5760: l_proc_step := 130;
5761:
5762: -- psp_matrix_driver_pkg.clear_table('REFRESH'); Commented for bug fix 3970852
5763: -- psp_matrix_driver_pkg.purge_table; Commented for bug fix 3970852
5764:
5765: hr_utility.trace('Dumping Assignment Chunk After Assignment Processing ...');
5766: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
5767: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||