[Home] [Help]
PACKAGE: APPS.MST_AUDIT_REP_EXCP
Source
1 PACKAGE MST_AUDIT_REP_EXCP AUTHID CURRENT_USER AS
2 /* $Header: MSTEARES.pls 115.10 2004/05/05 21:40:00 jansanch noship $ */
3
4 PROCEDURE MissingLatLongCoordExcptn (plan_idIn NUMBER, userIdIn NUMBER);
5 PROCEDURE MissingDistanceDataExcptn (plan_idIn NUMBER, userIdIn NUMBER);
6 PROCEDURE DL_with_zero_values (plan_idIn NUMBER, userIdIn NUMBER);
7 PROCEDURE DimensionViolForPieceExcptn (plan_idIn NUMBER, userIdIn NUMBER);
8 PROCEDURE WgtVolViolForPieceExcptn (plan_idIn NUMBER, userIdIn NUMBER);
9 PROCEDURE WgtVolViolForDLExcptn (plan_idIn NUMBER, userIdIn NUMBER);
10 PROCEDURE WgtVolViolForFirmDelivExcptn (plan_idIn NUMBER, userIdIn NUMBER);
11 PROCEDURE InsufficientIntransitTimeExptn (plan_idIn NUMBER, userIdIn NUMBER);
12 PROCEDURE PastDueOrdersExptn (plan_idIn NUMBER, userIdIn NUMBER);
13
14 PROCEDURE FacCalViolForPickUpExptn (plan_idIn NUMBER, userIdIn NUMBER);
15 PROCEDURE FacCalViolForDeliveryExptn (plan_idIn NUMBER, userIdIn NUMBER);
16
17 PROCEDURE runAuditReport(errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY NUMBER, plan_idIn IN NUMBER, snapshotIsCaller IN NUMBER DEFAULT 2);
18 FUNCTION getExceptionThreshold (exceptionType NUMBER, userIdIn NUMBER) RETURN NUMBER;
19 PROCEDURE initializeGlobalVariables(plan_idIn IN NUMBER, user_idIn IN NUMBER);
20
21 PROCEDURE testConv (source varchar2, dest varchar2);
22 PROCEDURE GET_UOM_CONVERSION_RATES(p_uom_code IN VARCHAR2,p_dest_uom_code IN VARCHAR2,p_inventory_item_id IN NUMBER DEFAULT 0,p_conv_found OUT NOCOPY BOOLEAN,p_conv_rate OUT NOCOPY NUMBER);
23 FUNCTION GET_MINIMUM_TRANSIT_TIME(ship_from NUMBER, ship_to NUMBER, plan_idIn NUMBER) RETURN NUMBER;
24 FUNCTION CONV_TO_UOM(src_value NUMBER, src_uom_code VARCHAR2, dest_uom_code VARCHAR2, inventory_item_id NUMBER DEFAULT 0) RETURN NUMBER;
25
26
27 PROCEDURE debug_output(p_str in varchar2);
28 END MST_AUDIT_REP_EXCP;