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_MATRIX_DRIVER_PKG dependencies on PSP_MATRIX_DRIVER

Line 1: package body psp_matrix_driver_pkg as

1: package body psp_matrix_driver_pkg as
2: /* $Header: PSPLSMTB.pls 120.5.12010000.4 2009/01/27 07:54:38 sabvenug ship $ */
3:
4: start_period BINARY_INTEGER:=1;
5: global_run_id NUMBER(9);

Line 35: delete from psp_matrix_driver

31: /* this procedure deletes all the records that have been inserted into the temp table in that session*/
32:
33: procedure clear_table (event VARCHAR2)is
34: BEGIN
35: delete from psp_matrix_driver
36: where run_id = global_run_id;
37: if (event = 'POST-FORM') then
38: --For Bug 2720395 : Uncommenting the Commit
39: COMMIT;

Line 187: from psp_matrix_driver

183: return null;
184: else
185: select sum(PERIOD_SCHEDULE_PERCENT)
186: into total
187: from psp_matrix_driver
188: where run_id = global_run_id
189: and period_start_date = st_date
190: and period_end_date = schedule_chunk.schedule_end_date(start_period+n+1);
191: return total;

Line 320: --Insert records in temporary table PSP_MATRIX_DRIVER. There may be some dates in 'dat1' which were not

316:
317: END LOOP;
318:
319: --
320: --Insert records in temporary table PSP_MATRIX_DRIVER. There may be some dates in 'dat1' which were not
321: --included in 'dat' because Begin Date was exactly 1 day greater than the End Date. In such a case,
322: --instead of comparing dates of 'dat' with those of psp_schedule_lines, compare (Begin Date+1) and End
323: --Date of 'dat' with those of psp_schedule_lines.
324: --

Line 352: insert into psp_matrix_driver(RUN_ID,

348: end if;
349:
350: end if;
351:
352: insert into psp_matrix_driver(RUN_ID,
353: SCHEDULE_LINE_ID,
354: PERIOD_START_DATE,
355: PERIOD_END_DATE,
356: PERIOD_SCHEDULE_PERCENT) values

Line 408: INSERT INTO psp_matrix_driver

404: END IF;
405: END LOOP;
406:
407: FORALL rowno IN 1..schedule_chunk.schedule_begin_date.COUNT
408: INSERT INTO psp_matrix_driver
409: (RUN_ID, SCHEDULE_LINE_ID,
410: PERIOD_START_DATE,
411: PERIOD_END_DATE,
412: PERIOD_SCHEDULE_PERCENT)

Line 423: INSERT INTO psp_matrix_driver

419: AND psl.schedule_begin_date <= schedule_chunk.schedule_end_date(rowno)
420: AND psl.schedule_end_date >= schedule_chunk.schedule_begin_date(rowno);
421:
422: FORALL rowno IN 1..schedule_chunk.schedule_begin_date.COUNT
423: INSERT INTO psp_matrix_driver
424: (RUN_ID, SCHEDULE_LINE_ID,
425: PERIOD_START_DATE,
426: PERIOD_END_DATE,
427: PERIOD_SCHEDULE_PERCENT)

Line 471: FROM psp_matrix_driver

467:
468: -- for bug fix 1779346
469: CURSOR sum_percent_cur IS --changed from sum to sum_percent_cur
470: SELECT sum(PERIOD_SCHEDULE_PERCENT)
471: FROM psp_matrix_driver
472: WHERE run_id = global_run_id
473: AND period_end_date > TRUNC ( NVL ( l_payroll_end_date,fnd_date.canonical_to_date('1900/01/01')))-- added this and conditoin for bug 2836176
474: GROUP BY period_start_date , period_end_date;
475:

Line 482: FROM psp_matrix_driver

478: -- Added cursor sum_percent_cur_left to include newly created schedule periods
479: --(whose end-dates < payroll_last_run_date) to be included in the check for LS>100%
480: CURSOR sum_percent_cur_left IS
481: SELECT sum(PERIOD_SCHEDULE_PERCENT)
482: FROM psp_matrix_driver
483: WHERE run_id = global_run_id
484: AND period_end_date <= TRUNC ( NVL ( l_payroll_end_date,fnd_date.canonical_to_date('1900/01/01')))-- added this and conditoin for bug 2836176
485: GROUP BY period_start_date , period_end_date;
486:

Line 545: from psp_matrix_driver

541: FUNCTION check_exceedence_sc_copy RETURN BOOLEAN IS
542: --For bug Fix 1779346
543: CURSOR sums IS
544: select sum(PERIOD_SCHEDULE_PERCENT)
545: from psp_matrix_driver
546: where run_id = global_run_id
547: group by PERIOD_START_DATE, PERIOD_END_DATE;
548: per number(5,2);
549:

Line 592: AND NOT EXISTS (SELECT 1 FROM psp_matrix_driver pmd

588: AND psl.business_group_id = p_business_group_id
589: AND psl.set_of_books_id = p_set_of_books_id
590: -- Included the following condition for bug fix 2020596 to prevent duplicate import of schedule data
591: -- for assignments that are assigned to more than one organization
592: AND NOT EXISTS (SELECT 1 FROM psp_matrix_driver pmd
593: WHERE pmd.run_id = global_run_id
594: AND pmd.schedule_line_id = psl.schedule_line_id);
595:
596: sch_hier_rec sch_hier_cur%ROWTYPE;

Line 658: psp_matrix_driver_pkg.set_runid;

654: fnd_msg_pub.initialize;
655:
656: -- set the run id for this run
657: -- errbuf := 'Run ID Initialization failed';
658: psp_matrix_driver_pkg.set_runid;
659:
660: -- Introduced the if condition for bug 2863953
661: If p_organization_id is null then
662:

Line 698: INSERT INTO psp_matrix_driver

694: END IF;
695: END LOOP;
696:
697: FORALL rowno IN 1..schedule_chunk.schedule_begin_date.COUNT
698: INSERT INTO psp_matrix_driver
699: (RUN_ID, SCHEDULE_LINE_ID,
700: PERIOD_START_DATE,
701: PERIOD_END_DATE,
702: PERIOD_SCHEDULE_PERCENT)

Line 754: -- psp_matrix_driver_pkg.load_table(sch_hier_rec.schedule_hierarchy_id); Commented for bug fix 3697471

750: -- call the matrix driver procedure to load the respective schedule lines
751: -- errbuf := 'Loading Matrix Driver for Schedule Hierarchy: ' ||
752: -- sch_hier_rec.schedule_hierarchy_id || ' had Failed';
753:
754: -- psp_matrix_driver_pkg.load_table(sch_hier_rec.schedule_hierarchy_id); Commented for bug fix 3697471
755: -- psp_matrix_driver_pkg.purge_table; Commented for bug fix 3697471
756:
757:
758: -- Introduced the following for bug fix 3697471

Line 755: -- psp_matrix_driver_pkg.purge_table; Commented for bug fix 3697471

751: -- errbuf := 'Loading Matrix Driver for Schedule Hierarchy: ' ||
752: -- sch_hier_rec.schedule_hierarchy_id || ' had Failed';
753:
754: -- psp_matrix_driver_pkg.load_table(sch_hier_rec.schedule_hierarchy_id); Commented for bug fix 3697471
755: -- psp_matrix_driver_pkg.purge_table; Commented for bug fix 3697471
756:
757:
758: -- Introduced the following for bug fix 3697471
759: k := 1;

Line 783: INSERT INTO psp_matrix_driver

779: END LOOP;
780:
781:
782: FORALL rowno IN 1..schedule_chunk.schedule_begin_date.COUNT
783: INSERT INTO psp_matrix_driver
784: (RUN_ID, SCHEDULE_LINE_ID,
785: PERIOD_START_DATE,
786: PERIOD_END_DATE,
787: PERIOD_SCHEDULE_PERCENT)

Line 818: -- Update the psp_matrix_driver table for the current run, deleting zero schedule percent records

814:
815: End if ; /* Introduced for bug 2863953 */
816:
817: /***** Commented for bug fix 3697471
818: -- Update the psp_matrix_driver table for the current run, deleting zero schedule percent records
819: -- errbuf := 'Deleting zero schedule percent records failed';
820: DELETE psp_matrix_driver pmd
821: WHERE run_id = global_run_id
822: AND period_schedule_percent = 0;

Line 820: DELETE psp_matrix_driver pmd

816:
817: /***** Commented for bug fix 3697471
818: -- Update the psp_matrix_driver table for the current run, deleting zero schedule percent records
819: -- errbuf := 'Deleting zero schedule percent records failed';
820: DELETE psp_matrix_driver pmd
821: WHERE run_id = global_run_id
822: AND period_schedule_percent = 0;
823:
824: / * Commented for bug fix 2368498

Line 825: UPDATE psp_matrix_driver pmd

821: WHERE run_id = global_run_id
822: AND period_schedule_percent = 0;
823:
824: / * Commented for bug fix 2368498
825: UPDATE psp_matrix_driver pmd
826: SET period_start_date = period_start_date + 1
827: WHERE run_id = global_run_id
828: AND EXISTS (SELECT 1
829: FROM psp_schedule_lines psl,

Line 836: UPDATE psp_matrix_driver pmd

832: AND psl2.schedule_hierarchy_id = psl.schedule_hierarchy_id
833: AND psl2.schedule_end_date = pmd.period_start_date
834: AND psl2.schedule_line_id <> psl.schedule_line_id);
835:
836: UPDATE psp_matrix_driver pmd
837: SET period_end_date = period_end_date - 1
838: WHERE run_id = global_run_id
839: AND EXISTS (SELECT 1
840: FROM psp_schedule_lines psl,

Line 851: UPDATE psp_matrix_driver pmd

847:
848: -- Introduced for bug fix 2368498
849: -- Updating the period_start_date for periods in between schedule begin and end dates
850: -- errbuf := 'Period End Date Update of Matrix Driver failed';
851: UPDATE psp_matrix_driver pmd
852: SET period_end_date = period_end_date - 1
853: WHERE run_id = global_run_id
854: AND period_start_date < period_end_date
855: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)

Line 868: UPDATE psp_matrix_driver pmd

864: AND psl1.schedule_hierarchy_id = (SELECT psl2.schedule_hierarchy_id
865: FROM psp_schedule_lines psl2
866: WHERE psl2.schedule_line_id = pmd.schedule_line_id));
867:
868: UPDATE psp_matrix_driver pmd
869: SET period_end_date = period_end_date - 1
870: WHERE run_id = global_run_id
871: AND period_start_date < period_end_date
872: AND NOT (NOT EXISTS (SELECT 1

Line 893: UPDATE psp_matrix_driver pmd

889: WHERE psl2.schedule_line_id = pmd.schedule_line_id));
890:
891: -- Updating the period_start_date for periods in between schedule begin and end dates
892: -- errbuf := 'Period Start Date Update of Matrix Driver failed';
893: UPDATE psp_matrix_driver pmd
894: SET period_start_date = period_start_date + 1
895: WHERE run_id = global_run_id
896: AND period_start_date < period_end_date
897: AND NOT EXISTS (SELECT 1

Line 909: UPDATE psp_matrix_driver pmd

905: WHERE psl1.schedule_hierarchy_id = (SELECT psl2.schedule_hierarchy_id
906: FROM psp_schedule_lines psl2
907: WHERE psl2.schedule_line_id = pmd.schedule_line_id));
908:
909: UPDATE psp_matrix_driver pmd
910: SET period_start_date = period_start_date + 1
911: WHERE run_id = global_run_id
912: AND period_start_date < period_end_date
913: AND EXISTS (SELECT 1

Line 934: -- For Exception Report delete records in psp_matrix_driver for which the schedule percentage is 100

930: WHERE psl2.schedule_line_id = pmd.schedule_line_id));
931: -- End of Bug fix 2368498
932: End of changes for bug fix 3697471 *****/
933:
934: -- For Exception Report delete records in psp_matrix_driver for which the schedule percentage is 100
935: IF (p_report_type = 'E') THEN
936: -- errbuf := 'Deleting schedules equal to 100 percent failed';
937: l_report_type := 'Exception';
938: DELETE psp_matrix_driver pmd

Line 938: DELETE psp_matrix_driver pmd

934: -- For Exception Report delete records in psp_matrix_driver for which the schedule percentage is 100
935: IF (p_report_type = 'E') THEN
936: -- errbuf := 'Deleting schedules equal to 100 percent failed';
937: l_report_type := 'Exception';
938: DELETE psp_matrix_driver pmd
939: WHERE run_id = global_run_id
940: AND EXISTS (SELECT 1
941: FROM psp_schedule_lines psl,
942: psp_schedule_lines psl2

Line 953: UPDATE psp_matrix_driver

949: END IF;
950:
951: /***** Commented for bug fix 3697471
952: -- Update the period_end_date to p_period_to if period_end_date > p_period_to
953: UPDATE psp_matrix_driver
954: SET period_end_date = p_period_to
955: WHERE run_id = global_run_id
956: AND period_end_date > p_period_to;
957:

Line 958: UPDATE psp_matrix_driver

954: SET period_end_date = p_period_to
955: WHERE run_id = global_run_id
956: AND period_end_date > p_period_to;
957:
958: UPDATE psp_matrix_driver
959: SET period_start_date = p_period_from
960: WHERE run_id = global_run_id
961: AND period_start_date < p_period_from;
962: End of comment for bug fix 3697471 *****/

Line 983: it loads the table psp_matrix_Driver by calling procedure

979:
980: Purpose : This procedure does the following jobs :
981: X=10:Sets the Run id for the psp_matrix_table
982: X=20:For each organization chosen by the user (p_list_organization_id)
983: it loads the table psp_matrix_Driver by calling procedure
984: load_table_schedule
985: X=30:Updates the period_start_date of the schedule_lines in matrix_driver table
986: ,for each organization,except the schedule lines with minimum period_start_date
987: so that data in the table becomes as required for the report PSPLSODR.rdf

Line 1021: psp_matrix_driver pmd

1017: SELECT pdls.organization_id,
1018: pmd.period_start_date,
1019: pmd.period_end_date
1020: FROM psp_default_labor_schedules pdls,
1021: psp_matrix_driver pmd
1022: WHERE pdls.org_schedule_id = pmd.schedule_line_id
1023: AND pmd.run_id = F_run_id
1024: GROUP BY pdls.organization_id,
1025: pmd.period_start_date,

Line 1037: psp_matrix_driver pmd

1033: F_run_id NUMBER)
1034: IS
1035: SELECT pdls.org_schedule_id
1036: FROM psp_default_labor_schedules pdls,
1037: psp_matrix_driver pmd
1038: WHERE pdls.organization_id = F_organization_id
1039: AND pdls.schedule_begin_date <= F_period_end_date
1040: AND pdls.schedule_end_date >= F_period_start_date
1041: AND pmd.schedule_line_id = pdls.org_Schedule_id

Line 1049: FROM psp_matrix_driver pmd1,

1045: CURSOR c_period_start_date(F_run_id NUMBER)
1046: IS
1047: SELECT min(pmd1.period_start_date) period_start_date,
1048: pdls.organization_id
1049: FROM psp_matrix_driver pmd1,
1050: psp_default_labor_schedules pdls
1051: WHERE pmd1.run_id = F_run_id
1052: AND pmd1.schedule_line_id = pdls.org_schedule_id
1053: GROUP BY pdls.organization_id;

Line 1093: psp_matrix_driver_pkg.set_runid;

1089: --set the Run Id for the current request
1090: --dbms_output.put_line('Organization List '||p_list_organization_id);
1091:
1092: --X=10
1093: psp_matrix_driver_pkg.set_runid;
1094: l_run_id := psp_matrix_driver_pkg.get_run_id;
1095: --dbms_output.put_line(l_run_id);
1096: --errbuf := 'Run id '||global_run_id;
1097: psp_matrix_driver_pkg.purge_table;

Line 1094: l_run_id := psp_matrix_driver_pkg.get_run_id;

1090: --dbms_output.put_line('Organization List '||p_list_organization_id);
1091:
1092: --X=10
1093: psp_matrix_driver_pkg.set_runid;
1094: l_run_id := psp_matrix_driver_pkg.get_run_id;
1095: --dbms_output.put_line(l_run_id);
1096: --errbuf := 'Run id '||global_run_id;
1097: psp_matrix_driver_pkg.purge_table;
1098:

Line 1097: psp_matrix_driver_pkg.purge_table;

1093: psp_matrix_driver_pkg.set_runid;
1094: l_run_id := psp_matrix_driver_pkg.get_run_id;
1095: --dbms_output.put_line(l_run_id);
1096: --errbuf := 'Run id '||global_run_id;
1097: psp_matrix_driver_pkg.purge_table;
1098:
1099: --X=20
1100:
1101: If p_list_organization_id is null then

Line 1105: psp_matrix_driver_pkg.load_table_schedule(to_number(l_org_rec.organization_id)

1101: If p_list_organization_id is null then
1102:
1103: For l_org_rec in c_all_org
1104: loop
1105: psp_matrix_driver_pkg.load_table_schedule(to_number(l_org_rec.organization_id)
1106: ,p_business_group_id,p_set_of_books_id);
1107: psp_matrix_driver_pkg.purge_table;
1108: end loop;
1109:

Line 1107: psp_matrix_driver_pkg.purge_table;

1103: For l_org_rec in c_all_org
1104: loop
1105: psp_matrix_driver_pkg.load_table_schedule(to_number(l_org_rec.organization_id)
1106: ,p_business_group_id,p_set_of_books_id);
1107: psp_matrix_driver_pkg.purge_table;
1108: end loop;
1109:
1110:
1111: else

Line 1120: psp_matrix_driver_pkg.load_table_schedule(to_number(l_org_id),p_business_group_id,p_set_of_books_id);

1116: IF (l_end_position = 0) THEN
1117: l_end_position := l_org_length + 1;
1118: END IF;
1119: l_org_id := TO_NUMBER(SUBSTR(p_list_organization_id, l_begin_position,(l_end_position - l_begin_position)));
1120: psp_matrix_driver_pkg.load_table_schedule(to_number(l_org_id),p_business_group_id,p_set_of_books_id);
1121: psp_matrix_driver_pkg.purge_table;
1122: IF (l_end_position > l_org_length) THEN
1123: EXIT;
1124: END IF;

Line 1121: psp_matrix_driver_pkg.purge_table;

1117: l_end_position := l_org_length + 1;
1118: END IF;
1119: l_org_id := TO_NUMBER(SUBSTR(p_list_organization_id, l_begin_position,(l_end_position - l_begin_position)));
1120: psp_matrix_driver_pkg.load_table_schedule(to_number(l_org_id),p_business_group_id,p_set_of_books_id);
1121: psp_matrix_driver_pkg.purge_table;
1122: IF (l_end_position > l_org_length) THEN
1123: EXIT;
1124: END IF;
1125: l_begin_position := l_end_position + 1;

Line 1130: --Updating the records created in psp_matrix_driver in the manner required to be displayed in the report

1126: END LOOP; -- End Organization Id split
1127:
1128: end if;
1129: --X=30
1130: --Updating the records created in psp_matrix_driver in the manner required to be displayed in the report
1131: UPDATE psp_matrix_driver pmd
1132: SET period_start_date = period_start_date + 1
1133: WHERE run_id =l_run_id
1134: AND EXISTS (SELECT 1

Line 1131: UPDATE psp_matrix_driver pmd

1127:
1128: end if;
1129: --X=30
1130: --Updating the records created in psp_matrix_driver in the manner required to be displayed in the report
1131: UPDATE psp_matrix_driver pmd
1132: SET period_start_date = period_start_date + 1
1133: WHERE run_id =l_run_id
1134: AND EXISTS (SELECT 1
1135: FROM psp_default_labor_schedules pdls1,

Line 1142: UPDATE psp_matrix_driver pmd

1138: AND pdls1.organization_id=pdls2.organization_id
1139: AND pdls1.org_schedule_id<>pdls2.org_schedule_id
1140: AND pdls2.schedule_end_date=pmd.period_start_date);
1141:
1142: UPDATE psp_matrix_driver pmd
1143: SET period_end_date = period_end_date - 1
1144: WHERE run_id =l_run_id
1145: AND EXISTS (SELECT pmd.period_end_date
1146: FROM psp_default_labor_schedules pdls1,

Line 1155: DELETE psp_matrix_driver

1151: AND pdls1.org_schedule_id<>pdls2.org_schedule_id);
1152:
1153: --X=40
1154: -- Delete the Zero Schedule Percent
1155: DELETE psp_matrix_driver
1156: WHERE run_id = global_run_id
1157: AND period_schedule_percent = 0;
1158:
1159: --X=50

Line 1176: DELETE psp_matrix_driver pmd

1172: LOOP
1173: FETCH c_schedule_line_id INTO rec_sch_line_id;
1174: EXIT WHEN c_schedule_line_id%NOTFOUND;
1175:
1176: DELETE psp_matrix_driver pmd
1177: WHERE pmd.run_id = l_run_id
1178: And pmd.schedule_line_id = rec_sch_line_id.org_schedule_id
1179: And pmd.period_start_date = rec_sch_percent.period_start_date
1180: And pmd.period_end_date = rec_sch_percent.period_end_date;

Line 1190: UPDATE psp_matrix_driver

1186: END IF;
1187:
1188: --Updating the records greater than p_period_to to NUll ,so that in Schedule Summary in report these will be
1189: --displayed with end date as p_period_to
1190: UPDATE psp_matrix_driver
1191: SET period_end_date = p_period_to
1192: WHERE run_id = l_run_id
1193: AND period_end_date > p_period_to;
1194:

Line 1195: UPDATE psp_matrix_driver

1191: SET period_end_date = p_period_to
1192: WHERE run_id = l_run_id
1193: AND period_end_date > p_period_to;
1194:
1195: UPDATE psp_matrix_driver
1196: SET period_start_date = p_period_from
1197: WHERE run_id = l_run_id
1198: AND period_start_date < p_period_from;
1199:

Line 1214: Purpose : This procedure is introduced to populate psp_matrix_driver with the

1210: Created By : lveerubh
1211:
1212: Date Created By : 05-SEP-2001
1213:
1214: Purpose : This procedure is introduced to populate psp_matrix_driver with the
1215: data from psp_default_labor_schedules.It sorts the pool of begin and end dates
1216: specified on the various schedule lines. After the sort it inserts the dates into
1217: pl/sql table thereby forming distinct periods of consistent charging instructions.
1218: Once the pl/sql table is loaded, the start and end dates of the distinct periods are

Line 1308: --Insert records in temporary table PSP_MATRIX_DRIVER. There may be some dates in 'dat1' which were not

1304:
1305: END LOOP;
1306:
1307: --
1308: --Insert records in temporary table PSP_MATRIX_DRIVER. There may be some dates in 'dat1' which were not
1309: --included in 'dat' because Begin Date was exactly 1 day greater than the End Date. In such a case,
1310: --instead of comparing dates of 'dat' with those of psp_schedule_lines, compare (Begin Date+1) and End
1311: --Date of 'dat' with those of psp_schedule_lines.
1312: --

Line 1341: INSERT INTO psp_matrix_driver(RUN_ID,

1337: END IF;
1338:
1339: END IF;
1340:
1341: INSERT INTO psp_matrix_driver(RUN_ID,
1342: SCHEDULE_LINE_ID,
1343: PERIOD_START_DATE,
1344: PERIOD_END_DATE,
1345: PERIOD_SCHEDULE_PERCENT) values

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

1386: OPEN sch_hier_cur;
1387: LOOP
1388: FETCH sch_hier_cur INTO l_schedule_hierarchy_id;
1389: EXIT WHEN sch_hier_cur%NOTFOUND;
1390: psp_matrix_driver_pkg.clear_table('REFRESH');
1391: psp_matrix_driver_pkg.purge_table;
1392: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
1393: IF (NOT psp_matrix_driver_pkg.check_exceedence(p_assignment_id)) THEN
1394: l_invalid_count := l_invalid_count + 1;

Line 1391: psp_matrix_driver_pkg.purge_table;

1387: LOOP
1388: FETCH sch_hier_cur INTO l_schedule_hierarchy_id;
1389: EXIT WHEN sch_hier_cur%NOTFOUND;
1390: psp_matrix_driver_pkg.clear_table('REFRESH');
1391: psp_matrix_driver_pkg.purge_table;
1392: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
1393: IF (NOT psp_matrix_driver_pkg.check_exceedence(p_assignment_id)) THEN
1394: l_invalid_count := l_invalid_count + 1;
1395: p_hierarchy_id :=l_schedule_hierarchy_id;

Line 1392: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);

1388: FETCH sch_hier_cur INTO l_schedule_hierarchy_id;
1389: EXIT WHEN sch_hier_cur%NOTFOUND;
1390: psp_matrix_driver_pkg.clear_table('REFRESH');
1391: psp_matrix_driver_pkg.purge_table;
1392: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
1393: IF (NOT psp_matrix_driver_pkg.check_exceedence(p_assignment_id)) THEN
1394: l_invalid_count := l_invalid_count + 1;
1395: p_hierarchy_id :=l_schedule_hierarchy_id;
1396: END IF;

Line 1393: IF (NOT psp_matrix_driver_pkg.check_exceedence(p_assignment_id)) THEN

1389: EXIT WHEN sch_hier_cur%NOTFOUND;
1390: psp_matrix_driver_pkg.clear_table('REFRESH');
1391: psp_matrix_driver_pkg.purge_table;
1392: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
1393: IF (NOT psp_matrix_driver_pkg.check_exceedence(p_assignment_id)) THEN
1394: l_invalid_count := l_invalid_count + 1;
1395: p_hierarchy_id :=l_schedule_hierarchy_id;
1396: END IF;
1397: END LOOP;

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

1395: p_hierarchy_id :=l_schedule_hierarchy_id;
1396: END IF;
1397: END LOOP;
1398: CLOSE sch_hier_cur;
1399: psp_matrix_driver_pkg.clear_table('REFRESH');
1400: psp_matrix_driver_pkg.purge_table;
1401: p_invalid_count := l_invalid_count;
1402: END check_sch_hierarchy;
1403:

Line 1400: psp_matrix_driver_pkg.purge_table;

1396: END IF;
1397: END LOOP;
1398: CLOSE sch_hier_cur;
1399: psp_matrix_driver_pkg.clear_table('REFRESH');
1400: psp_matrix_driver_pkg.purge_table;
1401: p_invalid_count := l_invalid_count;
1402: END check_sch_hierarchy;
1403:
1404: /* End of code for Bug no 2836176 By tbalacha*/

Line 1407: end psp_matrix_driver_pkg;

1403:
1404: /* End of code for Bug no 2836176 By tbalacha*/
1405:
1406:
1407: end psp_matrix_driver_pkg;