APPS.POR_TAX_PVT dependencies on ZX_TRX_HEADERS_GT

Line 72: -- delete from ZX_TRX_HEADERS_GT

68: l_log_msg := l_procedure_name||'(+)';
69: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
70: END IF;
71:
72: -- delete from ZX_TRX_HEADERS_GT
73: DELETE ZX_TRX_HEADERS_GT;
74:
75: l_progress := 100;
76:

Line 73: DELETE ZX_TRX_HEADERS_GT;

69: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
70: END IF;
71:
72: -- delete from ZX_TRX_HEADERS_GT
73: DELETE ZX_TRX_HEADERS_GT;
74:
75: l_progress := 100;
76:
77: -- Logging Infra: Statement level

Line 79: l_log_msg := 'Deleted ZX_TRX_HEADERS_GT';

75: l_progress := 100;
76:
77: -- Logging Infra: Statement level
78: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
79: l_log_msg := 'Deleted ZX_TRX_HEADERS_GT';
80: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
81: END IF;
82:
83: -- get legal entity id

Line 95: INSERT INTO ZX_TRX_HEADERS_GT (internal_organization_id,

91:
92: l_progress := 200;
93:
94: -- insert into ZX Headers global temp table
95: INSERT INTO ZX_TRX_HEADERS_GT (internal_organization_id,
96: icx_session_id,
97: application_id,
98: entity_code,
99: event_class_code,

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

124: l_progress := 300;
125:
126: -- Logging Infra: Statement level
127: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
128: l_log_msg := 'Inserted into ZX_TRX_HEADERS_GT';
129: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
130: END IF;
131:
132: -- delete from ZX_TRANSACTION_LINES_GT

Line 529: FROM ZX_TRX_HEADERS_GT;

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

Line 570: -- delete from ZX_TRX_HEADERS_GT

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

Line 571: DELETE ZX_TRX_HEADERS_GT;

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

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

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

Line 600: INSERT INTO ZX_TRX_HEADERS_GT (internal_organization_id,

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