DBA Data[Home] [Help]

APPS.IGC_ETAX_UTIL_PKG dependencies on ZX_TRX_HEADERS_GT

Line 136: DELETE FROM zx_trx_headers_gt

132: FROM fnd_currencies
133: WHERE currency_code = l_ledger_currency;
134:
135:
136: DELETE FROM zx_trx_headers_gt
137: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
138: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE
139: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE
140: AND trx_id = P_CC_Header_Rec.cc_header_id;

Line 147: INSERT INTO zx_trx_headers_gt(

143: l_rounding_bill_to_party_id := P_CC_Header_Rec.org_id;
144: END IF;
145:
146:
147: INSERT INTO zx_trx_headers_gt(
148: internal_organization_id,
149: internal_org_location_id,
150: application_id,
151: entity_code,

Line 313: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_trx_headers_gt values ');

309: FND_GLOBAL.session_id --icx_session_id
310: );
311:
312: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
313: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_trx_headers_gt values ');
314: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Application_id: '|| IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID);
315: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Entity_code: ' || IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE);
316: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Event_class_code: ' || IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE);
317: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Event_type_code: ' || IGC_ETAX_UTIL_PKG.IGC_EVENT_TYPE_CODE);

Line 776: /* Update zx_trx_headers_gt to set event code to "DISTRIBUTED" */

772: end if;
773:
774: /* Bug#6719456 start */
775:
776: /* Update zx_trx_headers_gt to set event code to "DISTRIBUTED" */
777: UPDATE zx_trx_headers_gt
778: set event_type_code = 'DISTRIBUTED'
779: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
780: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE

Line 777: UPDATE zx_trx_headers_gt

773:
774: /* Bug#6719456 start */
775:
776: /* Update zx_trx_headers_gt to set event code to "DISTRIBUTED" */
777: UPDATE zx_trx_headers_gt
778: set event_type_code = 'DISTRIBUTED'
779: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
780: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE
781: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE