PACKAGE: APPS.BOM_CSTRSTSR_XMLP_PKG

Source

1 PACKAGE BOM_CSTRSTSR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: CSTRSTSRS.pls 120.0 2007/12/24 10:18:29 dwkrishn noship $ */
3   P_ORG_ID NUMBER;
4 
5   P_SORT_OPTION NUMBER;
6 
7   P_CATEGORY_SET NUMBER;
8 
9   P_CAT_NUM NUMBER;
10 
11   P_CURRENCY_CODE VARCHAR2(15);
12 
13   P_EXCHANGE_RATE_CHAR VARCHAR2(38);
14 
15   P_QTY_PRECISION NUMBER;
16 
17   P_TRACE VARCHAR2(1);
18 
19   PV_ORGANIZATION_NAME VARCHAR2(240);
20 
21   PV_SORT_OPTION VARCHAR2(80);
22 
23   PV_CATEGORY_SET_NAME VARCHAR2(30);
24 
25   PV_CURRENCY_CODE VARCHAR2(50);
26 
27   PV_EXCHANGE_RATE NUMBER := 1;
28 
29   P_CONC_REQUEST_ID NUMBER := 0;
30 
31   P_CAT_SEG VARCHAR2(2400);
32 
33   P_ITEM_SEG VARCHAR2(2400);
34 
35   PV_ROUND_UNIT NUMBER;
36 
37   P_DATE_FROM VARCHAR2(40);
38 
39   P_DATE_TO VARCHAR2(40);
40 
41   P_DATE_TO_1 VARCHAR2(40);
42 
43   P_VIEW_COST NUMBER;
44 
45   P_DATE_RANGE VARCHAR2(200);
46 
47   FUNCTION BEFOREREPORT RETURN BOOLEAN;
48 
49   FUNCTION AFTERREPORT RETURN BOOLEAN;
50 
51   FUNCTION ITEM_PSEGFORMULA(ITEM_NUMBER IN VARCHAR2
52                            ,ITEM_SEGMENT IN VARCHAR2
53                            ,ITEM_PSEG IN VARCHAR2) RETURN CHAR;
54 
55   FUNCTION CATEGORY_PSEGFORMULA(CATEGORY IN VARCHAR2
56                                ,CATEGORY_SEGMENT IN VARCHAR2
57                                ,CATEGORY_PSEG IN VARCHAR2) RETURN CHAR;
58 
59   FUNCTION C_ORDERFORMULA(ITEM_NUMBER IN VARCHAR2
60                          ,ITEM_SEGMENT IN VARCHAR2
61                          ,ITEM_PSEG IN VARCHAR2
62                          ,CATEGORY IN VARCHAR2
63                          ,CATEGORY_SEGMENT IN VARCHAR2
64                          ,CATEGORY_PSEG IN VARCHAR2) RETURN CHAR;
65 
66   FUNCTION AFTERPFORM RETURN BOOLEAN;
67 
68 END BOM_CSTRSTSR_XMLP_PKG;
69