DBA Data[Home] [Help]

APPS.ZX_SIM_TRX_DISTRIBUTION dependencies on ZX_TRX_HEADERS_GT

Line 1874: DELETE ZX_TRX_HEADERS_GT

1870: 'ZX_SIM_TRX_DISTRIBUTION: Insert_Temporary_Table (+)');
1871:
1872: END IF;
1873:
1874: DELETE ZX_TRX_HEADERS_GT
1875: WHERE APPLICATION_ID = p_application_id
1876: AND ENTITY_CODE = p_entity_code
1877: AND EVENT_CLASS_CODE = p_event_class_code
1878: AND TRX_ID = p_trx_id;

Line 1883: 'Insert into zx_trx_headers_gt (+)');

1879:
1880: IF (g_level_procedure >= g_current_runtime_level ) THEN
1881: FND_LOG.STRING(g_level_procedure,
1882: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Tables',
1883: 'Insert into zx_trx_headers_gt (+)');
1884: END IF;
1885:
1886: INSERT INTO ZX_TRX_HEADERS_GT (INTERNAL_ORGANIZATION_ID,
1887: INTERNAL_ORG_LOCATION_ID,

Line 1886: INSERT INTO ZX_TRX_HEADERS_GT (INTERNAL_ORGANIZATION_ID,

1882: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Tables',
1883: 'Insert into zx_trx_headers_gt (+)');
1884: END IF;
1885:
1886: INSERT INTO ZX_TRX_HEADERS_GT (INTERNAL_ORGANIZATION_ID,
1887: INTERNAL_ORG_LOCATION_ID,
1888: APPLICATION_ID,
1889: ENTITY_CODE,
1890: EVENT_CLASS_CODE,

Line 2066: 'Insert into zx_trx_headers_gt (-)');

2062:
2063: IF (g_level_procedure >= g_current_runtime_level ) THEN
2064: FND_LOG.STRING(g_level_procedure,
2065: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2066: 'Insert into zx_trx_headers_gt (-)');
2067: END IF;
2068:
2069: IF (g_level_procedure >= g_current_runtime_level ) THEN
2070: FND_LOG.STRING(g_level_procedure,

Line 2479: 'Insert into zx_trx_headers_gt (+)');

2475:
2476: IF (g_level_procedure >= g_current_runtime_level ) THEN
2477: FND_LOG.STRING(g_level_procedure,
2478: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Tables',
2479: 'Insert into zx_trx_headers_gt (+)');
2480: END IF;
2481:
2482: INSERT INTO ZX_TRX_HEADERS_GT (INTERNAL_ORGANIZATION_ID,
2483: INTERNAL_ORG_LOCATION_ID,

Line 2482: INSERT INTO ZX_TRX_HEADERS_GT (INTERNAL_ORGANIZATION_ID,

2478: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Tables',
2479: 'Insert into zx_trx_headers_gt (+)');
2480: END IF;
2481:
2482: INSERT INTO ZX_TRX_HEADERS_GT (INTERNAL_ORGANIZATION_ID,
2483: INTERNAL_ORG_LOCATION_ID,
2484: APPLICATION_ID,
2485: ENTITY_CODE,
2486: EVENT_CLASS_CODE,

Line 2662: 'Insert into zx_trx_headers_gt (-)');

2658:
2659: IF (g_level_procedure >= g_current_runtime_level ) THEN
2660: FND_LOG.STRING(g_level_procedure,
2661: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2662: 'Insert into zx_trx_headers_gt (-)');
2663: END IF;
2664:
2665: IF (g_level_procedure >= g_current_runtime_level ) THEN
2666: FND_LOG.STRING(g_level_procedure,