APPS.IGC_CC_INT_CC_REL_PUB dependencies on IGC_CC_DET_PF

Line 50: x_release_cc_det_pf_line_id OUT NOCOPY igc_cc_det_pf.cc_det_pf_line_id%TYPE

46: --
47: -- To fetch the release payment forecast line Id.
48: --
49: PROCEDURE release_cc_det_pf_line_id (
50: x_release_cc_det_pf_line_id OUT NOCOPY igc_cc_det_pf.cc_det_pf_line_id%TYPE
51: );
52:
53: PROCEDURE output_debug (p_path IN VARCHAR2, p_debug_msg IN VARCHAR2)
54: IS

Line 122: l_cc_det_pf_lines_rec igc_cc_det_pf%ROWTYPE;

118: l_api_name CONSTANT VARCHAR2 (30) := 'create_releases';
119: l_api_version CONSTANT NUMBER := 1.0;
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

Line 139: l_release_cc_det_pf_line_id igc_cc_det_pf.cc_det_pf_line_id%TYPE;

135: := 0;
136: l_release_cc_num igc_cc_headers.cc_num%TYPE;
137: l_release_cc_header_id igc_cc_headers.cc_header_id%TYPE;
138: l_release_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;
139: l_release_cc_det_pf_line_id igc_cc_det_pf.cc_det_pf_line_id%TYPE;
140: l_return_status VARCHAR2 (1);
141: l_msg_count NUMBER;
142: l_msg_data VARCHAR2 (2000);
143: l_row_id VARCHAR2 (18);

Line 173: FROM igc_cc_det_pf ccdpf

169:
170: CURSOR c_cc_det_pf_csr (p_cc_acct_line_id IN NUMBER)
171: IS
172: SELECT *
173: FROM igc_cc_det_pf ccdpf
174: WHERE ccdpf.cc_acct_line_id = p_cc_acct_line_id;
175:
176: CURSOR c_inv_csr
177: IS

Line 724: igc_cc_det_pf_pkg.insert_row

720: THEN
721: RAISE fnd_api.g_exc_unexpected_error;
722: END IF; -- Payment Forecast Line Identification.
723:
724: igc_cc_det_pf_pkg.insert_row
725: (p_api_version => 1.0,
726: p_init_msg_list => fnd_api.g_false,
727: p_commit => fnd_api.g_false,
728: p_validation_level => fnd_api.g_valid_level_full,

Line 1162: x_release_cc_det_pf_line_id OUT NOCOPY igc_cc_det_pf.cc_det_pf_line_id%TYPE

1158: RETURN;
1159: END release_cc_acct_line_id;
1160:
1161: PROCEDURE release_cc_det_pf_line_id (
1162: x_release_cc_det_pf_line_id OUT NOCOPY igc_cc_det_pf.cc_det_pf_line_id%TYPE
1163: )
1164: IS
1165: l_api_name CONSTANT VARCHAR2 (30) := 'release_cc_det_pf_line_id';
1166: l_full_path VARCHAR2 (255);

Line 1172: SELECT igc_cc_det_pf_s.NEXTVAL

1168: l_full_path := g_path || 'release_cc_det_pf_line_id';
1169: x_release_cc_det_pf_line_id := NULL;
1170:
1171: BEGIN
1172: SELECT igc_cc_det_pf_s.NEXTVAL
1173: INTO x_release_cc_det_pf_line_id
1174: FROM DUAL;
1175: EXCEPTION
1176: WHEN NO_DATA_FOUND