PACKAGE: APPS.BOM_BOMRASSY_XMLP_PKG

Source

1 PACKAGE BOM_BOMRASSY_XMLP_PKG AS
2 /* $Header: BOMRASSYS.pls 120.0 2007/12/28 09:44:30 dwkrishn noship $ */
3   P_ASSEMBLY VARCHAR2(650);
4 
5   P_STRUCT_ASSY VARCHAR2(15);
6 
7   P_COMMON VARCHAR2(650);
8 
9   P_STRUCT_COMMON VARCHAR2(15);
10 
11   P_ORG_ID VARCHAR2(40);
12 
13   P_BOM_OR_ENG VARCHAR2(3);
14 
15   P_ASSY_WHERE VARCHAR2(480);
16 
17   P_ITEM_FROM VARCHAR2(240);
18 
19   P_ITEM_TO VARCHAR2(40);
20 
21   P_CATG_WHERE VARCHAR2(480);
22 
23   P_CATG_SET_ID NUMBER;
24 
25   P_CATG_FROM VARCHAR2(240);
26 
27   P_CATG_TO VARCHAR2(240);
28 
29   P_STRUCT_CATG VARCHAR2(15);
30 
31   P_CONC_REQUEST_ID NUMBER := 0;
32 
33   P_ASSY_ORDER VARCHAR2(200);
34 
35   P_CATEGORY VARCHAR2(650);
36 
37   P_ALT_OPTION NUMBER;
38 
39   P_ALTERNATE VARCHAR2(10);
40 
41   P_COMMON_ORG NUMBER;
42 
43   P_COMMON_ITEM_ID NUMBER;
44 
45   P_DEBUG VARCHAR2(2);
46 
47   P_ALL_ORGS VARCHAR2(3);
48 
49   P_ORG_HIERARCHY VARCHAR2(30);
50 
51   P_SEQUENCE_ID NUMBER;
52 
53   P_ORG_CODE VARCHAR2(40);
54 
55   FUNCTION BEFOREREPORT RETURN BOOLEAN;
56 
57   FUNCTION AFTERREPORT RETURN BOOLEAN;
58 
59   FUNCTION GET_COMMON_ORG(COMMON_ORGANIZATION_ID IN NUMBER) RETURN VARCHAR2;
60 
61   FUNCTION ORG_CODEFORMULA(ORG_ID IN NUMBER) RETURN CHAR;
62 
63 END BOM_BOMRASSY_XMLP_PKG;
64