DBA Data[Home] [Help]

APPS.JAI_AP_TOLERANCE_PKG dependencies on AP_INVOICE_LINES_ALL

Line 30: FROM ap_invoice_lines_all ail

26: AND rownum = 1;
27:
28: CURSOR line_amounts(inv_id NUMBER) IS
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

Line 45: cp_invoice_line_number ap_invoice_lines_all.line_number%TYPE,

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
49: SELECT distribution_line_number, set_of_books_id

Line 46: cp_line_type ap_invoice_lines_all.line_type_lookup_code%TYPE

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
49: SELECT distribution_line_number, set_of_books_id
50: FROM ap_invoice_distributions_all

Line 60: cp_description ap_invoice_lines_all.description%TYPE,

56:
57: -- bug 7114863. Added by Lakshmi Gopalsami
58:
59: CURSOR from_inv_line(inv_id NUMBER,
60: cp_description ap_invoice_lines_all.description%TYPE,
61: cp_line_type ap_invoice_lines_all.line_type_lookup_code%TYPE
62: )
63: IS
64: SELECT line_number, set_of_books_id

Line 61: cp_line_type ap_invoice_lines_all.line_type_lookup_code%TYPE

57: -- bug 7114863. Added by Lakshmi Gopalsami
58:
59: CURSOR from_inv_line(inv_id NUMBER,
60: cp_description ap_invoice_lines_all.description%TYPE,
61: cp_line_type ap_invoice_lines_all.line_type_lookup_code%TYPE
62: )
63: IS
64: SELECT line_number, set_of_books_id
65: FROM ap_invoice_lines_all

Line 65: FROM ap_invoice_lines_all

61: cp_line_type ap_invoice_lines_all.line_type_lookup_code%TYPE
62: )
63: IS
64: SELECT line_number, set_of_books_id
65: FROM ap_invoice_lines_all
66: WHERE invoice_id = inv_id
67: AND line_type_lookup_code =cp_line_type
68: AND description = cp_description
69: AND rownum = 1;

Line 96: lv_not_required AP_INVOICE_LINES_ALL.WFAPPROVAL_STATUS%TYPE;

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;
100: ln_distribution_line_num AP_INVOICE_DISTRIBUTIONS_ALL.DISTRIBUTION_LINE_NUMBER%TYPE;

Line 97: lv_not_matched AP_INVOICE_LINES_ALL.MATCH_TYPE%TYPE;

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;
100: ln_distribution_line_num AP_INVOICE_DISTRIBUTIONS_ALL.DISTRIBUTION_LINE_NUMBER%TYPE;
101: ln_user_id AP_INVOICE_LINES_ALL.CREATED_BY%TYPE;

Line 101: ln_user_id AP_INVOICE_LINES_ALL.CREATED_BY%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:
105: --> Cursor to fetch the maximum line_number for current invoice

Line 102: ln_login_id AP_INVOICE_LINES_ALL.LAST_UPDATE_LOGIN%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:
105: --> Cursor to fetch the maximum line_number for current invoice
106: CURSOR cur_get_max_line_number

Line 103: ln_invc_line_num AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;

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:
105: --> Cursor to fetch the maximum line_number for current invoice
106: CURSOR cur_get_max_line_number
107: IS

Line 109: FROM ap_invoice_lines_all

105: --> Cursor to fetch the maximum line_number for current invoice
106: CURSOR cur_get_max_line_number
107: IS
108: SELECT max (line_number)
109: FROM ap_invoice_lines_all
110: WHERE invoice_id = p_invoice_id;
111:
112: -- Cursor to fetch the details of
113: -- maximum line from ap_invoice_lines_all for current invoice

Line 113: -- maximum line from ap_invoice_lines_all for current invoice

109: FROM ap_invoice_lines_all
110: WHERE invoice_id = p_invoice_id;
111:
112: -- Cursor to fetch the details of
113: -- maximum line from ap_invoice_lines_all for current invoice
114: CURSOR cur_get_max_ap_inv_line (cpn_max_line_num AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE)
115: IS
116: SELECT accounting_date
117: ,period_name

Line 114: CURSOR cur_get_max_ap_inv_line (cpn_max_line_num AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE)

110: WHERE invoice_id = p_invoice_id;
111:
112: -- Cursor to fetch the details of
113: -- maximum line from ap_invoice_lines_all for current invoice
114: CURSOR cur_get_max_ap_inv_line (cpn_max_line_num AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE)
115: IS
116: SELECT accounting_date
117: ,period_name
118: ,deferred_acctg_flag

Line 124: FROM ap_invoice_lines_all

120: ,def_acctg_end_date
121: ,def_acctg_number_of_periods
122: ,def_acctg_period_type
123: ,set_of_books_id
124: FROM ap_invoice_lines_all
125: WHERE invoice_id = p_invoice_id
126: AND line_number = cpn_max_line_num;
127:
128: rec_max_ap_lines_all CUR_GET_MAX_AP_INV_LINE%ROWTYPE;

Line 138: ap_invoice_lines_all b

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
142: AND b.line_type_lookup_code = 'ITEM';

Line 229: UPDATE ap_invoice_lines_all

225: WHERE invoice_id = p_invoice_id
226: AND vat_code = lv_vat_code
227: RETURNING invoice_line_number INTO ln_invc_line_num;
228:
229: UPDATE ap_invoice_lines_all
230: SET amount = 0
231: WHERE invoice_id = p_invoice_id
232: AND line_number = ln_invc_line_num;
233:

Line 302: UPDATE ap_invoice_lines_all

298: -- 5(a)
299: IF from_inv_line%FOUND THEN
300: ln_invc_line_num := from_inv_line_rec.line_number;
301:
302: UPDATE ap_invoice_lines_all
303: SET amount = insertion_amount,
304: last_update_date = sysdate,
305: last_updated_by = ln_user_id,
306: last_update_login = ln_login_id

Line 314: INSERT INTO ap_invoice_lines_all

310: ELSE
311: ln_invc_line_num := ln_max_lnno + 1;
312: BEGIN
313: --> Create a record in ap_invoice_lines based on the maximum line
314: INSERT INTO ap_invoice_lines_all
315: (
316: INVOICE_ID
317: , LINE_NUMBER
318: , LINE_TYPE_LOOKUP_CODE