eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_TRX_LINE_APP_REGIMES

Line 34: -- then applicable regimes may not have been populated in ZX_TRX_LINE_APP_REGIMES.

30: -- get_migrated_doc_info
31: --
32: -- DESCRIPTION
33: -- If the source document is migrated for an incoming adjusted document,
34: -- then applicable regimes may not have been populated in ZX_TRX_LINE_APP_REGIMES.
35: -- In this scenario, return the standard regime to be populated in
36: -- ZX_TRX_LINE_APP_REGIMES.
37: --
38: -- CALLED BY

Line 36: -- ZX_TRX_LINE_APP_REGIMES.

32: -- DESCRIPTION
33: -- If the source document is migrated for an incoming adjusted document,
34: -- then applicable regimes may not have been populated in ZX_TRX_LINE_APP_REGIMES.
35: -- In this scenario, return the standard regime to be populated in
36: -- ZX_TRX_LINE_APP_REGIMES.
37: --
38: -- CALLED BY
39: -- popl_pvrdr_info_tax_reg_tbl
40: -----------------------------------------------------------------------

Line 184: -- table ZX_TRX_LINE_APP_REGIMES

180: --
181: -- DESCRIPTION
182: -- This procedure temporarily copies all applicable regimes for a line
183: -- into trx_line_app_regimes_tbl structure before bulk inserting into db
184: -- table ZX_TRX_LINE_APP_REGIMES
185: --
186: -- CALLED BY
187: -- popl_pvrdr_info_tax_reg_tbl
188: -----------------------------------------------------------------------

Line 208: /* Storing of eBTax regimes in zx_trx_line_app_regimes table is expensive from performance and storage perspective

204:
205: /*Set the return status to Success */
206: x_return_status := FND_API.G_RET_STS_SUCCESS;
207:
208: /* Storing of eBTax regimes in zx_trx_line_app_regimes table is expensive from performance and storage perspective
209: By not storing these regimes, we will not be able to handle scenario of eBTax to tax provider switch scenario */
210:
211: IF p_tax_provider_id IS NOT NULL THEN
212: l_count :=ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.application_id.COUNT+1 ;

Line 717: -- This is a table handler on ZX_TRX_LINE_APP_REGIMES

713: -- PUBLIC PROCEDURE
714: -- trx_line_app_regimes_tbl_hdl
715: --
716: -- DESCRIPTION
717: -- This is a table handler on ZX_TRX_LINE_APP_REGIMES
718: --
719: -- Argument of interest
720: -- p_event - takes following values
721: -- INSERT inserts at end of post calculation

Line 776: FROM zx_trx_line_app_regimes

772:
773: BEGIN
774: SELECT 1
775: INTO l_dummy
776: FROM zx_trx_line_app_regimes
777: WHERE application_id = p_event_class_rec.application_id
778: AND entity_code = p_event_class_rec.entity_code
779: AND event_class_code = p_event_class_rec.event_class_code
780: AND trx_id = p_event_class_rec.trx_id

Line 787: INSERT INTO ZX_TRX_LINE_APP_REGIMES(APPLICATION_ID,

783: AND tax_regime_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.tax_regime_code(i);
784: EXCEPTION
785: WHEN OTHERS THEN
786: BEGIN
787: INSERT INTO ZX_TRX_LINE_APP_REGIMES(APPLICATION_ID,
788: ENTITY_CODE,
789: EVENT_CLASS_CODE,
790: TRX_ID,
791: TRX_LINE_ID,

Line 832: DELETE from ZX_TRX_LINE_APP_REGIMES

828: END;
829: END IF;
830: END LOOP;
831: ELSIF p_event = 'DELETE' THEN
832: DELETE from ZX_TRX_LINE_APP_REGIMES
833: WHERE application_id = p_event_class_rec.application_id
834: AND entity_code = p_event_class_rec.entity_code
835: AND event_class_code = p_event_class_rec.event_class_code
836: AND trx_id = p_event_class_rec.trx_id

Line 840: UPDATE zx_trx_line_app_regimes

836: AND trx_id = p_event_class_rec.trx_id
837: AND tax_provider_id = p_provider_id
838: AND tax_regime_code = p_tax_regime_code;
839: ELSIF p_event = 'SET_FLAG' THEN
840: UPDATE zx_trx_line_app_regimes
841: SET update_flag ='Y'
842: WHERE application_id = p_event_class_rec.application_id
843: AND entity_code = p_event_class_rec.entity_code
844: AND event_class_code = p_event_class_rec.event_class_code

Line 849: UPDATE zx_trx_line_app_regimes

845: AND trx_id = p_event_class_rec.trx_id
846: AND trx_line_id = p_trx_line_id
847: AND trx_level_type = p_trx_level_type;
848: ELSIF p_event = 'RESET_FLAG' THEN
849: UPDATE zx_trx_line_app_regimes
850: SET update_flag = null
851: WHERE application_id = p_event_class_rec.application_id
852: AND entity_code = p_event_class_rec.entity_code
853: AND event_class_code = p_event_class_rec.event_class_code

Line 917: FROM ZX_TRX_LINE_APP_REGIMES ztlar

913: ztlar.tax_provider_id,
914: regimes.effective_from,
915: regimes.effective_to,
916: regimes.country_code
917: FROM ZX_TRX_LINE_APP_REGIMES ztlar
918: , zx_regimes_b regimes
919: WHERE ztlar.application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(l_index)
920: AND ztlar.entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(l_index)
921: AND ztlar.event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(l_index)

Line 934: FROM ZX_TRX_LINE_APP_REGIMES ztlar

930: ztlar.tax_provider_id,
931: regimes.effective_from,
932: regimes.effective_to,
933: regimes.country_code
934: FROM ZX_TRX_LINE_APP_REGIMES ztlar
935: , zx_regimes_b regimes
936: WHERE ztlar.application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(l_index)
937: AND ztlar.entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(l_index)
938: AND ztlar.event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(l_index)

Line 964: -- For these lines, fetch the applicable regimes from ZX_TRX_LINE_APP_REGIMES and

960:
961: --ZX_TDS_CALC_SERVICES_PUB_PKG.get_tax_regimes does not return any regimes for the transaction lines in the following conditions.
962: -- applied_from_application_id is not null
963: -- adjusted_doc_application_id is not null
964: -- For these lines, fetch the applicable regimes from ZX_TRX_LINE_APP_REGIMES and
965: -- Populate ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl if regime does not already exist
966:
967: --If applied from document
968:

Line 1038: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' APPLIED_FROM_DOCUMENT :not migrated- retrieve the applicable regimes from zx_trx_line_app_regimes for original transaction');

1034: RETURN;
1035: END IF;
1036: ELSIF l_ptnr_migrated_flag ='N' THEN
1037: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1038: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' APPLIED_FROM_DOCUMENT :not migrated- retrieve the applicable regimes from zx_trx_line_app_regimes for original transaction');
1039: END IF;
1040: FOR app_docs IN app_doc_regime_csr(p_trx_line_index) LOOP
1041: IF NOT ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl.EXISTS(app_docs.tax_regime_id) THEN
1042: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(app_docs.tax_regime_id).tax_regime_id :=app_docs.tax_regime_id;

Line 1207: --Call routine to populate all applicable regimes for line in ZX_TRX_LINE_APP_REGIMES

1203: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(l_tax_regime_id).partner_processing_flag := 'C';
1204: END IF;
1205:
1206: --Populate the table for all regimes applicable to transaction line
1207: --Call routine to populate all applicable regimes for line in ZX_TRX_LINE_APP_REGIMES
1208: popl_all_regimes_tbl (p_event_class_rec,
1209: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index),
1210: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index),
1211: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(l_tax_regime_id).tax_regime_id,

Line 2399: --Call routine to bulk insert all Applicable regimes for line in db table ZX_TRX_LINE_APP_REGIMES

2395: l_tax_class := 'INPUT';
2396: END IF;
2397:
2398: IF NVL(l_ptnr_calc_flag,'Y') = 'Y' THEN
2399: --Call routine to bulk insert all Applicable regimes for line in db table ZX_TRX_LINE_APP_REGIMES
2400: --Insert into zx_trx_line_app_regimes(Point 5 in DLD)
2401: trx_line_app_regimes_tbl_hdl(p_event_class_rec => p_event_class_rec,
2402: p_event => 'INSERT',
2403: p_provider_id => null,

Line 2400: --Insert into zx_trx_line_app_regimes(Point 5 in DLD)

2396: END IF;
2397:
2398: IF NVL(l_ptnr_calc_flag,'Y') = 'Y' THEN
2399: --Call routine to bulk insert all Applicable regimes for line in db table ZX_TRX_LINE_APP_REGIMES
2400: --Insert into zx_trx_line_app_regimes(Point 5 in DLD)
2401: trx_line_app_regimes_tbl_hdl(p_event_class_rec => p_event_class_rec,
2402: p_event => 'INSERT',
2403: p_provider_id => null,
2404: p_tax_regime_code => null,

Line 2558: FROM ZX_TRX_LINE_APP_REGIMES

2554: IF ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.inclusive_tax_line_flag(ptnr_tax_line_index) = 'Y' THEN
2555: BEGIN
2556: SELECT count(*)
2557: INTO l_app_regimes
2558: FROM ZX_TRX_LINE_APP_REGIMES
2559: WHERE application_id = p_event_class_rec.application_id
2560: AND entity_code = p_event_class_rec.entity_code
2561: AND event_class_code = p_event_class_rec.event_class_code
2562: AND trx_id = p_event_class_rec.trx_id