APPS.POR_TAX_PVT dependencies on ZX_TRANSACTION_LINES_GT

Line 132: -- delete from ZX_TRANSACTION_LINES_GT

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
133: DELETE ZX_TRANSACTION_LINES_GT;
134:
135: l_progress := 400;
136:

Line 133: DELETE ZX_TRANSACTION_LINES_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
133: DELETE ZX_TRANSACTION_LINES_GT;
134:
135: l_progress := 400;
136:
137: -- Logging Infra: Statement level

Line 139: l_log_msg := 'Deleted from ZX_TRANSACTION_LINES_GT';

135: l_progress := 400;
136:
137: -- Logging Infra: Statement level
138: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
139: l_log_msg := 'Deleted from ZX_TRANSACTION_LINES_GT';
140: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
141: END IF;
142:
143: -- insert into ZX Lines global temp table

Line 168: INSERT INTO ZX_TRANSACTION_LINES_GT( application_id,

164: l_log_msg := 'ship_from_location_id: ' || ship_from_location_id;
165: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
166: END IF;
167:
168: INSERT INTO ZX_TRANSACTION_LINES_GT( application_id,
169: entity_code,
170: event_class_code,
171: trx_id,
172: trx_level_type,

Line 263: l_log_msg := 'Inserted record into ZX_TRANSACTION_LINES_GT.';

259: p_tax_line_tbl(i).user_override_flag);
260:
261: -- Logging Infra: Statement level
262: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
263: l_log_msg := 'Inserted record into ZX_TRANSACTION_LINES_GT.';
264: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
265: l_log_msg := '>>> LineId=' || p_tax_line_tbl(i).trx_line_id || '; OverrideFlag=' || p_tax_line_tbl(i).user_override_flag;
266: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
267: END IF;

Line 542: FROM ZX_TRANSACTION_LINES_GT;

538: USER_DEFINED_FISC_CLASS,
539: ASSESSABLE_VALUE,
540: PRODUCT_CATEGORY,
541: USER_UPD_DET_FACTORS_FLAG
542: FROM ZX_TRANSACTION_LINES_GT;
543:
544: BEGIN
545:
546: l_progress := 0;

Line 575: -- delete from ZX_TRANSACTION_LINES_GT

571: DELETE ZX_TRX_HEADERS_GT;
572:
573: l_progress := 200;
574:
575: -- delete from ZX_TRANSACTION_LINES_GT
576: DELETE ZX_TRANSACTION_LINES_GT;
577:
578: l_progress := 300;
579:

Line 576: DELETE ZX_TRANSACTION_LINES_GT;

572:
573: l_progress := 200;
574:
575: -- delete from ZX_TRANSACTION_LINES_GT
576: DELETE ZX_TRANSACTION_LINES_GT;
577:
578: l_progress := 300;
579:
580: -- insert into ZX Lines global temp table

Line 633: l_log_msg := 'Inserting into ZX_TRANSACTION_LINES_GT';

629:
630:
631: -- Logging Infra: Statement level
632: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
633: l_log_msg := 'Inserting into ZX_TRANSACTION_LINES_GT';
634: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
635: l_log_msg := '--> Defaulting attribute is ship_to_loc_org_id=' || p_tax_line_tbl(i).product_org_id;
636: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
637: END IF;

Line 658: INSERT INTO ZX_TRANSACTION_LINES_GT(application_id,

654: l_log_msg := 'ship_from_location_id: ' || ship_from_location_id;
655: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
656: END IF;
657:
658: INSERT INTO ZX_TRANSACTION_LINES_GT(application_id,
659: entity_code,
660: event_class_code,
661: trx_id,
662: trx_level_type,