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.MRP_MRPRPROP_XMLP_PKG dependencies on MRP_CALENDAR

Line 798: /*STPROC.INIT('begin :X0 := MRP_CALENDAR.NEXT_WORK_DAY(:ARG_ORG_ID, :ARG_BUCKET, :ARG_DATE); end;');

794: ,ARG_BUCKET IN NUMBER
795: ,ARG_DATE IN DATE) RETURN DATE IS
796: X0 DATE;
797: BEGIN
798: /*STPROC.INIT('begin :X0 := MRP_CALENDAR.NEXT_WORK_DAY(:ARG_ORG_ID, :ARG_BUCKET, :ARG_DATE); end;');
799: STPROC.BIND_O(X0);
800: STPROC.BIND_I(ARG_ORG_ID);
801: STPROC.BIND_I(ARG_BUCKET);
802: STPROC.BIND_I(ARG_DATE);

Line 806: X0 := MRP_CALENDAR.NEXT_WORK_DAY(ARG_ORG_ID, ARG_BUCKET, ARG_DATE);

802: STPROC.BIND_I(ARG_DATE);
803: STPROC.EXECUTE;
804: STPROC.RETRIEVE(1
805: ,X0);*/
806: X0 := MRP_CALENDAR.NEXT_WORK_DAY(ARG_ORG_ID, ARG_BUCKET, ARG_DATE);
807: RETURN X0;
808: END NEXT_WORK_DAY;
809:
810: FUNCTION PREV_WORK_DAY(ARG_ORG_ID IN NUMBER

Line 815: /* STPROC.INIT('begin :X0 := MRP_CALENDAR.PREV_WORK_DAY(:ARG_ORG_ID, :ARG_BUCKET, :ARG_DATE); end;');

811: ,ARG_BUCKET IN NUMBER
812: ,ARG_DATE IN DATE) RETURN DATE IS
813: X0 DATE;
814: BEGIN
815: /* STPROC.INIT('begin :X0 := MRP_CALENDAR.PREV_WORK_DAY(:ARG_ORG_ID, :ARG_BUCKET, :ARG_DATE); end;');
816: STPROC.BIND_O(X0);
817: STPROC.BIND_I(ARG_ORG_ID);
818: STPROC.BIND_I(ARG_BUCKET);
819: STPROC.BIND_I(ARG_DATE);

Line 823: X0 := MRP_CALENDAR.PREV_WORK_DAY(ARG_ORG_ID, ARG_BUCKET, ARG_DATE);

819: STPROC.BIND_I(ARG_DATE);
820: STPROC.EXECUTE;
821: STPROC.RETRIEVE(1
822: ,X0);*/
823: X0 := MRP_CALENDAR.PREV_WORK_DAY(ARG_ORG_ID, ARG_BUCKET, ARG_DATE);
824: RETURN X0;
825: END PREV_WORK_DAY;
826:
827: FUNCTION DATE_OFFSET(ARG_ORG_ID IN NUMBER

Line 833: /*STPROC.INIT('begin :X0 := MRP_CALENDAR.DATE_OFFSET(:ARG_ORG_ID, :ARG_BUCKET, :ARG_DATE, :ARG_OFFSET); end;');

829: ,ARG_DATE IN DATE
830: ,ARG_OFFSET IN NUMBER) RETURN DATE IS
831: X0 DATE;
832: BEGIN
833: /*STPROC.INIT('begin :X0 := MRP_CALENDAR.DATE_OFFSET(:ARG_ORG_ID, :ARG_BUCKET, :ARG_DATE, :ARG_OFFSET); end;');
834: STPROC.BIND_O(X0);
835: STPROC.BIND_I(ARG_ORG_ID);
836: STPROC.BIND_I(ARG_BUCKET);
837: STPROC.BIND_I(ARG_DATE);

Line 842: X0 := MRP_CALENDAR.DATE_OFFSET(ARG_ORG_ID, ARG_BUCKET, ARG_DATE, ARG_OFFSET);

838: STPROC.BIND_I(ARG_OFFSET);
839: STPROC.EXECUTE;
840: STPROC.RETRIEVE(1
841: ,X0);*/
842: X0 := MRP_CALENDAR.DATE_OFFSET(ARG_ORG_ID, ARG_BUCKET, ARG_DATE, ARG_OFFSET);
843: RETURN X0;
844: END DATE_OFFSET;
845:
846: FUNCTION DAYS_BETWEEN(ARG_ORG_ID IN NUMBER

Line 852: /*STPROC.INIT('begin :X0 := MRP_CALENDAR.DAYS_BETWEEN(:ARG_ORG_ID, :ARG_BUCKET, :ARG_DATE1, :ARG_DATE2); end;');

848: ,ARG_DATE1 IN DATE
849: ,ARG_DATE2 IN DATE) RETURN NUMBER IS
850: X0 NUMBER;
851: BEGIN
852: /*STPROC.INIT('begin :X0 := MRP_CALENDAR.DAYS_BETWEEN(:ARG_ORG_ID, :ARG_BUCKET, :ARG_DATE1, :ARG_DATE2); end;');
853: STPROC.BIND_O(X0);
854: STPROC.BIND_I(ARG_ORG_ID);
855: STPROC.BIND_I(ARG_BUCKET);
856: STPROC.BIND_I(ARG_DATE1);

Line 861: X0 := MRP_CALENDAR.DAYS_BETWEEN(ARG_ORG_ID, ARG_BUCKET, ARG_DATE1, ARG_DATE2);

857: STPROC.BIND_I(ARG_DATE2);
858: STPROC.EXECUTE;
859: STPROC.RETRIEVE(1
860: ,X0);*/
861: X0 := MRP_CALENDAR.DAYS_BETWEEN(ARG_ORG_ID, ARG_BUCKET, ARG_DATE1, ARG_DATE2);
862: RETURN X0;
863: END DAYS_BETWEEN;
864:
865: PROCEDURE SELECT_CALENDAR_DEFAULTS(ARG_ORG_ID IN NUMBER

Line 869: /*STPROC.INIT('begin MRP_CALENDAR.SELECT_CALENDAR_DEFAULTS(:ARG_ORG_ID, :ARG_CALENDAR_CODE, :ARG_EXCEPTION_SET_ID); end;');

865: PROCEDURE SELECT_CALENDAR_DEFAULTS(ARG_ORG_ID IN NUMBER
866: ,ARG_CALENDAR_CODE OUT NOCOPY VARCHAR2
867: ,ARG_EXCEPTION_SET_ID OUT NOCOPY NUMBER) IS
868: BEGIN
869: /*STPROC.INIT('begin MRP_CALENDAR.SELECT_CALENDAR_DEFAULTS(:ARG_ORG_ID, :ARG_CALENDAR_CODE, :ARG_EXCEPTION_SET_ID); end;');
870: STPROC.BIND_I(ARG_ORG_ID);
871: STPROC.BIND_O(ARG_CALENDAR_CODE);
872: STPROC.BIND_O(ARG_EXCEPTION_SET_ID);
873: STPROC.EXECUTE;

Line 878: MRP_CALENDAR.SELECT_CALENDAR_DEFAULTS(ARG_ORG_ID, ARG_CALENDAR_CODE, ARG_EXCEPTION_SET_ID);

874: STPROC.RETRIEVE(2
875: ,ARG_CALENDAR_CODE);
876: STPROC.RETRIEVE(3
877: ,ARG_EXCEPTION_SET_ID);*/
878: MRP_CALENDAR.SELECT_CALENDAR_DEFAULTS(ARG_ORG_ID, ARG_CALENDAR_CODE, ARG_EXCEPTION_SET_ID);
879: END SELECT_CALENDAR_DEFAULTS;
880:
881: PROCEDURE PUT(NAME IN VARCHAR2
882: ,VAL IN VARCHAR2) IS

Line 1089: MRP_CALENDAR.SELECT_CALENDAR_DEFAULTS(ORG_ID

1085: EXC_SET_ID NUMBER;
1086: START_SEQ_NUM NUMBER;
1087: END_SEQ_NUM NUMBER;
1088: BEGIN
1089: MRP_CALENDAR.SELECT_CALENDAR_DEFAULTS(ORG_ID
1090: ,CAL_CODE
1091: ,EXC_SET_ID);
1092: SELECT
1093: CAL1.NEXT_SEQ_NUM,

Line 1262: MRP_CALENDAR.SELECT_CALENDAR_DEFAULTS(ORG_ID

1258: L_ROUND NUMBER;
1259: C_PROCESS_ENABLED VARCHAR2(5);
1260: BEGIN
1261: IF (TOT_AVAIL < REORDER_POINT) THEN
1262: MRP_CALENDAR.SELECT_CALENDAR_DEFAULTS(ORG_ID
1263: ,CAL_CODE
1264: ,EXC_SET_ID);
1265: MAX_PT := REORDER_POINT - TOT_AVAIL;
1266: SELECT

Line 1388: MRP_CALENDAR.SELECT_CALENDAR_DEFAULTS(ORG_ID

1384: END_DATE DATE;
1385: CAL_CODE VARCHAR2(20);
1386: EXC_SET_ID NUMBER;
1387: BEGIN
1388: MRP_CALENDAR.SELECT_CALENDAR_DEFAULTS(ORG_ID
1389: ,CAL_CODE
1390: ,EXC_SET_ID);
1391: BEGIN
1392: SELECT

Line 1764: AND TRUNC(DECODE(NVL(items.postprocessing_lead_time,0),0,MRP_CALENDAR.NEXT_WORK_DAY(items.organization_id,1,

1760: AND sup.to_organization_id =' || TO_CHAR(ORG_ID) || '
1761: AND sup.item_id =' || TO_CHAR(CURRENT_ITEM_ID) || '
1762: AND items.organization_id = sup.to_organization_id' || '
1763: AND items.inventory_item_id = sup.item_id' || '
1764: AND TRUNC(DECODE(NVL(items.postprocessing_lead_time,0),0,MRP_CALENDAR.NEXT_WORK_DAY(items.organization_id,1,
1765: DECODE(sup.supply_type_code,''PO'',sup.need_by_date,
1766: ''REQ'',sup.need_by_date,
1767: ''ASN'',sup.need_by_date,''RECEIVING'',sup.receipt_date,''SHIPMENT'',
1768: sup.receipt_date)),' || ' MRP_CALENDAR.DATE_OFFSET(items.organization_id,1,DECODE(sup.supply_type_code,''PO'',sup.need_by_date,

Line 1768: sup.receipt_date)),' || ' MRP_CALENDAR.DATE_OFFSET(items.organization_id,1,DECODE(sup.supply_type_code,''PO'',sup.need_by_date,

1764: AND TRUNC(DECODE(NVL(items.postprocessing_lead_time,0),0,MRP_CALENDAR.NEXT_WORK_DAY(items.organization_id,1,
1765: DECODE(sup.supply_type_code,''PO'',sup.need_by_date,
1766: ''REQ'',sup.need_by_date,
1767: ''ASN'',sup.need_by_date,''RECEIVING'',sup.receipt_date,''SHIPMENT'',
1768: sup.receipt_date)),' || ' MRP_CALENDAR.DATE_OFFSET(items.organization_id,1,DECODE(sup.supply_type_code,''PO'',sup.need_by_date,
1769: ''REQ'',sup.need_by_date,''ASN'',sup.need_by_date,''RECEIVING'',sup.receipt_date,''SHIPMENT'',sup.receipt_date),
1770: items.postprocessing_lead_time))) <=
1771: TO_DATE(''' || SCD || ''',''DD-MON-RRRR'')' || ' AND (NVL(sup.FROM_organization_id,-1) <>' || TO_CHAR(ORG_ID) || '
1772: OR (sup.FROM_organization_id =' || TO_CHAR(ORG_ID) || ' AND ' || TO_CHAR(INCLUDE_NONNET) || '= 2' || ' AND EXISTS (SELECT ''x''