1 PACKAGE BOM_BOMRWUIT_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: BOMRWUITS.pls 120.1 2008/01/07 07:11:30 nchinnam noship $ */
3 P_ORG_ID NUMBER;
4 LP_ORG_ID NUMBER;
5
6 P_REPORT_OPTION NUMBER;
7
8 P_ITEM_FROM VARCHAR2(80);
9
10 P_ITEM_TO VARCHAR2(80);
11
12 P_SET_ID NUMBER;
13
14 P_CAT_FROM VARCHAR2(80);
15
16 P_CAT_TO VARCHAR2(80);
17
18 P_IMPLEMENTED NUMBER;
19
20 P_DATE VARCHAR2(32767);
21
22 P_DATE_1 VARCHAR2(32767);
23
24 P_DATE_OPTION NUMBER;
25
26 P_LEVEL NUMBER;
27
28 P_ITEM_ID NUMBER;
29
30 P_ITEM_REV VARCHAR2(3);
31
32 P_ENG_BILL_FLAG VARCHAR2(3);
33
34 P_CATEGORY_STRUCTURE_ID NUMBER;
35
36 P_ITEM_STRUCTURE_ID NUMBER;
37
38 P_ASS_BETWEEN VARCHAR2(480);
39
40 P_CAT_BETWEEN VARCHAR2(480);
41
42 P_CONC_REQUEST_ID NUMBER := 0;
43
44 P_SEQUENCE_ID NUMBER := 9999;
45
46 P_SPECIFIC_ITEM VARCHAR2(245);
47
48 P_DEBUG VARCHAR2(2);
49
50 P_QTY_PRECISION NUMBER;
51
52 P_MSG_BUF VARCHAR2(80);
53
54 P_ERR_MSG VARCHAR2(80);
55
56 P_ALL_ORGS NUMBER;
57
58 P_ORG_HIERARCHY VARCHAR2(30);
59
60 LP_QTY_PRECISION VARCHAR2(30);
61
62 FUNCTION BEFOREREPORT RETURN BOOLEAN;
63
64 FUNCTION AFTERREPORT RETURN BOOLEAN;
65
66 FUNCTION GET_STATUS(REVISED_ITEM_SEQUENCE_ID IN NUMBER
67 ,IMPLEMENTED_FLAG IN NUMBER
68 ,NOTICE IN VARCHAR2) RETURN VARCHAR2;
69
70 FUNCTION GET_ORGCODE(ORGANIZATION_ID IN NUMBER) RETURN VARCHAR2;
71
72 FUNCTION CF_ALL_ORGSFORMULA RETURN CHAR;
73
74 function get_precision(qty_precision in number) return VARCHAR2;
75
76 PROCEDURE IMPLODER_USEREXIT(SEQUENCE_ID IN NUMBER
77 ,ENG_MFG_FLAG IN NUMBER
78 ,ORG_ID IN NUMBER
79 ,IMPL_FLAG IN NUMBER
80 ,DISPLAY_OPTION IN NUMBER
81 ,LEVELS_TO_IMPLODE IN NUMBER
82 ,ITEM_ID IN NUMBER
83 ,IMPL_DATE IN VARCHAR2
84 ,ERR_MSG OUT NOCOPY VARCHAR2
85 ,ERR_CODE OUT NOCOPY NUMBER);
86
87 PROCEDURE IMPLOSION(SEQUENCE_ID IN NUMBER
88 ,ENG_MFG_FLAG IN NUMBER
89 ,ORG_ID IN NUMBER
90 ,IMPL_FLAG IN NUMBER
91 ,DISPLAY_OPTION IN NUMBER
92 ,LEVELS_TO_IMPLODE IN NUMBER
93 ,IMPL_DATE IN VARCHAR2
94 ,ERR_MSG OUT NOCOPY VARCHAR2
95 ,ERR_CODE OUT NOCOPY NUMBER);
96
97 PROCEDURE SL_IMPLODER(SEQUENCE_ID IN NUMBER
98 ,ENG_MFG_FLAG IN NUMBER
99 ,ORG_ID IN NUMBER
100 ,IMPL_FLAG IN NUMBER
101 ,DISPLAY_OPTION IN NUMBER
102 ,IMPL_DATE IN VARCHAR2
103 ,ERR_MSG OUT NOCOPY VARCHAR2
104 ,ERROR_CODE OUT NOCOPY NUMBER);
105
106 PROCEDURE ML_IMPLODER(SEQUENCE_ID IN NUMBER
107 ,ENG_MFG_FLAG IN NUMBER
108 ,ORG_ID IN NUMBER
109 ,IMPL_FLAG IN NUMBER
110 ,A_LEVELS_TO_IMPLODE IN NUMBER
111 ,IMPL_DATE IN VARCHAR2
112 ,ERR_MSG OUT NOCOPY VARCHAR2
113 ,ERROR_CODE OUT NOCOPY NUMBER);
114
115 END BOM_BOMRWUIT_XMLP_PKG;
116