APPS.PSA_FA_INVOICE_DISTRIBUTIONS dependencies on AP_INVOICE_DISTRIBUTIONS

Line 30: l_invoice_id ap_invoice_distributions_all.invoice_id%type;

26: p_prev_inv NUMBER := 0;
27:
28: l_from_gl_date DATE;
29: l_to_gl_date DATE;
30: l_invoice_id ap_invoice_distributions_all.invoice_id%type;
31: l_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%type;
32: l_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
33:
34: TYPE var_cur IS REF CURSOR;

Line 31: l_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%type;

27:
28: l_from_gl_date DATE;
29: l_to_gl_date DATE;
30: l_invoice_id ap_invoice_distributions_all.invoice_id%type;
31: l_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%type;
32: l_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
33:
34: TYPE var_cur IS REF CURSOR;
35: inv_dist_cur VAR_CUR;

Line 32: l_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;

28: l_from_gl_date DATE;
29: l_to_gl_date DATE;
30: l_invoice_id ap_invoice_distributions_all.invoice_id%type;
31: l_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%type;
32: l_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
33:
34: TYPE var_cur IS REF CURSOR;
35: inv_dist_cur VAR_CUR;
36: -- ========================= FND LOG ===========================

Line 48: FROM ap_invoice_distributions ap_inv_dist, gl_code_combinations cc

44: p_where_clause := fa_rx_flex_pkg.flex_sql
45: (101, 'GL#', p_chart_of_accounts, 'CC', 'WHERE', 'ALL','BETWEEN', p_from_account, p_to_account);
46:
47: p_inv_dist := 'SELECT invoice_id, distribution_line_number, invoice_distribution_id
48: FROM ap_invoice_distributions ap_inv_dist, gl_code_combinations cc
49: WHERE ap_inv_dist.dist_code_combination_id = cc.code_combination_id
50: AND posted_flag = '''||'Y'||''''||
51: 'AND assets_addition_flag = '''||'U'||''''||
52: 'AND assets_tracking_flag != '''||'Y'||''''||

Line 58: FROM ap_invoice_distributions ap_inv_dist, gl_code_combinations cc

54:
55: IF l_from_gl_date IS NULL THEN
56:
57: p_inv_dist := 'SELECT invoice_id, distribution_line_number, invoice_distribution_id
58: FROM ap_invoice_distributions ap_inv_dist, gl_code_combinations cc
59: WHERE ap_inv_dist.dist_code_combination_id = cc.code_combination_id
60: AND posted_flag = '''||'Y'||''''||
61: 'AND assets_addition_flag = '''||'U'||''''||
62: 'AND assets_tracking_flag != '''||'Y'||''''||

Line 97: UPDATE ap_invoice_distributions

93: PRINT_INVOICE_DETAILS(p_prev_inv);
94: p_prev_inv := l_invoice_id;
95: END IF;
96:
97: UPDATE ap_invoice_distributions
98: SET assets_tracking_flag = 'Y'
99: WHERE invoice_distribution_id = l_inv_dist_id;
100:
101: END LOOP;