[Home] [Help]
104:
105: /* Modified by Ramananda for bug# due to uptake of ap_invoice_lines_all */
106: cursor c_get_rcv_transaction_id(p_invoice_id number, p_po_distribution_id number, cp_lt_lookup_code ap_invoice_lines_all.line_type_lookup_code%type ) is
107: select rcv_transaction_id
108: from ap_invoice_lines_all --ap_invoice_distributions_all /* uptake of ap_invoice_lines_all */
109: where invoice_id = p_invoice_id
110: and line_type_lookup_code = cp_lt_lookup_code --'ITEM'
111: and po_distribution_id = p_po_distribution_id;
112:
111: and po_distribution_id = p_po_distribution_id;
112:
113: cursor c_get_not_validated_count (p_invoice_id number) is
114: /*select count(1)
115: from ap_invoice_distributions_all
116: where invoice_id = p_invoice_id
117: and nvl(match_status_flag, 'N') <> 'A';*/
118: --commented the above and added the below by Sanjikum for Bug#4929400
119: SELECT 'Y'
118: --commented the above and added the below by Sanjikum for Bug#4929400
119: SELECT 'Y'
120: FROM dual
121: WHERE exists (select '1'
122: from ap_invoice_distributions_all
123: where invoice_id = p_invoice_id
124: and nvl(match_status_flag, 'N') <> 'A');
125:
126:
152: v_tax_amount JAI_AP_MATCH_INV_TAXES.tax_amount%type;
153: v_doc_type varchar2(10);
154: v_tax_target_amount number;
155: v_st_dtl_id number;
156: v_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%type;
157: v_parent_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type;
158: v_debug char(1); -- := 'Y'; --Ramananda for File.Sql.35
159: v_uid number;
160:
153: v_doc_type varchar2(10);
154: v_tax_target_amount number;
155: v_st_dtl_id number;
156: v_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%type;
157: v_parent_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type;
158: v_debug char(1); -- := 'Y'; --Ramananda for File.Sql.35
159: v_uid number;
160:
161: v_invoice_error_flag char(1);
172:
173: v_invoice_process_flag char(1);
174: v_not_processed_inv_cnt number;
175:
176: lv_lt_lookup_code ap_invoice_distributions_all.line_type_lookup_code%type ;
177: v_parent_invoice_line_number JAI_AP_MATCH_INV_TAXES.parent_invoice_line_number%type ;
178:
179:
180: function getSTformsTaxBaseAmount /* uptake of ap_invoice_lines_all*/
207: v_exchange_date ap_invoices_all.exchange_date%type;
208: v_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
209: v_exchange_rate ap_invoices_all.exchange_rate%type;
210:
211: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type;
212:
213: v_line_number ap_invoice_lines_all.line_number%type ;
214:
215: cursor c_get_invoice_currency_dtl is
219:
220: /* uptake of ap_invoice_lines_all */
221: cursor c_get_inv_dist_details is
222: select line_number, po_distribution_id, rcv_transaction_id, amount /* invoice_distribution_id*/
223: from ap_invoice_lines_all --ap_invoice_distributions_all
224: where invoice_id = p_invoice_id
225: and line_number = p_line_number ;
226: /* and invoice_distribution_id = p_invoice_distribution_id ; */
227:
602: line_number, --distribution_line_number
603: --invoice_distribution_id,
604: po_distribution_id,
605: rcv_transaction_id
606: from ap_invoice_lines_all b --ap_invoice_distributions_all b
607: where invoice_id = c_invoices.invoice_id
608: and line_type_lookup_code = lv_lt_lookup_code --'MISCELLANEOUS' -- only tax lines /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
609: /* and nvl(reversal_flag, 'N') <> 'Y' */
610: and po_distribution_id is not null