PACKAGE: APPS.ENG_ENGRCNDR_XMLP_PKG

Source

1 PACKAGE ENG_ENGRCNDR_XMLP_PKG  AUTHID CURRENT_USER AS
2 /* $Header: ENGRCNDRS.pls 120.3 2008/04/08 08:34:39 dwkrishn noship $ */
3   P_ORG_ID VARCHAR2(40);
4 
5   P_FROM_NOTICE VARCHAR2(10);
6 
7   P_TO_NOTICE VARCHAR2(10);
8 
9   P_CONC_REQUEST_ID NUMBER := 0;
10 
11   P_RI_FLEXDATA VARCHAR2(850);
12 
13   P_RI_STRUCT_NUM VARCHAR2(15);
14 
15   P_UUI_FLEXDATA VARCHAR2(850);
16 
17   P_UUI_STRUCT_NUM VARCHAR2(15);
18 
19   P_RC_FLEXDATA VARCHAR2(850);
20 
21   P_RC_STRUCT_NUM VARCHAR2(15);
22 
23   P_SL_FLEXDATA VARCHAR2(850);
24 
25   P_SL_STRUCT_NUM VARCHAR2(15);
26 
27   P_SC_FLEXDATA VARCHAR2(850);
28 
29   P_SC_STRUCT_NUM VARCHAR2(15);
30 
31   P_STATUS NUMBER;
32 
33   C_LIMIT_CHANGE_NOTICES VARCHAR2(40);
34 
35   P_FROM_DATE DATE;
36 
37   P_TO_DATE DATE;
38 
39   CP_FROM_DATE varchar2(20);
40 
41   CP_TO_DATE varchar2(20);
42 
43   C_DATE_RANGE VARCHAR2(50);
44 
45   P_QTY_PRECISION NUMBER;
46 
47   P_STATUS_CHAR VARCHAR2(80);
48 
49   P_YES VARCHAR2(4);
50 
51   P_NO VARCHAR2(4);
52 
53   P_ADDITIONAL_DETAIL NUMBER;
54 
55   P_ORDER_ENTRY_DETAIL NUMBER;
56 
57   P_ADDITIONAL_CODE VARCHAR2(4);
58 
59   P_ORDER_ENTRY_CODE VARCHAR2(4);
60 
61   P_DEBUG VARCHAR2(2);
62 
63   P_ORG_HIERARCHY VARCHAR2(30);
64 
65   P_ALL_ORGS VARCHAR2(32767) := '2';
66 
67   DP_ALL_ORGS VARCHAR2(32767);
68 
69   P_SEQUENCE_ID NUMBER;
70 
71   P_YEP VARCHAR2(10);
72 
73   P_NOPE VARCHAR2(10);
74 
75   FUNCTION BEFOREREPORT RETURN BOOLEAN;
76 
77   FUNCTION AFTERREPORT RETURN BOOLEAN;
78 
79   FUNCTION GET_REV(REVISED_ITEM_ID IN NUMBER) RETURN VARCHAR2;
80 
81   FUNCTION LATEST_REV(REVISED_ITEM_ID IN NUMBER) RETURN VARCHAR2;
82 
83   FUNCTION LIMIT_CHANGE_NOTICES RETURN CHARACTER;
84 
85   FUNCTION OPTIONAL_DISPFORMULA(OPTIONAL IN NUMBER) RETURN VARCHAR2;
86 
87   FUNCTION COSTED_DISPFORMULA(COSTED IN NUMBER) RETURN VARCHAR2;
88 
89   FUNCTION CHECK_ATP_DISPFORMULA(CHECK_ATP IN NUMBER) RETURN VARCHAR2;
90 
91   FUNCTION MUTUALLY_EXCLUSIVE_DISPFORMULA(MUTUALLY_EXCLUSIVE_OPTION IN NUMBER) RETURN VARCHAR2;
92 
93   FUNCTION REQUIRED_TO_SHIP_DISPFORMULA(REQUIRED_TO_SHIP IN NUMBER) RETURN VARCHAR2;
94 
95   FUNCTION REQUIRED_FOR_REVENUE_DISPFORMU(REQUIRED_FOR_REVENUE IN NUMBER) RETURN VARCHAR2;
96 
97   FUNCTION INCLUDE_ON_SHIP_DISPFORMULA(INCLUDE_ON_SHIPPING_DOCUM IN NUMBER) RETURN VARCHAR2;
98 
99   FUNCTION QUANTITY_RELATED_DISPFORMULA(QUANTITY_RELATED IN NUMBER) RETURN VARCHAR2;
100 
101   FUNCTION GET_NAME(EMPLOYEE_ID IN NUMBER
102                    ,ORGANIZATION_ID IN NUMBER) RETURN VARCHAR2;
103 
104   FUNCTION GET_REQ_NAME(REQUESTOR_ID IN NUMBER) RETURN VARCHAR2;
105 
106   FUNCTION GET_ITEM_TYPE(ITEM_TYPE IN VARCHAR2) RETURN VARCHAR2;
107 
108   FUNCTION AFTERPFORM RETURN BOOLEAN;
109 
110   FUNCTION BETWEENPAGE RETURN BOOLEAN;
111 
112   FUNCTION BEFOREPFORM RETURN BOOLEAN;
113 
114 END ENG_ENGRCNDR_XMLP_PKG;
115