PACKAGE: APPS.PO_RCOTOLERANCE_PVT

Source

1 PACKAGE PO_RCOTOLERANCE_PVT AUTHID CURRENT_USER AS
2 /* $Header: POXVRTWS.pls 120.2.12010000.6 2008/11/25 08:21:47 rojain ship $*/
3 -- Indexes for tolerance values
4 
5   TOL_REQTOTAL_IND  CONSTANT NUMBER := 1;
6 
7   TOL_REQTOTAL_AMT_IND  CONSTANT NUMBER := 2;
8 
9   TOL_UNITPRICE_IND  CONSTANT NUMBER := 3;
10 
11   TOL_LINEQTY_IND  CONSTANT NUMBER := 4;
12 
13   TOL_LINEAMT_IND  CONSTANT NUMBER := 5;
14 
15   TOL_LINEAMT_AMT_IND  CONSTANT NUMBER := 6;
16 
17   TOL_STARTDATE_IND  CONSTANT NUMBER := 7;
18 
19   TOL_ENDDATE_IND  CONSTANT NUMBER := 8;
20 
21   TOL_NEEDBY_IND  CONSTANT NUMBER := 9;
22 
23   FUNCTION GET_NEW_DISTRIBUTION_QTY(P_REQ_ID  IN NUMBER,P_GRP_ID  IN NUMBER,P_REQ_LINE_ID  IN NUMBER,P_REQ_DIST_ID  IN NUMBER) RETURN NUMBER;
24 
25   FUNCTION GET_NEW_LINE_QUANTITY(P_REQ_ID  IN NUMBER,P_REQ_LINE_ID  IN NUMBER,P_GRP_ID  IN NUMBER) RETURN NUMBER;
26 
27   FUNCTION CHANGE_WITHIN_TOL_DATE(P_OLDVALUE  IN DATE,P_NEWVALUE  IN DATE,P_MAXINCREMENT  IN NUMBER,P_MAXDECREMENT  IN NUMBER) RETURN VARCHAR2;
28 
29   FUNCTION CHANGE_WITHIN_TOL_PERCENT(P_OLDVALUE  IN NUMBER,P_NEWVALUE  IN NUMBER,P_MAXINCREMENT  IN NUMBER,P_MAXDECREMENT  IN NUMBER) RETURN VARCHAR2;
30 
31   FUNCTION CHANGE_WITHIN_TOL_AMOUNT(P_OLDVALUE  IN NUMBER,P_NEWVALUE  IN NUMBER,P_MAXINCREMENT  IN NUMBER,P_MAXDECREMENT  IN NUMBER) RETURN VARCHAR2;
32 
33   FUNCTION CHANGES_WITHIN_TOL(P_OLDVALUE  IN NUMBER,P_NEWVALUE  IN NUMBER,P_MAXINCREMENT  IN NUMBER,P_MAXDECREMENT  IN NUMBER,P_MAXINCREMENTAMOUNT  IN NUMBER,P_MAXDECREMENTAMOUNT  IN NUMBER) RETURN VARCHAR2;
34 
35   PROCEDURE SET_APPROVAL_REQUIRED_FLAG(P_CHREQGRP_ID  IN NUMBER,X_APPR_STATUS  OUT NOCOPY VARCHAR2,P_SOURCE_TYPE_CODE  IN VARCHAR2 DEFAULT NULL);
36 END PO_RCOTOLERANCE_PVT;