PACKAGE: APPS.BOM_CSTRTVHA_XMLP_PKG

Source

1 PACKAGE BOM_CSTRTVHA_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: CSTRTVHAS.pls 120.0 2007/12/24 10:19:18 dwkrishn noship $ */
3   P_HIST_DATE VARCHAR2(40);
4 
5   P_ORG_ID NUMBER;
6 
7   P_COST_GROUP_OPTION_ID NUMBER;
8 
9   P_SORT_OPTION NUMBER;
10 
11   P_CAT_SET_ID NUMBER;
12 
13   P_CAT_STRUCT_NUM VARCHAR2(15);
14 
15   P_CAT_LO VARCHAR2(900);
16 
17   P_CAT_HI VARCHAR2(900);
18 
19   P_CONC_REQUEST_ID NUMBER := 0;
20 
21   P_ITEM_LO VARCHAR2(900);
22 
23   P_ITEM_HI VARCHAR2(900);
24 
25   P_STYPE1 NUMBER;
26 
27   P_STYPE2 NUMBER;
28 
29   P_STYPE3 NUMBER;
30 
31   P_STYPE4 NUMBER;
32 
33   P_CAT_SEG VARCHAR2(800);
34 
35   P_ITEM_SEG VARCHAR2(800);
36 
37   PV_STYPE1 VARCHAR2(30);
38 
39   PV_STYPE2 VARCHAR2(30);
40 
41   PV_STYPE3 VARCHAR2(30);
42 
43   PV_STYPE4 VARCHAR2(30);
44 
45   PV_ORGANIZATION_NAME VARCHAR2(240);
46 
47   PV_SORT_OPTION VARCHAR2(80);
48 
49   PV_CATEGORY_SET_NAME VARCHAR2(30);
50 
51   PV_HIST_DATE DATE;
52 
53   PV_CURRENCY_CODE VARCHAR2(15);
54 
55   P_ITEM_WHERE VARCHAR2(2400);
56 
57   P_CAT_WHERE VARCHAR2(2400);
58 
59   PV_STD_PREC NUMBER;
60 
61   P_MAIN_QUERY VARCHAR2(1000);
62 
63   P_INTRANSIT NUMBER;
64 
65   P_CG VARCHAR2(10);
66 
67   P_TITLE VARCHAR2(240);
68 
69   FUNCTION BEFOREREPORT RETURN BOOLEAN;
70 
71   FUNCTION CF_ORDERFORMULA(CATEGORY IN VARCHAR2) RETURN CHAR;
72 
73   FUNCTION AFTERREPORT RETURN BOOLEAN;
74 
75   FUNCTION CF_1FORMULA(NEWVAL IN NUMBER
76                       ,OLDVAL IN NUMBER
77                       ,S1VAL IN NUMBER
78                       ,S2VAL IN NUMBER
79                       ,S3VAL IN NUMBER
80                       ,S4VAL IN NUMBER) RETURN NUMBER;
81 
82 END BOM_CSTRTVHA_XMLP_PKG;
83 
84