[Home] [Help]
439: NULL MERCHANT_PARTY_REFERENCE,
440: NULL MERCHANT_PARTY_TAXPAYER_ID,
441: NULL MERCHANT_PARTY_TAX_REG_NUMBER,
442: NULL ASSET_NUMBER
443: FROM ZX_TRANSACTION_LINES
444: WHERE APPLICATION_ID = p_application_id
445: AND ENTITY_CODE = p_entity_code
446: AND EVENT_CLASS_CODE = p_event_class_code
447: AND TRX_ID = p_trx_id
556: --
557: -- bug#5208939
558: -- update line_level_action in trx line to 'UPDATE'
559: --
560: UPDATE ZX_TRANSACTION_LINES
561: SET line_level_action = 'UPDATE'
562: WHERE APPLICATION_ID = p_application_id
563: AND ENTITY_CODE = p_entity_code
564: AND EVENT_CLASS_CODE = p_event_class_code
822:
823: IF (g_level_procedure >= g_current_runtime_level ) THEN
824: FND_LOG.STRING(g_level_procedure,
825: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Temporary_Table',
826: 'Insert into ZX_TRANSACTION_LINES_GT (+)');
827: END IF;
828:
829: INSERT INTO ZX_TRANSACTION_LINES_GT (APPLICATION_ID,
830: ENTITY_CODE,
825: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Temporary_Table',
826: 'Insert into ZX_TRANSACTION_LINES_GT (+)');
827: END IF;
828:
829: INSERT INTO ZX_TRANSACTION_LINES_GT (APPLICATION_ID,
830: ENTITY_CODE,
831: EVENT_CLASS_CODE,
832: TRX_ID,
833: TRX_LEVEL_TYPE,
1188: --p_merchant_party_tax_prof_id,
1189: line_amt_includes_tax_flag,
1190: historical_flag
1191: --p_tax_classification_code
1192: FROM ZX_TRANSACTION_LINES
1193: WHERE APPLICATION_ID = p_application_id
1194: AND ENTITY_CODE = p_entity_code
1195: AND EVENT_CLASS_CODE = p_event_class_code
1196: AND TRX_ID = p_trx_id
1257: NULL, --MERCHANT_PARTY_REFERENCE,
1258: NULL, --MERCHANT_PARTY_TAXPAYER_ID,
1259: NULL, --MERCHANT_PARTY_TAX_REG_NUMBER,
1260: NULL --ASSET_NUMBER
1261: FROM ZX_TRANSACTION_LINES
1262: WHERE APPLICATION_ID = p_application_id
1263: AND ENTITY_CODE = p_entity_code
1264: AND EVENT_CLASS_CODE = p_event_class_code
1265: AND TRX_ID = p_trx_id