APPS.IGC_UPGRADE_DATA_R12 dependencies on IGC_CC_INTERFACE

Line 358: /*Update CBC result Codes into IGC_CBC_JE_LINES from IGC_CC_INTERFACE to print Exception Report*/

354: AND je_category = l_cbc_line.je_category
355: AND effective_date = l_cbc_line.effective_date
356: AND cbc_je_batch_id = l_cbc_line.cbc_je_batch_id;
357:
358: /*Update CBC result Codes into IGC_CBC_JE_LINES from IGC_CC_INTERFACE to print Exception Report*/
359:
360: UPDATE igc_cbc_je_lines ijl
361: SET (mig_result_code) = (SELECT cbc_result_code
362: FROM igc_cc_interface ict

Line 362: FROM igc_cc_interface ict

358: /*Update CBC result Codes into IGC_CBC_JE_LINES from IGC_CC_INTERFACE to print Exception Report*/
359:
360: UPDATE igc_cbc_je_lines ijl
361: SET (mig_result_code) = (SELECT cbc_result_code
362: FROM igc_cc_interface ict
363: WHERE ijl.reference_1 = ict.cc_header_id
364: AND ijl.effective_date = ict.cc_transaction_date
365: AND NVL(ijl.je_category, '') = NVL(ict.je_category_name, '')
366: AND ijl.code_combination_id = ict.code_combination_id)

Line 376: /*Entries in igc_cc_interface needs to be flushed as rerun of the CP may cause issues */

372: IF (g_debug_mode = 'Y') THEN
373: Put_Debug_Msg(l_full_path, 'Updating Result Code. Number of rows updated: ' || SQL%ROWCOUNT);
374: END IF;
375:
376: /*Entries in igc_cc_interface needs to be flushed as rerun of the CP may cause issues */
377: DELETE FROM igc_cc_interface
378: WHERE reference_8 = 'MIG';
379:
380: commit;

Line 377: DELETE FROM igc_cc_interface

373: Put_Debug_Msg(l_full_path, 'Updating Result Code. Number of rows updated: ' || SQL%ROWCOUNT);
374: END IF;
375:
376: /*Entries in igc_cc_interface needs to be flushed as rerun of the CP may cause issues */
377: DELETE FROM igc_cc_interface
378: WHERE reference_8 = 'MIG';
379:
380: commit;
381: END LOOP;

Line 457: INSERT INTO igc_cc_interface(

453: SELECT decode(l_cbc_je_lines.JE_SOURCE, 'Contract Commitment', 'CC', 'Project Accounting', 'PA', 'Requisitions', 'REQ', 'Purchasing', 'PO', 'INV')
454: INTO x_doc_type
455: FROM DUAL;
456:
457: INSERT INTO igc_cc_interface(
458: CC_HEADER_ID,
459: CC_VERSION_NUM,
460: CC_ACCT_LINE_ID,
461: CC_DET_PF_LINE_ID,

Line 558: UPDATE igc_cc_interface

554: IF (g_debug_mode = 'Y') THEN
555: Put_Debug_Msg(l_full_path, 'Reference 4: ' || l_reference_4);
556: END IF;
557:
558: UPDATE igc_cc_interface
559: SET reference_4 = l_reference_4
560: WHERE cc_header_id = p_cc_header_id;
561:
562: END LOOP;