1 PACKAGE BOM_CSTRINVR_XMLP_PKG AS
2 /* $Header: CSTRINVRS.pls 120.1 2008/01/06 05:42:00 nchinnam noship $ */
3 P_CONC_REQUEST_ID VARCHAR2(32767) := '0';
4 P_ORG_ID VARCHAR2(40);
5 P_CURRENCY_CODE VARCHAR2(15);
6 P_EXCHANGE_RATE NUMBER := 1;
7 P_SORT_OPTION NUMBER;
8 P_RPT_OPTION NUMBER;
9 P_ITEM_FROM VARCHAR2(800);
10 P_ITEM_TO VARCHAR2(800);
11 P_CATEGORY_SET NUMBER;
12 P_CAT_NUM NUMBER;
13 P_CAT_FROM VARCHAR2(800);
14 P_CAT_TO VARCHAR2(800);
15 P_SUBINV_FROM VARCHAR2(10);
16 P_SUBINV_TO VARCHAR2(10);
17 P_NEG_QTY NUMBER :=2;
18 P_ZERO_COST NUMBER :=2;
19 P_ORGANIZATION VARCHAR2(240);
20 ROUND_UNIT NUMBER;
21 P_ITEM_SEG VARCHAR2(2400):= 'MSI.description||MSI.segment1||MSI.description||MSI.segment2||MSI.description||MSI.segment3';
22 P_CAT_SEG VARCHAR2(2400) := 'MC.attribute1||MC.attribute2||MC.attribute3||MC.attribute4||MC.attribute5||MC.segment1||MC.segment2||MC.segment3';
23 P_ITEM_WHERE VARCHAR2(2400);
24 P_CAT_WHERE VARCHAR2(2400);
25 P_SORT_BY VARCHAR2(80);
26 P_CAT_SET_NAME VARCHAR2(40);
27 P_GL_NUM NUMBER;
28 P_DETAIL_LEVEL VARCHAR2(80);
29 P_COST_TYPE_ID NUMBER;
30 P_DEF_COST_TYPE NUMBER;
31 P_COST_TYPE VARCHAR2(10);
32 P_EXT_PREC NUMBER;
33 P_QTY_WHERE VARCHAR2(1440);
34 P_ZERO_QTY NUMBER;
35 P_ITEM_REVISION NUMBER;
36 P_EXP_ITEM NUMBER;
37 P_UNCOSTED_TXN NUMBER;
38 P_QTY_PRECISION NUMBER;
39 P_SESSIONID NUMBER;
40 P_CURRENCY_DSP VARCHAR2(50);
41 P_VIEW_COST NUMBER;
42 P_REPORT_NAME VARCHAR2(240);
43 P_TRACE VARCHAR2(1);
44 P_COST_ORG_ID NUMBER;
45 P_PRECISION NUMBER;
46 P_SUBINV_WHERE VARCHAR2(2400) := '1 = 1';
47 P_EXCHANGE_RATE_CHAR VARCHAR2(38);
48 P_SUB_INV_SEC VARCHAR2(2400) := '1 = 1';
49 P_SUB_INV_MMT VARCHAR2(2400);
50 P_SUB_INV_MOH VARCHAR2(2400);
51 P_EXP_SUB NUMBER;
52 P_AS_OF_DATE VARCHAR2(30);
53 P_AS_OF_DATE1 VARCHAR2(30);
54 P_TITLE VARCHAR2(240);
55 FUNCTION AFTERREPORT RETURN BOOLEAN;
56 FUNCTION BEFOREREPORT RETURN BOOLEAN;
57 FUNCTION IC_ROWCOUNTFORMULA(IC_QUANTITY IN NUMBER) RETURN NUMBER;
58 FUNCTION IC_TOTAL1FORMULA(IC_QUANTITY IN NUMBER
59 ,IC_TOTAL IN NUMBER) RETURN NUMBER;
60 FUNCTION SI_TOTAL1FORMULA(SI_QUANTITY IN NUMBER
61 ,SI_TOTAL IN NUMBER) RETURN NUMBER;
62 FUNCTION SI_ROWCOUNTFORMULA(SI_QUANTITY IN NUMBER) RETURN NUMBER;
63 FUNCTION SI_MATL1FORMULA(SI_QUANTITY IN NUMBER
64 ,SI_MATL IN NUMBER) RETURN NUMBER;
65 FUNCTION SI_MOVH1FORMULA(SI_QUANTITY IN NUMBER
66 ,SI_MOVH IN NUMBER) RETURN NUMBER;
67 FUNCTION SI_RES1FORMULA(SI_QUANTITY IN NUMBER
68 ,SI_RES IN NUMBER) RETURN NUMBER;
69 FUNCTION SI_OSP1FORMULA(SI_QUANTITY IN NUMBER
70 ,SI_OSP IN NUMBER) RETURN NUMBER;
71 FUNCTION SI_OVHD1FORMULA(SI_QUANTITY IN NUMBER
72 ,SI_OVHD IN NUMBER) RETURN NUMBER;
73 FUNCTION IC_ORDERFORMULA(IC_CATEGORY IN VARCHAR2
74 ,IC_CATEGORY_SEGMENT IN VARCHAR2
75 ,IC_CAT_PSEG IN VARCHAR2) RETURN VARCHAR2;
76 FUNCTION IC_ITEM_PSEGFORMULA(IC_ITEM_NUMBER IN VARCHAR2
77 ,IC_ITEM_SEGMENT IN VARCHAR2
78 ,IC_ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
79 FUNCTION IC_CAT_PSEGFORMULA(IC_CATEGORY IN VARCHAR2
80 ,IC_CATEGORY_SEGMENT IN VARCHAR2
81 ,IC_CAT_PSEG IN VARCHAR2) RETURN VARCHAR2;
82 FUNCTION SI_ITEM_PSEGFORMULA(SI_ITEM_NUMBER IN VARCHAR2
83 ,SI_ITEM_SEGMENT IN VARCHAR2
84 ,SI_ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
85 FUNCTION BEFOREPFORM RETURN BOOLEAN;
86 FUNCTION IC_QUANTITY1FORMULA(IC_QUANTITY IN NUMBER) RETURN NUMBER;
87 FUNCTION SI_SI_TOTALFORMULA(SI_SI_MATL IN NUMBER
88 ,SI_SI_MOVH IN NUMBER
89 ,SI_SI_RES IN NUMBER
90 ,SI_SI_OSP IN NUMBER
91 ,SI_SI_OVHD IN NUMBER) RETURN NUMBER;
92 FUNCTION SI_REP_TOTALFORMULA(SI_REP_MATL IN NUMBER
93 ,SI_REP_MOVH IN NUMBER
94 ,SI_REP_RES IN NUMBER
95 ,SI_REP_OSP IN NUMBER
96 ,SI_REP_OVHD IN NUMBER) RETURN NUMBER;
97 FUNCTION IC_ITEM_TOTAL_RFORMULA(IC_ITEM_TOTAL IN NUMBER) RETURN NUMBER;
98 FUNCTION IC_TOTAL_RFORMULA(IC_TOTAL IN NUMBER) RETURN NUMBER;
99 FUNCTION IC_REP_TOTAL_RFORMULA(IC_REP_TOTAL IN NUMBER) RETURN NUMBER;
100 FUNCTION IC_CAT_TOTAL_RFORMULA(IC_CAT_TOTAL IN NUMBER) RETURN NUMBER;
101 FUNCTION SI_TOTAL_RFORMULA(SI_TOTAL IN NUMBER) RETURN NUMBER;
102 FUNCTION SI_SI_MATL_RFORMULA(SI_SI_MATL IN NUMBER) RETURN NUMBER;
103 FUNCTION SI_SI_MOVH_RFORMULA(SI_SI_MOVH IN NUMBER) RETURN NUMBER;
104 FUNCTION SI_SI_OVHD_RFORMULA(SI_SI_OVHD IN NUMBER) RETURN NUMBER;
105 FUNCTION SI_SI_RES_RFORMULA(SI_SI_RES IN NUMBER) RETURN NUMBER;
106 FUNCTION SI_SI_OSP_RFORMULA(SI_SI_OSP IN NUMBER) RETURN NUMBER;
107 FUNCTION P_REPORT_NAMEVALIDTRIGGER RETURN BOOLEAN;
108 FUNCTION AFTERPFORM RETURN BOOLEAN;
109 FUNCTION IC_UNIT_COST1FORMULA(IC_ITEM_QTY IN NUMBER
110 ,IC_ITEM_TOTAL IN NUMBER
111 ,IC_UNIT_COST IN NUMBER) RETURN NUMBER;
112 END BOM_CSTRINVR_XMLP_PKG;
113