PACKAGE: APPS.BOM_CSTRLIVR_XMLP_PKG

Source

1 PACKAGE BOM_CSTRLIVR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: CSTRLIVRS.pls 120.0 2007/12/24 10:06:45 dwkrishn noship $ */
3   P_ORG_ID NUMBER;
4 
5   P_COST_GROUP_OPTION_ID NUMBER;
6 
7   P_COST_GROUP_ID NUMBER;
8 
9   P_SORT_OPTION NUMBER;
10 
11   P_ITEM_FROM VARCHAR2(800);
12 
13   P_ITEM_TO VARCHAR2(800);
14 
15   P_CATEGORY_SET NUMBER;
16 
17   P_CAT_NUM NUMBER;
18 
19   P_CAT_FROM VARCHAR2(800);
20 
21   P_CAT_TO VARCHAR2(800);
22 
23   P_CURRENCY_CODE VARCHAR2(15);
24 
25   P_EXCHANGE_RATE_CHAR NUMBER;
26 
27   P_QTY_PRECISION NUMBER;
28 
29   P_TRACE VARCHAR2(1);
30 
31   PV_ORGANIZATION_NAME VARCHAR2(240);
32 
33   PV_SORT_OPTION VARCHAR2(80);
34 
35   PV_CATEGORY_SET_NAME VARCHAR2(30);
36 
37   PV_CURRENCY_CODE VARCHAR2(50);
38 
39   PV_EXCHANGE_RATE NUMBER := 1;
40 
41   PV_COST_GROUP_OPTION VARCHAR2(80);
42 
43   PV_SPECIFIC_COST_GROUP VARCHAR2(32767);
44 
45   P_CONC_REQUEST_ID NUMBER := 0;
46 
47   P_CAT_SEG VARCHAR2(2400);
48 
49   P_CAT_WHERE VARCHAR2(2400);
50 
51   P_ITEM_SEG VARCHAR2(2400);
52 
53   P_ITEM_WHERE VARCHAR2(2400);
54 
55   PV_ROUND_UNIT NUMBER;
56 
57   P_ORD_ID VARCHAR2(40);
58 
59   P_ZERO_COST_LAYERS NUMBER;
60 
61   PV_REPORT_OPTION VARCHAR2(80);
62 
63   P_RPT_OPTION NUMBER;
64 
65   P_VIEW_COST NUMBER;
66 
67   P_ZERO_COST_WHERE VARCHAR2(2400) := '1=1';
68 
69   P_ZERO_QTY_WHERE VARCHAR2(2400) := '1=1';
70 
71   P_ZERO_QTY_LAYERS NUMBER;
72 
73   PV_ZERO_COST_LAYER VARCHAR2(32767);
74 
75   PV_ZERO_QTY_LAYER VARCHAR2(32767);
76 
77   P_EXT_PREC NUMBER;
78 
79   FUNCTION CF_ORDERFORMULA(CATEGORY IN VARCHAR2) RETURN CHAR;
80 
81   FUNCTION BEFOREREPORT RETURN BOOLEAN;
82 
83   FUNCTION AFTERREPORT RETURN BOOLEAN;
84 
85   FUNCTION BEFOREPFORM RETURN BOOLEAN;
86 
87   FUNCTION AFTERPFORM RETURN BOOLEAN;
88 
89   FUNCTION BETWEENPAGE RETURN BOOLEAN;
90 
91   FUNCTION P_ITEM_WHEREVALIDTRIGGER RETURN BOOLEAN;
92 
93 END BOM_CSTRLIVR_XMLP_PKG;
94