DBA Data[Home] [Help]

PACKAGE: APPS.ENG_ENGRCNSR_XMLP_PKG

Source


1 PACKAGE ENG_ENGRCNSR_XMLP_PKG AS
2 /* $Header: ENGRCNSRS.pls 120.1 2008/01/08 12:39:02 dwkrishn noship $ */
3   ORG_ID NUMBER;
4 
5   PRINT_COMPONENTS NUMBER;
6 
7   ECN_FROM VARCHAR2(10);
8 
9   ECN_TO VARCHAR2(10);
10 
11   DATE_FROM DATE;
12 
13   DATE_TO DATE;
14 
15   C_DATE_FROM varchar2(20);
16 
17   C_DATE_TO varchar2(20);
18 
19   REVISED_ITEM_STATUS NUMBER;
20 
21   HISTORY_CODE NUMBER;
22 
23   CHANGE_ORDER_TYPE_ID NUMBER;
24 
25   ORDER_BY1 NUMBER;
26 
27   ORDER_BY2 NUMBER;
28 
29   ORDER_BY3 NUMBER;
30 
31   P_REVISED_ITEM_ID NUMBER;
32 
33   P_REVISED_COMPONENT_ITEM_ID NUMBER;
34 
35   P_DELETE_CODE NUMBER;
36 
37   P_QTY_PRECISION NUMBER;
38 
39   P_DEBUG VARCHAR2(2);
40 
41   P_YES VARCHAR2(10);
42 
43   P_NO VARCHAR2(10);
44 
45   FUNCTION AFTERREPORT RETURN BOOLEAN;
46 
47   FUNCTION BEFOREREPORT RETURN BOOLEAN;
48 
49   FUNCTION ONHAND_QTYFORMULA(COMPONENT_ITEM_ID IN NUMBER) RETURN NUMBER;
50 
51   FUNCTION BETWEENPAGE RETURN BOOLEAN;
52 
53   FUNCTION BEFOREPFORM RETURN BOOLEAN;
54 
55   FUNCTION AFTERPFORM RETURN BOOLEAN;
56 
57   PROCEDURE BOM_DELETE_ECO(P_CHANGE_NOTICE IN VARCHAR2
58                           ,P_ORGANIZATION_ID IN NUMBER);
59 
60 END ENG_ENGRCNSR_XMLP_PKG;
61