DBA Data[Home] [Help]

APPS.IGC_ETAX_UTIL_PKG dependencies on ZX_ITM_DISTRIBUTIONS_GT

Line 556: /* First Delete from zx_itm_distributions_gt table */

552: l_return_status VARCHAR2(32) := FND_API.G_RET_STS_SUCCESS;
553: l_debug_info VARCHAR2(240);
554: BEGIN
555:
556: /* First Delete from zx_itm_distributions_gt table */
557: l_calling_sequence := 'IGC_ETAX_UTIL_PKG.Populate_Dist_GT';
558: IF (g_debug_mode = 'Y') THEN
559: Put_Debug_Msg (l_full_path,p_debug_msg => 'Deleting records from zx_itm_distributions_gt table');
560: END IF;

Line 559: Put_Debug_Msg (l_full_path,p_debug_msg => 'Deleting records from zx_itm_distributions_gt table');

555:
556: /* First Delete from zx_itm_distributions_gt table */
557: l_calling_sequence := 'IGC_ETAX_UTIL_PKG.Populate_Dist_GT';
558: IF (g_debug_mode = 'Y') THEN
559: Put_Debug_Msg (l_full_path,p_debug_msg => 'Deleting records from zx_itm_distributions_gt table');
560: END IF;
561:
562: DELETE FROM zx_itm_distributions_gt
563: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID

Line 562: DELETE FROM zx_itm_distributions_gt

558: IF (g_debug_mode = 'Y') THEN
559: Put_Debug_Msg (l_full_path,p_debug_msg => 'Deleting records from zx_itm_distributions_gt table');
560: END IF;
561:
562: DELETE FROM zx_itm_distributions_gt
563: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
564: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE
565: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE
566: AND trx_id = P_CC_Header_Rec.cc_header_id

Line 570: Put_Debug_Msg (l_full_path,p_debug_msg => 'Deletion from zx_itm_distributions_gt complete');

566: AND trx_id = P_CC_Header_Rec.cc_header_id
567: AND TRX_LEVEL_TYPE = IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE ;
568:
569: IF (g_debug_mode = 'Y') THEN
570: Put_Debug_Msg (l_full_path,p_debug_msg => 'Deletion from zx_itm_distributions_gt complete');
571: Put_Debug_Msg (l_full_path,p_debug_msg => 'Calling insert into zx_itm_distributions_gt');
572: END IF;
573:
574: FOR l_cc_lines IN c_Acct_Lines (P_Line_Id)

Line 571: Put_Debug_Msg (l_full_path,p_debug_msg => 'Calling insert into zx_itm_distributions_gt');

567: AND TRX_LEVEL_TYPE = IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE ;
568:
569: IF (g_debug_mode = 'Y') THEN
570: Put_Debug_Msg (l_full_path,p_debug_msg => 'Deletion from zx_itm_distributions_gt complete');
571: Put_Debug_Msg (l_full_path,p_debug_msg => 'Calling insert into zx_itm_distributions_gt');
572: END IF;
573:
574: FOR l_cc_lines IN c_Acct_Lines (P_Line_Id)
575: LOOP

Line 576: INSERT INTO zx_itm_distributions_gt(

572: END IF;
573:
574: FOR l_cc_lines IN c_Acct_Lines (P_Line_Id)
575: LOOP
576: INSERT INTO zx_itm_distributions_gt(
577: application_id
578: ,entity_code
579: ,event_class_code
580: ,trx_id

Line 628: Put_Debug_Msg (l_full_path,p_debug_msg => 'Insert into zx_itm_distributions_gt complete');

624: );
625: END LOOP;
626:
627: IF (g_debug_mode = 'Y') THEN
628: Put_Debug_Msg (l_full_path,p_debug_msg => 'Insert into zx_itm_distributions_gt complete');
629: END IF;
630: RETURN l_return_status;
631: EXCEPTION
632: WHEN OTHERS THEN