1 PACKAGE CSTPPIPV AUTHID CURRENT_USER AS
2 /* $Header: CSTPIPVS.pls 120.3 2011/11/14 01:29:19 yuyun ship $*/
3
4 /*---------------------------------------------------------------------------*
5 | PRIVATE PROCEDURE |
6 | trf_invoice_to_inventory |
7 | This procedure generates the necessary interface transactions to |
8 | transfer the invoice price variances of items that match the user |
9 | specified parameters to inventory. |
10 | |
11 | p_item_option: |
12 | 1: All Asset items |
13 | 2: Specific Asset Item |
14 | 5: Category Items |
15 | |
16 | p_invoice_project_option: |
17 | 1: All invoices |
18 | 2: Project invoices |
19 | |
20 | aida.inventory_transfer_status: |
21 | N: Not transferred |
22 | NULL: Transferred or Not Applicable |
23 | |
24 *----------------------------------------------------------------------------*/
25 PROCEDURE trf_invoice_to_inventory(
26 errbuf OUT NOCOPY VARCHAR2,
27 retcode OUT NOCOPY NUMBER,
28 p_organization_id IN NUMBER,
29 p_description IN VARCHAR2 DEFAULT NULL,
30 p_item_option IN NUMBER,
31 p_item_dummy IN NUMBER DEFAULT NULL,
32 p_category_dummy IN NUMBER DEFAULT NULL,
33 p_specific_item_id IN NUMBER DEFAULT NULL,
34 p_category_set_id IN NUMBER DEFAULT NULL,
35 p_category_validate_flag IN VARCHAR2 DEFAULT NULL,
36 p_category_structure IN NUMBER DEFAULT NULL,
37 p_category_id IN NUMBER DEFAULT NULL,
38 p_invoice_project_option IN NUMBER,
39 p_project_dummy IN NUMBER DEFAULT NULL,
40 p_project_id IN NUMBER DEFAULT NULL,
41 p_adj_account_dummy IN NUMBER,
42 p_adj_account IN NUMBER,
43 p_cutoff_date IN VARCHAR2,
44 p_transaction_process_mode IN NUMBER
45 );
46
47 /*---------------------------------------------------------------------------*
48 | PRIVATE PROCEDURE |
49 | trf_invoice_to_wip |
50 | This procedure generates the necessary interface transactions to |
51 | transfer the invoice price variances of items that match the user |
52 | specified parameters to the corresponding work orders in Work In |
53 | Process. Currently it's only processing the invoice price variances |
54 | of Outside Processing and Direct items for Maintenance Work Order. |
55 | |
56 | p_item_type: |
57 | 1: Outside Processing and Direct items |
58 | 2: Outside Processing items only |
59 | 3: Direct Items only |
60 | |
61 | p_item_option: |
62 | 1: All OSP items |
63 | 2: Specific OSP Item |
64 | 5: Category OSP Items |
65 | |
66 | p_invoice_project_option: |
67 | 1: All invoices |
68 | 2: Project invoices |
69 | |
70 | aida.inventory_transfer_status: |
71 | N: Not transferred |
72 | NULL: Transferred or Not Applicable |
73 | |
74 *----------------------------------------------------------------------------*/
75 PROCEDURE trf_invoice_to_wip(
76 errbuf OUT NOCOPY VARCHAR2,
77 retcode OUT NOCOPY NUMBER,
78 p_organization_id IN NUMBER,
79 p_description IN VARCHAR2 DEFAULT NULL,
80 p_work_order_id IN NUMBER DEFAULT NULL,
81 p_item_type IN NUMBER,
82 p_item_type_dummy IN NUMBER DEFAULT NULL,
83 p_item_option IN NUMBER DEFAULT NULL,
84 p_item_dummy IN NUMBER DEFAULT NULL,
85 p_category_dummy IN NUMBER DEFAULT NULL,
86 p_specific_item_id IN NUMBER DEFAULT NULL,
87 p_category_set_id IN NUMBER DEFAULT NULL,
88 p_category_validate_flag IN VARCHAR2 DEFAULT NULL,
89 p_category_structure IN NUMBER DEFAULT NULL,
90 p_category_id IN NUMBER DEFAULT NULL,
91 p_project_dummy IN NUMBER DEFAULT NULL,
92 p_project_id IN NUMBER DEFAULT NULL,
93 p_adj_account_dummy IN NUMBER,
94 p_adj_account IN NUMBER,
95 p_cutoff_date IN VARCHAR2,
96 p_transaction_process_mode IN NUMBER
97 );
98
99 FUNCTION trf_invoice_to_wip(
100 errbuf OUT NOCOPY VARCHAR2,
101 retcode OUT NOCOPY NUMBER,
102 p_organization_id IN NUMBER,
103 p_description IN VARCHAR2 DEFAULT NULL,
104 p_work_order_id IN NUMBER DEFAULT NULL,
105 p_item_type IN NUMBER,
106 p_item_option IN NUMBER DEFAULT NULL,
107 p_specific_item_id IN NUMBER DEFAULT NULL,
108 p_category_set_id IN NUMBER DEFAULT NULL,
109 p_category_id IN NUMBER DEFAULT NULL,
110 p_project_id IN NUMBER DEFAULT NULL,
111 p_adj_account IN NUMBER,
112 p_cutoff_date IN VARCHAR2,
113 p_transaction_process_mode IN NUMBER,
114 p_request_id IN NUMBER,
115 p_user_id IN NUMBER,
116 p_login_id IN NUMBER,
117 p_prog_appl_id IN NUMBER,
118 p_prog_id IN NUMBER
119 ) return NUMBER;
120
121 /*---------------------------------------------------------------------------*
122 | PRIVATE PROCEDURE |
123 | generate_trf_info |
124 | This procedure generates the invoice price variances information |
125 | for the specified inventory item and cutoff date |
126 | |
127 *----------------------------------------------------------------------------*/
128 PROCEDURE generate_trf_info (
129 p_organization_id IN NUMBER,
130 p_inventory_item_id IN NUMBER,
131 p_invoice_project_option IN NUMBER,
132 p_project_id IN NUMBER,
133 p_cost_group_id IN NUMBER,
134 p_cutoff_date IN DATE,
135 p_user_id IN NUMBER,
136 p_login_id IN NUMBER,
137 p_request_id IN NUMBER,
138 p_prog_id IN NUMBER,
139 p_prog_app_id IN NUMBER,
140 p_batch_id IN NUMBER,
141 p_default_txn_date IN DATE,
142 x_err_num OUT NOCOPY NUMBER,
143 x_err_code OUT NOCOPY VARCHAR2,
144 x_err_msg OUT NOCOPY VARCHAR2
145 );
146
147 /*---------------------------------------------------------------------------*
148 | PRIVATE PROCEDURE |
149 | generate_wip_info |
150 | This procedure generates the invoice price variances information |
151 | for the specified OSP or Direct item on the specified po |
152 | distribution and cutoff date. |
153 | |
154 *----------------------------------------------------------------------------*/
155 PROCEDURE generate_wip_info (
156 p_organization_id IN NUMBER,
157 p_inventory_item_id IN NUMBER,
158 p_project_id IN NUMBER,
159 p_po_distribution_id IN NUMBER,
160 p_cutoff_date IN DATE,
161 p_user_id IN NUMBER,
162 p_login_id IN NUMBER,
163 p_request_id IN NUMBER,
164 p_prog_id IN NUMBER,
165 p_prog_app_id IN NUMBER,
166 p_batch_id IN NUMBER,
167 p_transaction_process_mode IN NUMBER,
168 p_default_txn_date IN DATE,
169 x_err_num OUT NOCOPY NUMBER,
170 x_err_code OUT NOCOPY VARCHAR2,
171 x_err_msg OUT NOCOPY VARCHAR2
172 );
173
174 PROCEDURE get_upd_txn_date (
175 p_po_distribution_id IN NUMBER,
176 p_default_txn_date IN DATE,
177 p_organization_id IN NUMBER, --BUG#5709567-FPBUG5109100 --Bug #13075737, Release commented p_organization_id
178 x_transaction_date OUT NOCOPY DATE,
179 x_err_num OUT NOCOPY NUMBER,
180 x_err_code OUT NOCOPY VARCHAR2,
181 x_err_msg OUT NOCOPY VARCHAR2
182 );
183
184 PROCEDURE get_default_date (
185 p_organization_id IN NUMBER,
186 x_default_date OUT NOCOPY DATE,
187 x_err_num OUT NOCOPY NUMBER,
188 x_err_code OUT NOCOPY VARCHAR2,
189 x_err_msg OUT NOCOPY VARCHAR2
190 );
191
192 END CSTPPIPV;