APPS.PSA_FA_INVOICE_DISTRIBUTIONS dependencies on AP_INVOICE_DISTRIBUTIONS

Line 28: l_invoice_id ap_invoice_distributions_all.invoice_id%type;

24: p_where_clause VARCHAR2(3000);
25: p_inv_dist VARCHAR2(4000);
26: p_prev_inv NUMBER := 0;
27:
28: l_invoice_id ap_invoice_distributions_all.invoice_id%type;
29: l_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%type;
30: l_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
31:
32: TYPE var_cur IS REF CURSOR;

Line 29: l_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%type;

25: p_inv_dist VARCHAR2(4000);
26: p_prev_inv NUMBER := 0;
27:
28: l_invoice_id ap_invoice_distributions_all.invoice_id%type;
29: l_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%type;
30: l_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
31:
32: TYPE var_cur IS REF CURSOR;
33: inv_dist_cur VAR_CUR;

Line 30: l_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;

26: p_prev_inv NUMBER := 0;
27:
28: l_invoice_id ap_invoice_distributions_all.invoice_id%type;
29: l_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%type;
30: l_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
31:
32: TYPE var_cur IS REF CURSOR;
33: inv_dist_cur VAR_CUR;
34: -- ========================= FND LOG ===========================

Line 43: FROM ap_invoice_distributions ap_inv_dist, gl_code_combinations cc

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

Line 53: FROM ap_invoice_distributions ap_inv_dist, gl_code_combinations cc

49:
50: IF p_from_gl_date IS NULL THEN
51:
52: p_inv_dist := 'SELECT invoice_id, distribution_line_number, invoice_distribution_id
53: FROM ap_invoice_distributions ap_inv_dist, gl_code_combinations cc
54: WHERE ap_inv_dist.dist_code_combination_id = cc.code_combination_id
55: AND posted_flag = '''||'Y'||''''||
56: 'AND assets_addition_flag = '''||'U'||''''||
57: 'AND assets_tracking_flag != '''||'Y'||''''||

Line 92: UPDATE ap_invoice_distributions

88: PRINT_INVOICE_DETAILS(p_prev_inv);
89: p_prev_inv := l_invoice_id;
90: END IF;
91:
92: UPDATE ap_invoice_distributions
93: SET assets_tracking_flag = 'Y'
94: WHERE invoice_distribution_id = l_inv_dist_id;
95:
96: END LOOP;