[Home] [Help]
94: p_error_buffer VARCHAR2(100);
95:
96: CURSOR C IS
97: SELECT rowid
98: FROM zx_transaction
99: WHERE APPLICATION_ID = p_application_id
100: AND ENTITY_CODE = p_entity_code
101: AND EVENT_CLASS_CODE = p_event_class_code
102: AND TRX_ID = p_trx_id;
109: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row.BEGIN',
110: 'ZX_TRX_MASTER: Insert_Row (+)');
111: FND_LOG.STRING(g_level_procedure,
112: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row',
113: 'Insert into ZX_TRANSACTION (+)');
114: END IF;
115:
116: INSERT INTO ZX_TRANSACTION (FIRST_PTY_ORG_ID,
117: INTERNAL_ORGANIZATION_ID,
112: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row',
113: 'Insert into ZX_TRANSACTION (+)');
114: END IF;
115:
116: INSERT INTO ZX_TRANSACTION (FIRST_PTY_ORG_ID,
117: INTERNAL_ORGANIZATION_ID,
118: INTERNAL_ORG_LOCATION_ID,
119: APPLICATION_ID,
120: ENTITY_CODE,
286:
287: IF (g_level_procedure >= g_current_runtime_level ) THEN
288: FND_LOG.STRING(g_level_procedure,
289: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row',
290: 'Insert into ZX_TRANSACTION (-)');
291: FND_LOG.STRING(g_level_procedure,
292: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row',
293: 'Insert into ZX_SIM_PURGE (+)');
294: END IF;
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
457: 'ZX.PLSQL.ZX_TRX_MASTER.update_Row.BEGIN',
458: 'ZX_TRX_MASTER: update_Row (+)');
459: FND_LOG.STRING(g_level_procedure,
460: 'ZX.PLSQL.ZX_TRX_MASTER.update_Row',
461: 'Update into ZX_TRANSACTION (+)');
462: END IF;
463:
464: UPDATE ZX_TRANSACTION
465: SET EVENT_TYPE_CODE = p_event_type_code,
460: 'ZX.PLSQL.ZX_TRX_MASTER.update_Row',
461: 'Update into ZX_TRANSACTION (+)');
462: END IF;
463:
464: UPDATE ZX_TRANSACTION
465: SET EVENT_TYPE_CODE = p_event_type_code,
466: TRX_DATE = p_trx_date,
467: DOCUMENT_EVENT_TYPE = p_document_event_type,
468: TRX_CURRENCY_CODE = p_trx_currency_code,
539:
540: IF (g_level_procedure >= g_current_runtime_level ) THEN
541: FND_LOG.STRING(g_level_procedure,
542: 'ZX.PLSQL.ZX_TRX_MASTER.Update_Row',
543: 'Update into ZX_TRANSACTION (-)');
544: END IF;
545:
546: IF (g_level_procedure >= g_current_runtime_level ) THEN
547: FND_LOG.STRING(g_level_procedure,
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
596: x_msg_data => l_msg_data);
597:
598: ELSIF p_document_event_type = 'VALIDATE' THEN
599:
600: INSERT INTO ZX_TRANSACTIONS_GT (APPLICATION_ID,
601: ENTITY_CODE,
602: EVENT_CLASS_CODE,
603: EVENT_TYPE_CODE,
604: TRX_ID,
807: --p_rdng_ship_to_pty_tx_p_st_id,
808: --p_rdng_ship_fr_pty_tx_p_st_id, --reduced size p_rdng_ship_from_pty_tx_p_st_id
809: --p_rdng_bill_to_pty_tx_p_st_id,
810: --p_rdng_bill_fr_pty_tx_p_st_id); --reduced size p_rdng_bill_from_pty_tx_p_st_id
811: FROM ZX_TRANSACTION
812: WHERE APPLICATION_ID = p_application_id
813: AND ENTITY_CODE = p_entity_code
814: AND EVENT_CLASS_CODE = p_event_class_code
815: AND TRX_ID = p_trx_id;
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
1446: 'ZX.PLSQL.ZX_TRX_MASTER.Delete_Row.BEGIN',
1447: 'ZX_TRX_MASTER: Delete_Row (+)');
1448: FND_LOG.STRING(g_level_procedure,
1449: 'ZX.PLSQL.ZX_TRX_MASTER.Delete_Row',
1450: 'Update for DELETE in ZX_TRANSACTION (+)');
1451: END IF;
1452:
1453: UPDATE ZX_TRANSACTION
1454: SET EVENT_TYPE_CODE = p_event_type_code,
1449: 'ZX.PLSQL.ZX_TRX_MASTER.Delete_Row',
1450: 'Update for DELETE in ZX_TRANSACTION (+)');
1451: END IF;
1452:
1453: UPDATE ZX_TRANSACTION
1454: SET EVENT_TYPE_CODE = p_event_type_code,
1455: TRX_DATE = p_trx_date,
1456: TRX_CURRENCY_CODE = p_trx_currency_code,
1457: CURRENCY_CONVERSION_DATE = p_currency_conversion_date,
1523:
1524: IF (g_level_procedure >= g_current_runtime_level ) THEN
1525: FND_LOG.STRING(g_level_procedure,
1526: 'ZX.PLSQL.ZX_TRX_MASTER.Delete_Row',
1527: 'Update for DELETE in ZX_TRANSACTION (-)');
1528: FND_LOG.STRING(g_level_procedure,
1529: 'ZX.PLSQL.ZX_TRX_MASTER.Delete_Row.END',
1530: 'ZX_TRX_MASTER: Delete_Row (-)');
1531: END IF;
1696: CREATION_DATE,
1697: LAST_UPDATED_BY,
1698: LAST_UPDATE_DATE,
1699: LAST_UPDATE_LOGIN
1700: FROM ZX_TRANSACTION
1701: WHERE APPLICATION_ID = p_application_id
1702: AND ENTITY_CODE = p_entity_code
1703: AND EVENT_CLASS_CODE = p_event_class_code
1704: AND TRX_ID = p_trx_id