DBA Data[Home] [Help]

APPS.JAI_AP_TOLERANCE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 21: CURSOR check_entry(inv_id NUMBER, cp_vat_code ap_invoice_distributions_all.vat_code%type) IS

17: SELECT *
18: FROM JAI_AP_TOL_SETUPS_ALL
19: where org_id = p_org_id;
20:
21: CURSOR check_entry(inv_id NUMBER, cp_vat_code ap_invoice_distributions_all.vat_code%type) IS
22: SELECT 1
23: FROM ap_invoice_distributions_all
24: WHERE invoice_id = inv_id
25: AND vat_code = cp_vat_code

Line 23: FROM ap_invoice_distributions_all

19: where org_id = p_org_id;
20:
21: CURSOR check_entry(inv_id NUMBER, cp_vat_code ap_invoice_distributions_all.vat_code%type) IS
22: SELECT 1
23: FROM ap_invoice_distributions_all
24: WHERE invoice_id = inv_id
25: AND vat_code = cp_vat_code
26: AND rownum = 1;
27:

Line 33: FROM ap_invoice_distributions_all apid

29: SELECT SUM(ail.amount) line_amount
30: FROM ap_invoice_lines_all ail
31: WHERE ail.invoice_id = inv_id
32: AND EXISTS (SELECT 1
33: FROM ap_invoice_distributions_all apid
34: WHERE apid.invoice_line_number = ail.line_number
35: AND apid.invoice_id = inv_id
36: );
37:

Line 44: cp_description ap_invoice_distributions_all.description%type,

40: least(h_amt*NVL(tolerance_neg_percent,0)/100, NVL(tolerance_neg_amt,0)) min_val
41: FROM JAI_AP_TOL_SETUPS_ALL;
42:
43: CURSOR from_inv_dist(inv_id NUMBER,
44: cp_description ap_invoice_distributions_all.description%type,
45: cp_invoice_line_number ap_invoice_lines_all.line_number%TYPE,
46: cp_line_type ap_invoice_lines_all.line_type_lookup_code%TYPE
47: )
48: IS

Line 50: FROM ap_invoice_distributions_all

46: cp_line_type ap_invoice_lines_all.line_type_lookup_code%TYPE
47: )
48: IS
49: SELECT distribution_line_number, set_of_books_id
50: FROM ap_invoice_distributions_all
51: WHERE invoice_id = inv_id
52: AND invoice_line_number = cp_invoice_line_number
53: AND line_type_lookup_code = cp_line_type
54: AND description = cp_description

Line 93: lv_misc ap_invoice_distributions_all.line_type_lookup_code%type;

89: line_amounts_rec line_amounts%ROWTYPE;
90: -- for_dist_insertion_rec for_dist_insertion%ROWTYPE; For Bug# 4445989
91: for_functional_currency_rec for_functional_currency%ROWTYPE;
92:
93: lv_misc ap_invoice_distributions_all.line_type_lookup_code%type;
94: lv_vat_code ap_invoice_distributions_all.vat_code%type;
95: lv_description ap_invoice_distributions_all.description%type;
96: lv_not_required AP_INVOICE_LINES_ALL.WFAPPROVAL_STATUS%TYPE;
97: lv_not_matched AP_INVOICE_LINES_ALL.MATCH_TYPE%TYPE;

Line 94: lv_vat_code ap_invoice_distributions_all.vat_code%type;

90: -- for_dist_insertion_rec for_dist_insertion%ROWTYPE; For Bug# 4445989
91: for_functional_currency_rec for_functional_currency%ROWTYPE;
92:
93: lv_misc ap_invoice_distributions_all.line_type_lookup_code%type;
94: lv_vat_code ap_invoice_distributions_all.vat_code%type;
95: lv_description ap_invoice_distributions_all.description%type;
96: lv_not_required AP_INVOICE_LINES_ALL.WFAPPROVAL_STATUS%TYPE;
97: lv_not_matched AP_INVOICE_LINES_ALL.MATCH_TYPE%TYPE;
98: ln_max_lnno NUMBER;

Line 95: lv_description ap_invoice_distributions_all.description%type;

91: for_functional_currency_rec for_functional_currency%ROWTYPE;
92:
93: lv_misc ap_invoice_distributions_all.line_type_lookup_code%type;
94: lv_vat_code ap_invoice_distributions_all.vat_code%type;
95: lv_description ap_invoice_distributions_all.description%type;
96: lv_not_required AP_INVOICE_LINES_ALL.WFAPPROVAL_STATUS%TYPE;
97: lv_not_matched AP_INVOICE_LINES_ALL.MATCH_TYPE%TYPE;
98: ln_max_lnno NUMBER;
99: lv_cash_posted_flag AP_INVOICE_DISTRIBUTIONS_ALL.CASH_POSTED_FLAG%TYPE;

Line 99: lv_cash_posted_flag AP_INVOICE_DISTRIBUTIONS_ALL.CASH_POSTED_FLAG%TYPE;

95: lv_description ap_invoice_distributions_all.description%type;
96: lv_not_required AP_INVOICE_LINES_ALL.WFAPPROVAL_STATUS%TYPE;
97: lv_not_matched AP_INVOICE_LINES_ALL.MATCH_TYPE%TYPE;
98: ln_max_lnno NUMBER;
99: lv_cash_posted_flag AP_INVOICE_DISTRIBUTIONS_ALL.CASH_POSTED_FLAG%TYPE;
100: ln_distribution_line_num AP_INVOICE_DISTRIBUTIONS_ALL.DISTRIBUTION_LINE_NUMBER%TYPE;
101: ln_user_id AP_INVOICE_LINES_ALL.CREATED_BY%TYPE;
102: ln_login_id AP_INVOICE_LINES_ALL.LAST_UPDATE_LOGIN%TYPE;
103: ln_invc_line_num AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;

Line 100: ln_distribution_line_num AP_INVOICE_DISTRIBUTIONS_ALL.DISTRIBUTION_LINE_NUMBER%TYPE;

96: lv_not_required AP_INVOICE_LINES_ALL.WFAPPROVAL_STATUS%TYPE;
97: lv_not_matched AP_INVOICE_LINES_ALL.MATCH_TYPE%TYPE;
98: ln_max_lnno NUMBER;
99: lv_cash_posted_flag AP_INVOICE_DISTRIBUTIONS_ALL.CASH_POSTED_FLAG%TYPE;
100: ln_distribution_line_num AP_INVOICE_DISTRIBUTIONS_ALL.DISTRIBUTION_LINE_NUMBER%TYPE;
101: ln_user_id AP_INVOICE_LINES_ALL.CREATED_BY%TYPE;
102: ln_login_id AP_INVOICE_LINES_ALL.LAST_UPDATE_LOGIN%TYPE;
103: ln_invc_line_num AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
104:

Line 137: FROM ap_invoice_distributions_all a,

133: IS
134: SELECT a.accrual_posted_flag,
135: a.assets_addition_flag,
136: a.assets_tracking_flag
137: FROM ap_invoice_distributions_all a,
138: ap_invoice_lines_all b
139: WHERE a.invoice_id = b.invoice_id
140: and a.invoice_line_number = b.line_number
141: and a.invoice_id = cp_invoice_id

Line 223: UPDATE ap_invoice_distributions_all

219:
220: -- rounding entry has gone but the vat code not updated.
221: ln_invc_line_num := null;
222:
223: UPDATE ap_invoice_distributions_all
224: SET amount = 0
225: WHERE invoice_id = p_invoice_id
226: AND vat_code = lv_vat_code
227: RETURNING invoice_line_number INTO ln_invc_line_num;

Line 383: UPDATE ap_invoice_distributions_all

379:
380: -- 5(b)
381: IF from_inv_dist%FOUND THEN
382:
383: UPDATE ap_invoice_distributions_all
384: SET amount = insertion_amount,
385: last_update_date = sysdate,
386: last_updated_by = ln_user_id,
387: last_update_login = ln_login_id

Line 400: INSERT INTO ap_invoice_distributions_all

396: FETCH c_invoice_distribution INTO r_invoice_distribution;
397: CLOSE c_invoice_distribution;
398: BEGIN
399: --> Create a record in distributions based on the new line created above
400: INSERT INTO ap_invoice_distributions_all
401: (
402: accounting_date,
403: accrual_posted_flag,
404: assets_addition_flag,