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.2 2008/08/05 10:13:30 ubhat 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 511: from psp_matrix_driver

507: FUNCTION check_exceedence_sc_copy RETURN BOOLEAN IS
508: --For bug Fix 1779346
509: CURSOR sums IS
510: select sum(PERIOD_SCHEDULE_PERCENT)
511: from psp_matrix_driver
512: where run_id = global_run_id
513: group by PERIOD_START_DATE, PERIOD_END_DATE;
514: per number(5,2);
515:

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

554: AND psl.business_group_id = p_business_group_id
555: AND psl.set_of_books_id = p_set_of_books_id
556: -- Included the following condition for bug fix 2020596 to prevent duplicate import of schedule data
557: -- for assignments that are assigned to more than one organization
558: AND NOT EXISTS (SELECT 1 FROM psp_matrix_driver pmd
559: WHERE pmd.run_id = global_run_id
560: AND pmd.schedule_line_id = psl.schedule_line_id);
561:
562: sch_hier_rec sch_hier_cur%ROWTYPE;

Line 624: psp_matrix_driver_pkg.set_runid;

620: fnd_msg_pub.initialize;
621:
622: -- set the run id for this run
623: -- errbuf := 'Run ID Initialization failed';
624: psp_matrix_driver_pkg.set_runid;
625:
626: -- Introduced the if condition for bug 2863953
627: If p_organization_id is null then
628:

Line 664: INSERT INTO psp_matrix_driver

660: END IF;
661: END LOOP;
662:
663: FORALL rowno IN 1..schedule_chunk.schedule_begin_date.COUNT
664: INSERT INTO psp_matrix_driver
665: (RUN_ID, SCHEDULE_LINE_ID,
666: PERIOD_START_DATE,
667: PERIOD_END_DATE,
668: PERIOD_SCHEDULE_PERCENT)

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

716: -- call the matrix driver procedure to load the respective schedule lines
717: -- errbuf := 'Loading Matrix Driver for Schedule Hierarchy: ' ||
718: -- sch_hier_rec.schedule_hierarchy_id || ' had Failed';
719:
720: -- psp_matrix_driver_pkg.load_table(sch_hier_rec.schedule_hierarchy_id); Commented for bug fix 3697471
721: -- psp_matrix_driver_pkg.purge_table; Commented for bug fix 3697471
722:
723:
724: -- Introduced the following for bug fix 3697471

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

717: -- errbuf := 'Loading Matrix Driver for Schedule Hierarchy: ' ||
718: -- sch_hier_rec.schedule_hierarchy_id || ' had Failed';
719:
720: -- psp_matrix_driver_pkg.load_table(sch_hier_rec.schedule_hierarchy_id); Commented for bug fix 3697471
721: -- psp_matrix_driver_pkg.purge_table; Commented for bug fix 3697471
722:
723:
724: -- Introduced the following for bug fix 3697471
725: k := 1;

Line 749: INSERT INTO psp_matrix_driver

745: END LOOP;
746:
747:
748: FORALL rowno IN 1..schedule_chunk.schedule_begin_date.COUNT
749: INSERT INTO psp_matrix_driver
750: (RUN_ID, SCHEDULE_LINE_ID,
751: PERIOD_START_DATE,
752: PERIOD_END_DATE,
753: PERIOD_SCHEDULE_PERCENT)

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

780:
781: End if ; /* Introduced for bug 2863953 */
782:
783: /***** Commented for bug fix 3697471
784: -- Update the psp_matrix_driver table for the current run, deleting zero schedule percent records
785: -- errbuf := 'Deleting zero schedule percent records failed';
786: DELETE psp_matrix_driver pmd
787: WHERE run_id = global_run_id
788: AND period_schedule_percent = 0;

Line 786: DELETE psp_matrix_driver pmd

782:
783: /***** Commented for bug fix 3697471
784: -- Update the psp_matrix_driver table for the current run, deleting zero schedule percent records
785: -- errbuf := 'Deleting zero schedule percent records failed';
786: DELETE psp_matrix_driver pmd
787: WHERE run_id = global_run_id
788: AND period_schedule_percent = 0;
789:
790: / * Commented for bug fix 2368498

Line 791: UPDATE psp_matrix_driver pmd

787: WHERE run_id = global_run_id
788: AND period_schedule_percent = 0;
789:
790: / * Commented for bug fix 2368498
791: UPDATE psp_matrix_driver pmd
792: SET period_start_date = period_start_date + 1
793: WHERE run_id = global_run_id
794: AND EXISTS (SELECT 1
795: FROM psp_schedule_lines psl,

Line 802: UPDATE psp_matrix_driver pmd

798: AND psl2.schedule_hierarchy_id = psl.schedule_hierarchy_id
799: AND psl2.schedule_end_date = pmd.period_start_date
800: AND psl2.schedule_line_id <> psl.schedule_line_id);
801:
802: UPDATE psp_matrix_driver pmd
803: SET period_end_date = period_end_date - 1
804: WHERE run_id = global_run_id
805: AND EXISTS (SELECT 1
806: FROM psp_schedule_lines psl,

Line 817: UPDATE psp_matrix_driver pmd

813:
814: -- Introduced for bug fix 2368498
815: -- Updating the period_start_date for periods in between schedule begin and end dates
816: -- errbuf := 'Period End Date Update of Matrix Driver failed';
817: UPDATE psp_matrix_driver pmd
818: SET period_end_date = period_end_date - 1
819: WHERE run_id = global_run_id
820: AND period_start_date < period_end_date
821: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)

Line 834: UPDATE psp_matrix_driver pmd

830: AND psl1.schedule_hierarchy_id = (SELECT psl2.schedule_hierarchy_id
831: FROM psp_schedule_lines psl2
832: WHERE psl2.schedule_line_id = pmd.schedule_line_id));
833:
834: UPDATE psp_matrix_driver pmd
835: SET period_end_date = period_end_date - 1
836: WHERE run_id = global_run_id
837: AND period_start_date < period_end_date
838: AND NOT (NOT EXISTS (SELECT 1

Line 859: UPDATE psp_matrix_driver pmd

855: WHERE psl2.schedule_line_id = pmd.schedule_line_id));
856:
857: -- Updating the period_start_date for periods in between schedule begin and end dates
858: -- errbuf := 'Period Start Date Update of Matrix Driver failed';
859: UPDATE psp_matrix_driver pmd
860: SET period_start_date = period_start_date + 1
861: WHERE run_id = global_run_id
862: AND period_start_date < period_end_date
863: AND NOT EXISTS (SELECT 1

Line 875: UPDATE psp_matrix_driver pmd

871: WHERE psl1.schedule_hierarchy_id = (SELECT psl2.schedule_hierarchy_id
872: FROM psp_schedule_lines psl2
873: WHERE psl2.schedule_line_id = pmd.schedule_line_id));
874:
875: UPDATE psp_matrix_driver pmd
876: SET period_start_date = period_start_date + 1
877: WHERE run_id = global_run_id
878: AND period_start_date < period_end_date
879: AND EXISTS (SELECT 1

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

896: WHERE psl2.schedule_line_id = pmd.schedule_line_id));
897: -- End of Bug fix 2368498
898: End of changes for bug fix 3697471 *****/
899:
900: -- For Exception Report delete records in psp_matrix_driver for which the schedule percentage is 100
901: IF (p_report_type = 'E') THEN
902: -- errbuf := 'Deleting schedules equal to 100 percent failed';
903: l_report_type := 'Exception';
904: DELETE psp_matrix_driver pmd

Line 904: DELETE psp_matrix_driver pmd

900: -- For Exception Report delete records in psp_matrix_driver for which the schedule percentage is 100
901: IF (p_report_type = 'E') THEN
902: -- errbuf := 'Deleting schedules equal to 100 percent failed';
903: l_report_type := 'Exception';
904: DELETE psp_matrix_driver pmd
905: WHERE run_id = global_run_id
906: AND EXISTS (SELECT 1
907: FROM psp_schedule_lines psl,
908: psp_schedule_lines psl2

Line 919: UPDATE psp_matrix_driver

915: END IF;
916:
917: /***** Commented for bug fix 3697471
918: -- Update the period_end_date to p_period_to if period_end_date > p_period_to
919: UPDATE psp_matrix_driver
920: SET period_end_date = p_period_to
921: WHERE run_id = global_run_id
922: AND period_end_date > p_period_to;
923:

Line 924: UPDATE psp_matrix_driver

920: SET period_end_date = p_period_to
921: WHERE run_id = global_run_id
922: AND period_end_date > p_period_to;
923:
924: UPDATE psp_matrix_driver
925: SET period_start_date = p_period_from
926: WHERE run_id = global_run_id
927: AND period_start_date < p_period_from;
928: End of comment for bug fix 3697471 *****/

Line 949: it loads the table psp_matrix_Driver by calling procedure

945:
946: Purpose : This procedure does the following jobs :
947: X=10:Sets the Run id for the psp_matrix_table
948: X=20:For each organization chosen by the user (p_list_organization_id)
949: it loads the table psp_matrix_Driver by calling procedure
950: load_table_schedule
951: X=30:Updates the period_start_date of the schedule_lines in matrix_driver table
952: ,for each organization,except the schedule lines with minimum period_start_date
953: so that data in the table becomes as required for the report PSPLSODR.rdf

Line 987: psp_matrix_driver pmd

983: SELECT pdls.organization_id,
984: pmd.period_start_date,
985: pmd.period_end_date
986: FROM psp_default_labor_schedules pdls,
987: psp_matrix_driver pmd
988: WHERE pdls.org_schedule_id = pmd.schedule_line_id
989: AND pmd.run_id = F_run_id
990: GROUP BY pdls.organization_id,
991: pmd.period_start_date,

Line 1003: psp_matrix_driver pmd

999: F_run_id NUMBER)
1000: IS
1001: SELECT pdls.org_schedule_id
1002: FROM psp_default_labor_schedules pdls,
1003: psp_matrix_driver pmd
1004: WHERE pdls.organization_id = F_organization_id
1005: AND pdls.schedule_begin_date <= F_period_end_date
1006: AND pdls.schedule_end_date >= F_period_start_date
1007: AND pmd.schedule_line_id = pdls.org_Schedule_id

Line 1015: FROM psp_matrix_driver pmd1,

1011: CURSOR c_period_start_date(F_run_id NUMBER)
1012: IS
1013: SELECT min(pmd1.period_start_date) period_start_date,
1014: pdls.organization_id
1015: FROM psp_matrix_driver pmd1,
1016: psp_default_labor_schedules pdls
1017: WHERE pmd1.run_id = F_run_id
1018: AND pmd1.schedule_line_id = pdls.org_schedule_id
1019: GROUP BY pdls.organization_id;

Line 1059: psp_matrix_driver_pkg.set_runid;

1055: --set the Run Id for the current request
1056: --dbms_output.put_line('Organization List '||p_list_organization_id);
1057:
1058: --X=10
1059: psp_matrix_driver_pkg.set_runid;
1060: l_run_id := psp_matrix_driver_pkg.get_run_id;
1061: --dbms_output.put_line(l_run_id);
1062: --errbuf := 'Run id '||global_run_id;
1063: psp_matrix_driver_pkg.purge_table;

Line 1060: l_run_id := psp_matrix_driver_pkg.get_run_id;

1056: --dbms_output.put_line('Organization List '||p_list_organization_id);
1057:
1058: --X=10
1059: psp_matrix_driver_pkg.set_runid;
1060: l_run_id := psp_matrix_driver_pkg.get_run_id;
1061: --dbms_output.put_line(l_run_id);
1062: --errbuf := 'Run id '||global_run_id;
1063: psp_matrix_driver_pkg.purge_table;
1064:

Line 1063: psp_matrix_driver_pkg.purge_table;

1059: psp_matrix_driver_pkg.set_runid;
1060: l_run_id := psp_matrix_driver_pkg.get_run_id;
1061: --dbms_output.put_line(l_run_id);
1062: --errbuf := 'Run id '||global_run_id;
1063: psp_matrix_driver_pkg.purge_table;
1064:
1065: --X=20
1066:
1067: If p_list_organization_id is null then

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

1067: If p_list_organization_id is null then
1068:
1069: For l_org_rec in c_all_org
1070: loop
1071: psp_matrix_driver_pkg.load_table_schedule(to_number(l_org_rec.organization_id)
1072: ,p_business_group_id,p_set_of_books_id);
1073: psp_matrix_driver_pkg.purge_table;
1074: end loop;
1075:

Line 1073: psp_matrix_driver_pkg.purge_table;

1069: For l_org_rec in c_all_org
1070: loop
1071: psp_matrix_driver_pkg.load_table_schedule(to_number(l_org_rec.organization_id)
1072: ,p_business_group_id,p_set_of_books_id);
1073: psp_matrix_driver_pkg.purge_table;
1074: end loop;
1075:
1076:
1077: else

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

1082: IF (l_end_position = 0) THEN
1083: l_end_position := l_org_length + 1;
1084: END IF;
1085: l_org_id := TO_NUMBER(SUBSTR(p_list_organization_id, l_begin_position,(l_end_position - l_begin_position)));
1086: psp_matrix_driver_pkg.load_table_schedule(to_number(l_org_id),p_business_group_id,p_set_of_books_id);
1087: psp_matrix_driver_pkg.purge_table;
1088: IF (l_end_position > l_org_length) THEN
1089: EXIT;
1090: END IF;

Line 1087: psp_matrix_driver_pkg.purge_table;

1083: l_end_position := l_org_length + 1;
1084: END IF;
1085: l_org_id := TO_NUMBER(SUBSTR(p_list_organization_id, l_begin_position,(l_end_position - l_begin_position)));
1086: psp_matrix_driver_pkg.load_table_schedule(to_number(l_org_id),p_business_group_id,p_set_of_books_id);
1087: psp_matrix_driver_pkg.purge_table;
1088: IF (l_end_position > l_org_length) THEN
1089: EXIT;
1090: END IF;
1091: l_begin_position := l_end_position + 1;

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

1092: END LOOP; -- End Organization Id split
1093:
1094: end if;
1095: --X=30
1096: --Updating the records created in psp_matrix_driver in the manner required to be displayed in the report
1097: UPDATE psp_matrix_driver pmd
1098: SET period_start_date = period_start_date + 1
1099: WHERE run_id =l_run_id
1100: AND EXISTS (SELECT 1

Line 1097: UPDATE psp_matrix_driver pmd

1093:
1094: end if;
1095: --X=30
1096: --Updating the records created in psp_matrix_driver in the manner required to be displayed in the report
1097: UPDATE psp_matrix_driver pmd
1098: SET period_start_date = period_start_date + 1
1099: WHERE run_id =l_run_id
1100: AND EXISTS (SELECT 1
1101: FROM psp_default_labor_schedules pdls1,

Line 1108: UPDATE psp_matrix_driver pmd

1104: AND pdls1.organization_id=pdls2.organization_id
1105: AND pdls1.org_schedule_id<>pdls2.org_schedule_id
1106: AND pdls2.schedule_end_date=pmd.period_start_date);
1107:
1108: UPDATE psp_matrix_driver pmd
1109: SET period_end_date = period_end_date - 1
1110: WHERE run_id =l_run_id
1111: AND EXISTS (SELECT pmd.period_end_date
1112: FROM psp_default_labor_schedules pdls1,

Line 1121: DELETE psp_matrix_driver

1117: AND pdls1.org_schedule_id<>pdls2.org_schedule_id);
1118:
1119: --X=40
1120: -- Delete the Zero Schedule Percent
1121: DELETE psp_matrix_driver
1122: WHERE run_id = global_run_id
1123: AND period_schedule_percent = 0;
1124:
1125: --X=50

Line 1142: DELETE psp_matrix_driver pmd

1138: LOOP
1139: FETCH c_schedule_line_id INTO rec_sch_line_id;
1140: EXIT WHEN c_schedule_line_id%NOTFOUND;
1141:
1142: DELETE psp_matrix_driver pmd
1143: WHERE pmd.run_id = l_run_id
1144: And pmd.schedule_line_id = rec_sch_line_id.org_schedule_id
1145: And pmd.period_start_date = rec_sch_percent.period_start_date
1146: And pmd.period_end_date = rec_sch_percent.period_end_date;

Line 1156: UPDATE psp_matrix_driver

1152: END IF;
1153:
1154: --Updating the records greater than p_period_to to NUll ,so that in Schedule Summary in report these will be
1155: --displayed with end date as p_period_to
1156: UPDATE psp_matrix_driver
1157: SET period_end_date = p_period_to
1158: WHERE run_id = l_run_id
1159: AND period_end_date > p_period_to;
1160:

Line 1161: UPDATE psp_matrix_driver

1157: SET period_end_date = p_period_to
1158: WHERE run_id = l_run_id
1159: AND period_end_date > p_period_to;
1160:
1161: UPDATE psp_matrix_driver
1162: SET period_start_date = p_period_from
1163: WHERE run_id = l_run_id
1164: AND period_start_date < p_period_from;
1165:

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

1176: Created By : lveerubh
1177:
1178: Date Created By : 05-SEP-2001
1179:
1180: Purpose : This procedure is introduced to populate psp_matrix_driver with the
1181: data from psp_default_labor_schedules.It sorts the pool of begin and end dates
1182: specified on the various schedule lines. After the sort it inserts the dates into
1183: pl/sql table thereby forming distinct periods of consistent charging instructions.
1184: Once the pl/sql table is loaded, the start and end dates of the distinct periods are

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

1270:
1271: END LOOP;
1272:
1273: --
1274: --Insert records in temporary table PSP_MATRIX_DRIVER. There may be some dates in 'dat1' which were not
1275: --included in 'dat' because Begin Date was exactly 1 day greater than the End Date. In such a case,
1276: --instead of comparing dates of 'dat' with those of psp_schedule_lines, compare (Begin Date+1) and End
1277: --Date of 'dat' with those of psp_schedule_lines.
1278: --

Line 1307: INSERT INTO psp_matrix_driver(RUN_ID,

1303: END IF;
1304:
1305: END IF;
1306:
1307: INSERT INTO psp_matrix_driver(RUN_ID,
1308: SCHEDULE_LINE_ID,
1309: PERIOD_START_DATE,
1310: PERIOD_END_DATE,
1311: PERIOD_SCHEDULE_PERCENT) values

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

1352: OPEN sch_hier_cur;
1353: LOOP
1354: FETCH sch_hier_cur INTO l_schedule_hierarchy_id;
1355: EXIT WHEN sch_hier_cur%NOTFOUND;
1356: psp_matrix_driver_pkg.clear_table('REFRESH');
1357: psp_matrix_driver_pkg.purge_table;
1358: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
1359: IF (NOT psp_matrix_driver_pkg.check_exceedence(p_assignment_id)) THEN
1360: l_invalid_count := l_invalid_count + 1;

Line 1357: psp_matrix_driver_pkg.purge_table;

1353: LOOP
1354: FETCH sch_hier_cur INTO l_schedule_hierarchy_id;
1355: EXIT WHEN sch_hier_cur%NOTFOUND;
1356: psp_matrix_driver_pkg.clear_table('REFRESH');
1357: psp_matrix_driver_pkg.purge_table;
1358: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
1359: IF (NOT psp_matrix_driver_pkg.check_exceedence(p_assignment_id)) THEN
1360: l_invalid_count := l_invalid_count + 1;
1361: p_hierarchy_id :=l_schedule_hierarchy_id;

Line 1358: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);

1354: FETCH sch_hier_cur INTO l_schedule_hierarchy_id;
1355: EXIT WHEN sch_hier_cur%NOTFOUND;
1356: psp_matrix_driver_pkg.clear_table('REFRESH');
1357: psp_matrix_driver_pkg.purge_table;
1358: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
1359: IF (NOT psp_matrix_driver_pkg.check_exceedence(p_assignment_id)) THEN
1360: l_invalid_count := l_invalid_count + 1;
1361: p_hierarchy_id :=l_schedule_hierarchy_id;
1362: END IF;

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

1355: EXIT WHEN sch_hier_cur%NOTFOUND;
1356: psp_matrix_driver_pkg.clear_table('REFRESH');
1357: psp_matrix_driver_pkg.purge_table;
1358: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
1359: IF (NOT psp_matrix_driver_pkg.check_exceedence(p_assignment_id)) THEN
1360: l_invalid_count := l_invalid_count + 1;
1361: p_hierarchy_id :=l_schedule_hierarchy_id;
1362: END IF;
1363: END LOOP;

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

1361: p_hierarchy_id :=l_schedule_hierarchy_id;
1362: END IF;
1363: END LOOP;
1364: CLOSE sch_hier_cur;
1365: psp_matrix_driver_pkg.clear_table('REFRESH');
1366: psp_matrix_driver_pkg.purge_table;
1367: p_invalid_count := l_invalid_count;
1368: END check_sch_hierarchy;
1369:

Line 1366: psp_matrix_driver_pkg.purge_table;

1362: END IF;
1363: END LOOP;
1364: CLOSE sch_hier_cur;
1365: psp_matrix_driver_pkg.clear_table('REFRESH');
1366: psp_matrix_driver_pkg.purge_table;
1367: p_invalid_count := l_invalid_count;
1368: END check_sch_hierarchy;
1369:
1370: /* End of code for Bug no 2836176 By tbalacha*/

Line 1373: end psp_matrix_driver_pkg;

1369:
1370: /* End of code for Bug no 2836176 By tbalacha*/
1371:
1372:
1373: end psp_matrix_driver_pkg;