DBA Data[Home] [Help]

APPS.ZX_SIM_TRX_DISTRIBUTION dependencies on ZX_SIM_TRX_DISTS

Line 183: 'Insert into ZX_SIM_TRX_DISTS (+)');

179: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row.BEGIN',
180: 'ZX_SIM_TRX_DISTRIBUTION: Insert_Row (+)');
181: FND_LOG.STRING(g_level_procedure,
182: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row',
183: 'Insert into ZX_SIM_TRX_DISTS (+)');
184: END IF;
185:
186: INSERT INTO ZX_SIM_TRX_DISTS (APPLICATION_ID,
187: ENTITY_CODE,

Line 186: INSERT INTO ZX_SIM_TRX_DISTS (APPLICATION_ID,

182: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row',
183: 'Insert into ZX_SIM_TRX_DISTS (+)');
184: END IF;
185:
186: INSERT INTO ZX_SIM_TRX_DISTS (APPLICATION_ID,
187: ENTITY_CODE,
188: EVENT_CLASS_CODE,
189: --EVENT_TYPE_CODE,
190: TRX_ID,

Line 492: 'Insert into ZX_SIM_TRX_DISTS (-)');

488:
489: IF (g_level_procedure >= g_current_runtime_level ) THEN
490: FND_LOG.STRING(g_level_procedure,
491: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row',
492: 'Insert into ZX_SIM_TRX_DISTS (-)');
493: FND_LOG.STRING(g_level_procedure,
494: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row.END',
495: 'ZX_SIM_TRX_DISTRIBUTION: Insert_Row (-)');
496: END IF;

Line 667: 'Update ZX_SIM_TRX_DISTS (+)');

663: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row.BEGIN',
664: 'ZX_SIM_TRX_DISTRIBUTION: Update_Row (+)');
665: FND_LOG.STRING(g_level_procedure,
666: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row',
667: 'Update ZX_SIM_TRX_DISTS (+)');
668: END IF;
669:
670: /*****************
671: UPDATE ZX_TRANSACTION

Line 681: UPDATE ZX_SIM_TRX_DISTS

677: AND EVENT_TYPE_CODE = 'STANDARD UPDATED';
678:
679: **************/
680:
681: UPDATE ZX_SIM_TRX_DISTS
682: SET APPLICATION_ID = p_application_id,
683: ENTITY_CODE = p_entity_code,
684: EVENT_CLASS_CODE = p_event_class_code,
685: --EVENT_TYPE_CODE = p_event_type_code,

Line 844: 'Update ZX_SIM_TRX_DISTS (-)');

840:
841: IF (g_level_procedure >= g_current_runtime_level ) THEN
842: FND_LOG.STRING(g_level_procedure,
843: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row',
844: 'Update ZX_SIM_TRX_DISTS (-)');
845: FND_LOG.STRING(g_level_procedure,
846: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row.END',
847: 'ZX_SIM_TRX_DISTRIBUTION: Update_Row (-)');
848: END IF;

Line 1340: FROM ZX_SIM_TRX_DISTS

1336: CREATION_DATE,
1337: LAST_UPDATED_BY,
1338: LAST_UPDATE_DATE,
1339: LAST_UPDATE_LOGIN
1340: FROM ZX_SIM_TRX_DISTS
1341: WHERE APPLICATION_ID = p_application_id
1342: AND ENTITY_CODE = p_entity_code
1343: AND EVENT_CLASS_CODE = p_event_class_code
1344: AND TRX_LINE_ID = p_trx_line_id

Line 2365: FROM ZX_SIM_TRX_DISTS

2361: APPLIED_FROM_TRX_LEVEL_TYPE,
2362: ADJUSTED_DOC_TRX_LEVEL_TYPE,
2363: OVERRIDING_RECOVERY_RATE,
2364: tax_variance_calc_flag
2365: FROM ZX_SIM_TRX_DISTS
2366: WHERE APPLICATION_ID = p_application_id
2367: AND ENTITY_CODE = p_entity_code
2368: AND EVENT_CLASS_CODE = p_event_class_code
2369: AND TRX_ID = p_trx_id

Line 2961: FROM ZX_SIM_TRX_DISTS

2957: APPLIED_FROM_TRX_LEVEL_TYPE,
2958: ADJUSTED_DOC_TRX_LEVEL_TYPE,
2959: OVERRIDING_RECOVERY_RATE,
2960: tax_variance_calc_flag
2961: FROM ZX_SIM_TRX_DISTS
2962: WHERE APPLICATION_ID = p_application_id
2963: AND ENTITY_CODE = p_entity_code
2964: AND EVENT_CLASS_CODE = p_event_class_code
2965: AND TRX_ID = p_trx_id;