APPS.JAI_AP_MISC_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 36: from ap_invoice_distributions_all

32:
33: Cursor get_misc_lines (ln_dist_line_number in number,
34: ln_invoice_id in number ) is
35: select *
36: from ap_invoice_distributions_all
37: where invoice_id = ln_invoice_id
38: and distribution_line_number = ln_dist_line_number;
39:
40:

Line 164: update ap_invoice_distributions_all

160: fnd_file.put_line(FND_FILE.LOG,' Inside IPV not zero '|| ln_tax_ipv);
161:
162: ln_tax_bipv := ln_tax_ipv * nvl(r_get_misc_lines.exchange_rate,1);
163:
164: update ap_invoice_distributions_all
165: set invoice_price_variance = round(ln_tax_ipv,ln_inv_pre),
166: base_invoice_price_variance = round(ln_tax_bipv, ln_base_pre),
167: price_var_code_combination_id = P_price_var_ccid
168: where invoice_distribution_id = r_get_misc_lines.invoice_distribution_id;

Line 179: update ap_invoice_distributions_all

175:
176: fnd_file.put_line(FND_FILE.LOG,' Inside ERV not zero '|| ln_tax_erv);
177: fnd_file.put_line(FND_FILE.LOG,' rate var CCID '|| P_rate_var_ccid);
178:
179: update ap_invoice_distributions_all
180: set exchange_rate_variance = round(ln_tax_erv,ln_inv_pre),
181: rate_var_code_combination_id = P_rate_var_ccid
182: where invoice_distribution_id = r_get_misc_lines.invoice_distribution_id;
183: End if;

Line 190: update ap_invoice_distributions_all

186: Else
187:
188: /* update ipv and bipv to 0. no need to update Var CCID */
189:
190: update ap_invoice_distributions_all
191: set invoice_price_variance = 0,
192: base_invoice_price_variance = 0,
193: exchange_rate_variance = 0
194: where invoice_distribution_id = r_get_misc_lines.invoice_distribution_id;

Line 260: from ap_invoice_distributions_all

256:
257: cursor c_base_inv_amt
258: is
259: select amount
260: from ap_invoice_distributions_all
261: where invoice_distribution_id = p_parent_dist_id
262: and invoice_id = p_invoice_id ;
263:
264: ln_line_amt number ;