[Home] [Help]
PACKAGE: APPS.PO_POXRRVDR_XMLP_PKG
Source
1 PACKAGE PO_POXRRVDR_XMLP_PKG AS
2 /* $Header: POXRRVDRS.pls 120.1.12010000.3 2008/11/25 20:33:21 mpuranik ship $ */
3 P_TITLE VARCHAR2(50);
4
5 P_CONC_REQUEST_ID NUMBER := 0;
6
7 P_STRUCT_NUM VARCHAR2(15);
8 QTY_PRECISION VARCHAR2(50);
9
10 P_ACCOUNT_FROM VARCHAR2(300);
11
12 P_ACCOUNT_TO VARCHAR2(300);
13
14 P_FLEX_ACC VARCHAR2(31000);
15
16 P_FLEX_ITEM VARCHAR2(800);
17
18 P_CATEGORY_FROM VARCHAR2(900);
19
20 P_CATEGORY_TO VARCHAR2(900);
21
22 P_ITEM_FROM VARCHAR2(900);
23
24 P_ITEM_TO VARCHAR2(900);
25
26 P_WHERE_ACC VARCHAR2(800);
27
28 P_WHERE_CAT VARCHAR2(2000);
29
30 P_WHERE_ITEM VARCHAR2(2000);
31
32 P_CHART_OF_ACCOUNTS_ID NUMBER;
33
34 P_ORG_ID NUMBER;
35
36 P_ORG_DISPLAYED VARCHAR2(240);
37
38 P_FLEX_CAT VARCHAR2(31000);
39
40 P_QTY_PRECISION NUMBER;
41
42 P_BASE_CURRENCY VARCHAR2(15) := 'USD';
43
44 P_SORT_ID NUMBER := 1;
45
46 P_RECEIPT_NUM_FROM VARCHAR2(40);
47
48 P_RECEIPT_NUM_TO VARCHAR2(40);
49
50 P_VENDOR_FROM VARCHAR2(240);
51
52 P_VENDOR_TO VARCHAR2(240);
53
54 P_ACCT_DATE_FROM DATE;
55
56 P_ACCT_DATE_TO DATE;
57
58 P_ACCT_DATE_FROM1 VARCHAR2(10);
59
60 P_ACCT_DATE_TO1 VARCHAR2(10);
61
62 P_CAT_SET_ID NUMBER := 177;
63
64 P_VALUE_LO NUMBER;
65
66 P_VALUE_HI NUMBER;
67
68 P_SORT_OPTION VARCHAR2(40);
69
70 P_DATE_FROM DATE;
71
72 P_DATE_TO DATE;
73
74 P_CATEGORY_SET NUMBER;
75
76 P_WHERE_RECEIPT_NUM_FROM VARCHAR2(240) := '1=1';
77
78 P_WHERE_RECEIPT_NUM_TO VARCHAR2(240) := '1=1';
79
80 P_CATEGORY_SET_ID VARCHAR2(40);
81
82 P_CAT_SET_ID1 VARCHAR2(40);
83
84 P_WHERE_ACCOUNTING_DATE_FROM VARCHAR2(240) := '1=1';
85
86 P_WHERE_ACCOUNTING_DATE_TO VARCHAR2(240) := '1=1';
87
88 P_WHERE_TRX_DATE_FROM VARCHAR2(240) := '1=1';
89
90 P_WHERE_TRX_DATE_TO VARCHAR2(240) := '1=1';
91
92 P_WHERE_VENDOR VARCHAR2(240) := '1=1';
93
94 FUNCTION BEFOREREPORT RETURN BOOLEAN;
95
96 FUNCTION C_FLEX_ACC_DESCFORMULA(C_FLEX_ACC_DESC IN VARCHAR2) RETURN VARCHAR2;
97
98 FUNCTION CALC_TRX_VALUE(CURRENCY_CODE IN VARCHAR2
99 ,C_PRECISION IN NUMBER
100 ,EVENT_TYPE_ID IN NUMBER
101 ,C_PRIMARY_UNIT_PRICE1 IN NUMBER
102 ,PRIMARY_QTY IN NUMBER
103 ,CURR_CONV_RATE IN NUMBER
104 /* Support for Landed Cost Management */
105 ,PRIOR_UNIT_PRICE IN NUMBER
106 ,PRIMARY_LANDED_COST NUMBER
107 ,ACCOUNTING_LINE_TYPE IN VARCHAR2) RETURN NUMBER;
108
109 FUNCTION C_SORTFORMULA RETURN VARCHAR2;
110
111 FUNCTION C_CAT_SET_NAMEFORMULA RETURN VARCHAR2;
112
113 FUNCTION C_FUNC_CURRENCY_CODEFORMULA(R_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
114
115 FUNCTION PRICE(ENTERED_DR IN NUMBER
116 ,PRIMARY_UNIT_PRICE IN NUMBER) RETURN NUMBER;
117
118 FUNCTION GET_P_STRUCT_NUM RETURN BOOLEAN;
119
120 FUNCTION C_SORT_MAIN_DISPFORMULA(C_FLEX_ITEM_DISP IN VARCHAR2) RETURN VARCHAR2;
121
122 FUNCTION C_CAT_DISPFORMULA(C_FLEX_CAT_DISP IN VARCHAR2) RETURN VARCHAR2;
123
124 FUNCTION C_VENDORFORMULA(VENDOR_NAME IN VARCHAR2) RETURN VARCHAR2;
125
126 FUNCTION C_VENDOR_NUMBERFORMULA(VENDOR_NUMBER IN VARCHAR2) RETURN VARCHAR2;
127
128 FUNCTION DISPLAY_COLUMN(DELIVER_TO_LOCATION IN VARCHAR2
129 ,C_FLEX_ITEM_DISP IN VARCHAR2) RETURN CHARACTER;
130
131 FUNCTION AFTERPFORM RETURN BOOLEAN;
132
133 FUNCTION C_PRIMARY_UNIT_PRICE1FORMULA(ACC_EVENT_ID IN NUMBER
134 ,TRX_ID IN NUMBER
135 ,PRIMARY_UNIT_PRICE IN NUMBER
136 ,PO_TO_PR_UOM_RATE IN NUMBER) RETURN NUMBER;
137
138 FUNCTION C_PRIMARY_UNIT_PRICE2FORMULA(EVENT_TYPE_ID IN NUMBER
139 ,C_PRIMARY_UNIT_PRICE1 IN NUMBER
140 /* Support for Landed Cost Management */
141 ,PRIMARY_LANDED_COST NUMBER
142 ,PRIOR_UNIT_PRICE NUMBER
143 ,ACCOUNTING_LINE_TYPE IN VARCHAR2
144 ,CURR_CONV_RATE IN NUMBER) RETURN NUMBER;
145
146 FUNCTION C_QUANTITYFORMULA(EVENT_TYPE_ID IN NUMBER
147 ,QTY IN NUMBER) RETURN NUMBER;
148
149 FUNCTION AFTERREPORT RETURN BOOLEAN;
150
151
152
153 END PO_POXRRVDR_XMLP_PKG;
154