APPS.IGC_CC_MPFS_PROCESS_PKG dependencies on IGC_CC_INTERFACE

Line 97: PROCEDURE Insert_Interface_Row(p_cc_interface_rec IN igc_cc_interface%ROWTYPE)

93: =================================================================================*/
94:
95: /* Inserts row into budgetary control interface table */
96:
97: PROCEDURE Insert_Interface_Row(p_cc_interface_rec IN igc_cc_interface%ROWTYPE)
98: IS
99: l_full_path VARCHAR2(255);
100: BEGIN
101:

Line 103: INSERT INTO igc_cc_interface (

99: l_full_path VARCHAR2(255);
100: BEGIN
101:
102: l_full_path := g_path || 'Insert_Interface_Row';
103: INSERT INTO igc_cc_interface (
104: batch_line_num,
105: cc_header_id,
106: cc_version_num,
107: cc_acct_line_id,

Line 147: /* Bug No : 6341012. SLA uptake. Event_ID, Project_Line are added to IGC_CC_INTERFACE Table */

143: reference_8,
144: reference_9,
145: reference_10,
146: cc_encmbrnc_date,
147: /* Bug No : 6341012. SLA uptake. Event_ID, Project_Line are added to IGC_CC_INTERFACE Table */
148: event_id,
149: project_line)
150: VALUES
151: (p_cc_interface_rec.batch_line_num,

Line 194: /* Bug No : 6341012. SLA uptake. Event_ID, Project_Line are added to IGC_CC_INTERFACE Table */

190: p_cc_interface_rec.reference_8,
191: p_cc_interface_rec.reference_9,
192: p_cc_interface_rec.reference_10,
193: p_cc_interface_rec.cc_encmbrnc_date,
194: /* Bug No : 6341012. SLA uptake. Event_ID, Project_Line are added to IGC_CC_INTERFACE Table */
195: p_cc_interface_rec.event_id,
196: p_cc_interface_rec.project_line);
197:
198:

Line 222: l_cc_interface_rec igc_cc_interface%ROWTYPE;

218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2)
220: IS
221:
222: l_cc_interface_rec igc_cc_interface%ROWTYPE;
223:
224: l_enc_amt NUMBER;
225: l_enc_tax_amt NUMBER;
226: l_msg_count NUMBER;

Line 512: DELETE igc_cc_interface

508:
509:
510: BEGIN
511:
512: DELETE igc_cc_interface
513: WHERE cc_header_id = p_cc_header_id AND
514: actual_flag = 'E';
515: EXCEPTION
516: WHEN OTHERS

Line 716: FROM igc_cc_interface

712: l_interface_row_count := 0;
713:
714: SELECT count(*)
715: INTO l_interface_row_count
716: FROM igc_cc_interface
717: WHERE cc_header_id = p_cc_header_id;
718:
719: SAVEPOINT Execute_Budgetary_Ctrl4;
720:

Line 2359: -- Bug 1914745, clear any old records from the igc_cc_interface table

2355: || ' *************************'
2356: );
2357: END IF;
2358:
2359: -- Bug 1914745, clear any old records from the igc_cc_interface table
2360: DELETE FROM igc_cc_interface
2361: WHERE TO_DATE (creation_date, 'DD/MM/YYYY') <=
2362: TO_DATE (SYSDATE, 'DD/MM/YYYY')
2363: - 2;

Line 2360: DELETE FROM igc_cc_interface

2356: );
2357: END IF;
2358:
2359: -- Bug 1914745, clear any old records from the igc_cc_interface table
2360: DELETE FROM igc_cc_interface
2361: WHERE TO_DATE (creation_date, 'DD/MM/YYYY') <=
2362: TO_DATE (SYSDATE, 'DD/MM/YYYY')
2363: - 2;
2364: