APPS.POR_TAX_PVT dependencies on ZX_TRX_HEADERS_GT

Line 66: -- delete from ZX_TRX_HEADERS_GT

62: l_log_msg := l_procedure_name||'(+)';
63: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
64: END IF;
65:
66: -- delete from ZX_TRX_HEADERS_GT
67: DELETE ZX_TRX_HEADERS_GT;
68:
69: l_progress := 100;
70:

Line 67: DELETE ZX_TRX_HEADERS_GT;

63: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
64: END IF;
65:
66: -- delete from ZX_TRX_HEADERS_GT
67: DELETE ZX_TRX_HEADERS_GT;
68:
69: l_progress := 100;
70:
71: -- Logging Infra: Statement level

Line 73: l_log_msg := 'Deleted ZX_TRX_HEADERS_GT';

69: l_progress := 100;
70:
71: -- Logging Infra: Statement level
72: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
73: l_log_msg := 'Deleted ZX_TRX_HEADERS_GT';
74: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
75: END IF;
76:
77: -- get legal entity id

Line 89: INSERT INTO ZX_TRX_HEADERS_GT (internal_organization_id,

85:
86: l_progress := 200;
87:
88: -- insert into ZX Headers global temp table
89: INSERT INTO ZX_TRX_HEADERS_GT (internal_organization_id,
90: icx_session_id,
91: application_id,
92: entity_code,
93: event_class_code,

Line 122: l_log_msg := 'Inserted into ZX_TRX_HEADERS_GT';

118: l_progress := 300;
119:
120: -- Logging Infra: Statement level
121: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
122: l_log_msg := 'Inserted into ZX_TRX_HEADERS_GT';
123: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
124: END IF;
125:
126: -- delete from ZX_TRANSACTION_LINES_GT

Line 531: FROM ZX_TRX_HEADERS_GT;

527:
528: CURSOR c_tax_head IS
529: SELECT default_taxation_country,
530: document_sub_type
531: FROM ZX_TRX_HEADERS_GT;
532:
533: CURSOR c_tax_line IS
534: SELECT TRX_LINE_ID,
535: INPUT_TAX_CLASSIFICATION_CODE,

Line 572: -- delete from ZX_TRX_HEADERS_GT

568: END IF;
569:
570: l_progress := 100;
571:
572: -- delete from ZX_TRX_HEADERS_GT
573: DELETE ZX_TRX_HEADERS_GT;
574:
575: l_progress := 200;
576:

Line 573: DELETE ZX_TRX_HEADERS_GT;

569:
570: l_progress := 100;
571:
572: -- delete from ZX_TRX_HEADERS_GT
573: DELETE ZX_TRX_HEADERS_GT;
574:
575: l_progress := 200;
576:
577: -- delete from ZX_TRANSACTION_LINES_GT

Line 597: l_log_msg := 'Inserting into ZX_TRX_HEADERS_GT';

593:
594: IF (i=1) THEN
595: -- Logging Infra: Statement level
596: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
597: l_log_msg := 'Inserting into ZX_TRX_HEADERS_GT';
598: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
599: END IF;
600:
601: -- insert into ZX Headers global temp table

Line 602: INSERT INTO ZX_TRX_HEADERS_GT (internal_organization_id,

598: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
599: END IF;
600:
601: -- insert into ZX Headers global temp table
602: INSERT INTO ZX_TRX_HEADERS_GT (internal_organization_id,
603: icx_session_id,
604: application_id,
605: entity_code,
606: event_class_code,