DBA Data[Home] [Help]

APPS.POR_TAX_PVT dependencies on ZX_TRANSACTION_LINES_GT

Line 126: -- delete from ZX_TRANSACTION_LINES_GT

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
127: DELETE ZX_TRANSACTION_LINES_GT;
128:
129: l_progress := 400;
130:

Line 127: DELETE ZX_TRANSACTION_LINES_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
127: DELETE ZX_TRANSACTION_LINES_GT;
128:
129: l_progress := 400;
130:
131: -- Logging Infra: Statement level

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

129: l_progress := 400;
130:
131: -- Logging Infra: Statement level
132: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
133: l_log_msg := 'Deleted from ZX_TRANSACTION_LINES_GT';
134: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
135: END IF;
136:
137: -- insert into ZX Lines global temp table

Line 163: INSERT INTO ZX_TRANSACTION_LINES_GT( application_id,

159: j := j+1;
160: EXIT WHEN j > tbl_sz_dist;
161: END LOOP ;
162:
163: INSERT INTO ZX_TRANSACTION_LINES_GT( application_id,
164: entity_code,
165: event_class_code,
166: trx_id,
167: trx_level_type,

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

265: );
266:
267: -- Logging Infra: Statement level
268: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
269: l_log_msg := 'Inserted record into ZX_TRANSACTION_LINES_GT.';
270: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
271: l_log_msg := '>>> LineId=' || p_tax_line_tbl(i).trx_line_id || '; OverrideFlag=' || p_tax_line_tbl(i).user_override_flag;
272: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
273: END IF;

Line 544: FROM ZX_TRANSACTION_LINES_GT;

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

Line 577: -- delete from ZX_TRANSACTION_LINES_GT

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

Line 578: DELETE ZX_TRANSACTION_LINES_GT;

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

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

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

Line 669: INSERT INTO ZX_TRANSACTION_LINES_GT(application_id,

665: END IF;
666:
667: --- bug 13024005 end
668:
669: INSERT INTO ZX_TRANSACTION_LINES_GT(application_id,
670: entity_code,
671: event_class_code,
672: trx_id,
673: trx_level_type,