PACKAGE: APPS.BOM_CSTRISLR_XMLP_PKG

Source

1 PACKAGE BOM_CSTRISLR_XMLP_PKG AS
2 /* $Header: CSTRISLRS.pls 120.0 2007/12/24 10:02:30 dwkrishn noship $ */
3   P_CONC_REQUEST_ID VARCHAR2(32767) := '0';
4 
5   P_ORG_ID VARCHAR2(40);
6 
7   P_CURRENCY_CODE VARCHAR2(15);
8 
9   P_EXCHANGE_RATE NUMBER := 1;
10 
11   P_ITEM_FROM VARCHAR2(800);
12 
13   P_ITEM_TO VARCHAR2(800);
14 
15   LP_QTY_PRECISION varchar2(20);
16 
17   P_CATEGORY_SET NUMBER;
18 
19   P_CAT_NUM NUMBER;
20 
21   P_CAT_FROM VARCHAR2(800);
22 
23   P_CAT_TO VARCHAR2(800);
24 
25   P_ORGANIZATION VARCHAR2(240);
26 
27   ROUND_UNIT NUMBER := 1;
28 
29   P_ITEM_SEG VARCHAR2(2400);
30 
31   P_CAT_SEG VARCHAR2(2400);
32 
33   P_ITEM_WHERE VARCHAR2(2400);
34 
35   P_CAT_WHERE VARCHAR2(2400);
36 
37   P_CAT_SET_NAME VARCHAR2(40);
38 
39   P_EXT_PREC NUMBER := 5;
40 
41   P_QTY_PRECISION NUMBER;
42 
43   P_CURRENCY_DSP VARCHAR2(50);
44 
45   P_VIEW_COST NUMBER;
46 
47   P_TRACE VARCHAR2(1);
48 
49   P_COST_GROUP VARCHAR2(10);
50 
51   P_COST_GROUP_ID NUMBER;
52 
53   P_SUBINV_FROM VARCHAR2(40);
54 
55   P_SUBINV_TO VARCHAR2(40);
56 
57   P_ACCT_SEG1 NUMBER;
58 
59   P_ITEM_REVISION NUMBER;
60 
61   P_EXP_ITEM NUMBER;
62 
63   P_NEG_QTY NUMBER;
64 
65   P_ZERO_QTY NUMBER;
66 
67   P_INVERSE_RATE VARCHAR2(32767);
68 
69   P_RATE_TYPE NUMBER;
70 
71   P_LOC_SEG VARCHAR2(2400);
72 
73   P_EXCHANGE_RATE_CHAR VARCHAR2(38);
74 
75   FUNCTION AFTERREPORT RETURN BOOLEAN;
76 
77   FUNCTION BEFOREREPORT RETURN BOOLEAN;
78 
79   FUNCTION AC_ITEM_PSEGFORMULA(AC_ITEM IN VARCHAR2
80                               ,AC_ITEM_SEGMENT IN VARCHAR2
81                               ,AC_ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
82 
83   FUNCTION AC_CAT_PSEGFORMULA(AC_CATEGORY IN VARCHAR2
84                              ,AC_CATEGORY_SEGMENT IN VARCHAR2
85                              ,AC_CAT_PSEG IN VARCHAR2) RETURN VARCHAR2;
86 
87   FUNCTION AC_LOC_PSEGFORMULA(AC_LOC IN VARCHAR2
88                              ,AC_LOC_SEGMENT IN VARCHAR2
89                              ,AC_LOC_PSEG IN VARCHAR2) RETURN VARCHAR2;
90 
91   FUNCTION AC_I_ROWCOUNTFORMULA(AC_I_QUANTITY IN NUMBER) RETURN NUMBER;
92 
93 END BOM_CSTRISLR_XMLP_PKG;
94