APPS.IGC_CC_INT_CC_REL_PUB dependencies on IGC_CC_SYSTEM_OPTIONS_ALL

Line 124: l_cc_num_method igc_cc_system_options_all.cc_num_method%TYPE;

120: l_cc_headers_rec igc_cc_headers%ROWTYPE;
121: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;
122: l_cc_det_pf_lines_rec igc_cc_det_pf%ROWTYPE;
123: l_ap_invoice_lines_rec ap_invoices_all%ROWTYPE;
124: l_cc_num_method igc_cc_system_options_all.cc_num_method%TYPE;
125: l_cc_num_datatype igc_cc_system_options_all.cc_num_datatype%TYPE;
126: l_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
127: := 0;
128: l_cc_rel_func_total_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE

Line 125: l_cc_num_datatype igc_cc_system_options_all.cc_num_datatype%TYPE;

121: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;
122: l_cc_det_pf_lines_rec igc_cc_det_pf%ROWTYPE;
123: l_ap_invoice_lines_rec ap_invoices_all%ROWTYPE;
124: l_cc_num_method igc_cc_system_options_all.cc_num_method%TYPE;
125: l_cc_num_datatype igc_cc_system_options_all.cc_num_datatype%TYPE;
126: l_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
127: := 0;
128: l_cc_rel_func_total_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
129: := 0;

Line 476: FROM igc_cc_system_options_all ccnm /*igc_cc_number_methods */

472: -- -------------------------------------------------------------------
473: BEGIN
474: SELECT ccnm.cc_num_method, ccnm.cc_num_datatype
475: INTO l_cc_num_method, l_cc_num_datatype
476: FROM igc_cc_system_options_all ccnm /*igc_cc_number_methods */
477: WHERE ccnm.org_id = p_org_id;
478: EXCEPTION
479: WHEN NO_DATA_FOUND
480: THEN

Line 1009: FROM igc_cc_system_options_all ccnm

1005:
1006: BEGIN
1007: SELECT (ccnm.cc_next_num + 1)
1008: INTO x_release_cc_num
1009: FROM igc_cc_system_options_all ccnm
1010: WHERE ccnm.org_id = p_org_id AND ccnm.cc_num_method IN ('A', 'M');
1011: EXCEPTION
1012: WHEN NO_DATA_FOUND
1013: THEN

Line 1020: UPDATE igc_cc_system_options_all ccnm

1016:
1017: IF x_release_cc_num IS NOT NULL
1018: THEN
1019: BEGIN
1020: UPDATE igc_cc_system_options_all ccnm
1021: SET ccnm.cc_next_num = x_release_cc_num
1022: WHERE ccnm.org_id = p_org_id AND ccnm.cc_num_method IN
1023: ('A', 'M');
1024: EXCEPTION