DBA Data[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;