1 PACKAGE INV_INVTRHAN_XMLP_PKG AS
2 /* $Header: INVTRHANS.pls 120.2 2008/01/08 06:49:37 dwkrishn noship $ */
3 P_STRUCT_NUM VARCHAR2(15);
4 P_ITEM_FLEX VARCHAR2(900):= '(MSI.SEGMENT1||''\n''||MSI.SEGMENT2||''\n''||MSI.SEGMENT3||''\n''||MSI.SEGMENT4||''\n''||MSI.SEGMENT5||''\n''||MSI.SEGMENT6||''\n''||MSI.SEGMENT7||''\n''||MSI.SEGMENT8||''\n''||MSI.SEGMENT9||''\n''||MSI.SEGMENT10||''\n''||
5 MSI.SEGMENT11||''\n''||MSI.SEGMENT12||''\n''||MSI.SEGMENT13||''\n''||MSI.SEGMENT14||''\n''||MSI.SEGMENT15||''\n''||MSI.SEGMENT16||''\n''||MSI.SEGMENT17||''\n''||MSI.SEGMENT18||''\n''||MSI.SEGMENT19||''\n''||MSI.SEGMENT20)';
6 P_STYPE1 NUMBER := 1;
7 P_Stype1_1 NUMBER := 1;
8 P_STYPE2 NUMBER := 2;
9 P_STYPE2_1 NUMBER := 2;
10 P_STYPE3 NUMBER := 3;
11 P_STYPE3_1 NUMBER := 3;
12 P_STYPE4 NUMBER := 5;
13 P_STYPE4_1 NUMBER := 5;
14 P_STYPE5 NUMBER := 6;
15 P_SELECTION NUMBER;
16 P_HIST_DATE VARCHAR2(40);
17 P_hist_date_1 VARCHAR2(40);
18 P_SORT_ID NUMBER;
19 P_ORG_ID NUMBER;
20 P_CONC_REQUEST_ID NUMBER := 0;
21 P_CAT_FLEX VARCHAR2(900) := '(MC.SEGMENT1||''\n''||MC.SEGMENT2||''\n''||MC.SEGMENT3||''\n''||MC.SEGMENT4||''\n''||MC.SEGMENT5||''\n''||MC.SEGMENT6||''\n''||MC.SEGMENT7||''\n''||MC.SEGMENT8||''\n''||MC.SEGMENT9||''\n''||MC.SEGMENT10||''\n''||
22 MC.SEGMENT11||''\n''||MC.SEGMENT12||''\n''||MC.SEGMENT13||''\n''||MC.SEGMENT14||''\n''||MC.SEGMENT15||''\n''||MC.SEGMENT16||''\n''||MC.SEGMENT17||''\n''||MC.SEGMENT18||''\n''||MC.SEGMENT19||''\n''||MC.SEGMENT20)';
23 P_WHERE_CAT VARCHAR2(2400):= '1=1';
24 P_CAT_HI VARCHAR2(900);
25 P_CAT_LO VARCHAR2(900);
26 P_CAT_SET_ID NUMBER;
27 P_SUBINV_HI VARCHAR2(40);
28 P_SUBINV_LO VARCHAR2(40);
29 P_ITEM_LO VARCHAR2(900);
30 P_ITEM_HI VARCHAR2(900);
31 P_WHERE_ITEM VARCHAR2(2400):= '1=1';
32 P_CAT_STRUCT_NUM VARCHAR2(15);
33 P_VIEW_PUT VARCHAR2(40);
34 P_VIEW VARCHAR2(40) := 'txn_analysis_view';
35 P_CAT_SORT VARCHAR2(900);
36 P_ITEM_ORDER VARCHAR2(900):=1;
37 P_QTY_PRECISION NUMBER;
38 P_OPTIMIZER_FLAG NUMBER;
39 P_TRACE_FLAG NUMBER;
40 P_CONSIGNED NUMBER;
41 P_CG_LO VARCHAR2(32767);
42 P_WMS_ENABLED VARCHAR2(5);
43 P_COST_GROUP_ID NUMBER;
44 P_CG_HI VARCHAR2(32767);
45 P_PJM_ENABLED VARCHAR2(5);
46 P_WMS_PJM_ENABLED VARCHAR2(5);
47 P_VIEW_PUTVALIDTRIGGER_1 VARCHAR2(100);
48 FUNCTION AFTERREPORT RETURN BOOLEAN;
49 FUNCTION C_TARGET_QTY_VALFORMULA(C_COST_TYPE IN NUMBER
50 ,ASS_INV IN NUMBER
51 ,TARGET_QTY IN NUMBER
52 ,CUR_QTY_VAL_OLD IN NUMBER
53 ,CUR_QTY_VAL IN NUMBER
54 ,SOURCE_TYPE1 IN NUMBER
55 ,SOURCE_TYPE2 IN NUMBER
56 ,SOURCE_TYPE3 IN NUMBER
57 ,SOURCE_TYPE4 IN NUMBER
58 ,SOURCE_TYPE5 IN NUMBER
59 ,OTHER IN NUMBER
60 ,ITEM_ID IN NUMBER
61 ,SUBINVENTORY IN VARCHAR2
62 ,C_STD_PREC IN NUMBER) RETURN NUMBER;
63 FUNCTION C_FROM_CATFORMULA RETURN VARCHAR2;
64 FUNCTION C_WHERE_CATFORMULA RETURN VARCHAR2;
65 FUNCTION C_SOURCE_TYPE1FORMULA RETURN VARCHAR2;
66 FUNCTION C_SOURCE_TYPE2FORMULA RETURN VARCHAR2;
67 FUNCTION C_SOURCE_TYPE3FORMULA RETURN VARCHAR2;
68 FUNCTION C_SOURCE_TYPE4FORMULA RETURN VARCHAR2;
69 FUNCTION C_SOURCE_TYPE5FORMULA RETURN VARCHAR2;
70 FUNCTION C_WHERE_SUBINVFORMULA RETURN VARCHAR2;
71 FUNCTION C_CAT_SET_NAMEFORMULA RETURN VARCHAR2;
72 FUNCTION C_CHANGE_VALFORMULA(C_TARGET_QTY_VAL IN NUMBER
73 ,CUR_QTY_VAL IN NUMBER) RETURN NUMBER;
74 FUNCTION BEFOREREPORT RETURN BOOLEAN;
75 FUNCTION C_CHANGE_QTYFORMULA(CUR_QTY IN NUMBER
76 ,TARGET_QTY IN NUMBER) RETURN NUMBER;
77 FUNCTION AFTERPFORM RETURN BOOLEAN;
78 -- FUNCTION P_VIEW_PUTVALIDTRIGGER RETURN BOOLEAN;
79 FUNCTION P_VIEW_PUTVALIDTRIGGER RETURN VARCHAR2;
80 FUNCTION C_CURRENCY_CODEFORMULA(CURRENCY_CODE_REP IN VARCHAR2) RETURN VARCHAR2;
81 FUNCTION BEFOREPFORM RETURN BOOLEAN;
82 FUNCTION C_CAT_PADFORMULA(C_CAT_PAD IN VARCHAR2) RETURN VARCHAR2;
83 FUNCTION CUR_QTY_VALFORMULA(ASS_INV IN NUMBER
84 ,CUR_QTY_VAL_OLD IN NUMBER
85 ,SOURCE_TYPE1 IN NUMBER
86 ,SOURCE_TYPE2 IN NUMBER
87 ,SOURCE_TYPE3 IN NUMBER
88 ,SOURCE_TYPE4 IN NUMBER
89 ,OTHER IN NUMBER) RETURN NUMBER;
90 FUNCTION C_COST_TYPEFORMULA RETURN NUMBER;
91 FUNCTION C_OTHERSFORMULA(OTHER IN NUMBER
92 ,C_COST_TYPE IN NUMBER
93 ,ITEM_ID IN NUMBER
94 ,SUBINVENTORY IN VARCHAR2
95 ,TARGET_QTY IN NUMBER
96 ,SOURCE_TYPE1 IN NUMBER
97 ,SOURCE_TYPE2 IN NUMBER
98 ,SOURCE_TYPE3 IN NUMBER
99 ,SOURCE_TYPE4 IN NUMBER
100 ,C_STD_PREC IN NUMBER
101 ,CUR_QTY_VAL IN NUMBER) RETURN NUMBER;
102 FUNCTION C_SOURCE_TYPE1_CFORMULA(SOURCE_TYPE1 IN NUMBER
103 ,C_COST_TYPE IN NUMBER
104 ,ITEM_ID IN NUMBER
105 ,SUBINVENTORY IN VARCHAR2
106 ,TARGET_QTY IN NUMBER
107 ,C_SOURCE_TYPE2_C IN NUMBER
108 ,C_SOURCE_TYPE3_C IN NUMBER
109 ,C_SOURCE_TYPE4_C IN NUMBER
110 ,OTHER IN NUMBER
111 ,CUR_QTY_VAL IN NUMBER) RETURN NUMBER;
112 FUNCTION C_SOURCE_TYPE2_CFORMULA(SOURCE_TYPE2 IN NUMBER
113 ,C_COST_TYPE IN NUMBER
114 ,ITEM_ID IN NUMBER
115 ,SUBINVENTORY IN VARCHAR2
116 ,TARGET_QTY IN NUMBER
117 ,SOURCE_TYPE1 IN NUMBER
118 ,SOURCE_TYPE3 IN NUMBER
119 ,SOURCE_TYPE4 IN NUMBER
120 ,OTHER IN NUMBER
121 ,CUR_QTY_VAL IN NUMBER) RETURN NUMBER;
122 FUNCTION C_SOURCE_TYPE3_CFORMULA(SOURCE_TYPE3 IN NUMBER
123 ,C_COST_TYPE IN NUMBER
124 ,ITEM_ID IN NUMBER
125 ,SUBINVENTORY IN VARCHAR2
126 ,TARGET_QTY IN NUMBER
127 ,SOURCE_TYPE1 IN NUMBER
128 ,SOURCE_TYPE2 IN NUMBER
129 ,SOURCE_TYPE4 IN NUMBER
130 ,OTHER IN NUMBER
131 ,CUR_QTY_VAL IN NUMBER) RETURN NUMBER;
132 FUNCTION C_SOURCE_TYPE4_CFORMULA(SOURCE_TYPE4 IN NUMBER
133 ,C_COST_TYPE IN NUMBER
134 ,ITEM_ID IN NUMBER
135 ,SUBINVENTORY IN VARCHAR2
136 ,TARGET_QTY IN NUMBER
137 ,SOURCE_TYPE1 IN NUMBER
138 ,SOURCE_TYPE2 IN NUMBER
139 ,SOURCE_TYPE3 IN NUMBER
140 ,OTHER IN NUMBER
141 ,CUR_QTY_VAL IN NUMBER) RETURN NUMBER;
142 FUNCTION C_SOURCE_TYPE5_CFORMULA(SOURCE_TYPE5 IN NUMBER) RETURN NUMBER;
143 END INV_INVTRHAN_XMLP_PKG;
144
145