[Home] [Help]
1611: ztlar.tax_provider_id,
1612: ztlar.trx_line_id,
1613: regimes.effective_from,
1614: regimes.effective_to
1615: FROM ZX_TRX_LINE_APP_REGIMES ztlar,
1616: ZX_REGIMES_B regimes
1617: WHERE ztlar.application_id = p_event_class_rec.application_id
1618: AND ztlar.entity_code = p_event_class_rec.entity_code
1619: AND ztlar.event_class_code = p_event_class_rec.event_class_code
1647: ztlar.tax_provider_id,
1648: ztlar.trx_line_id,
1649: regimes.effective_from,
1650: regimes.effective_to
1651: FROM ZX_TRX_LINE_APP_REGIMES ztlar,
1652: ZX_REGIMES_B regimes
1653: WHERE ztlar.application_id = p_event_class_rec.application_id
1654: AND ztlar.entity_code = p_event_class_rec.entity_code
1655: AND ztlar.event_class_code = p_event_class_rec.event_class_code
1664: SELECT tax_regime_id,
1665: tax_regime_code,
1666: tax_provider_id,
1667: trx_line_id
1668: FROM ZX_TRX_LINE_APP_REGIMES
1669: WHERE application_id = p_event_class_rec.application_id
1670: AND entity_code = p_event_class_rec.entity_code
1671: AND event_class_code = p_event_class_rec.event_class_code
1672: AND trx_id = p_event_class_rec.trx_id
7643: BEGIN
7644: IF p_event_class_rec.event_type_code = 'UPDATE' THEN
7645: SELECT tax_provider_id
7646: INTO l_tax_provider_id
7647: FROM ZX_TRX_LINE_APP_REGIMES
7648: WHERE application_id = p_event_class_rec.application_id
7649: AND entity_code = p_event_class_rec.entity_code
7650: AND event_class_code = p_event_class_rec.event_class_code
7651: AND trx_id = p_event_class_rec.trx_id
8578: IF nvl(p_event_class_rec.quote_flag,'N') = 'Y' THEN
8579: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) := 'CREATE';
8580: END IF;
8581:
8582: /* Partner code - Update the zx_trx_line_app_regimes to indicate which transaction lines
8583: are being updated - this will ease out the setting of partner processing flag later*/
8584: IF zx_global_structures_pkg.g_ptnr_srvc_subscr_flag = 'Y' THEN
8585: IF p_event_class_rec.TAX_EVENT_TYPE_CODE ='UPDATE' THEN
8586: --Call zx_line_app_regimes table_handler for deleting the non-applicable regimes
9092:
9093: IF p_event_class_rec.tax_event_type_code = 'UPDATE'
9094: AND p_event_class_rec.QUOTE_FLAG = 'N' THEN
9095:
9096: /*If document is a migrated one, include all the distinct regimes from ZX_TRX_LINE_APP_REGIMES,
9097: for which partners were called in ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl and set the
9098: partner_processing_flag to 'F' (first time called)*/
9099:
9100: /*-------------------------------------------------------------*
9132:
9133: /*Check other lines have the regime in considerarion in table zx_TRX_LINES_APP_REGIMES*/
9134: SELECT 'Y'
9135: INTO l_regime_exists_other_lines
9136: FROM ZX_TRX_LINE_APP_REGIMES
9137: WHERE application_id = p_event_class_rec.application_id
9138: AND entity_code = p_event_class_rec.entity_code
9139: AND event_class_code = p_event_class_rec.event_class_code
9140: AND trx_id = p_event_class_rec.trx_id
9152: ZX_GLOBAL_STRUCTURES_PKG.g_ptnr_srvc_subscr_flag := 'Y';
9153:
9154: /*Provider/Regime No Longer Applicable: If a "provider regime" is no longer found applicable to entire
9155: transaction due to an update on a transaction line(s) (The new applicable regimes for the line are in
9156: ZX_GLOBAL_STRUCTURES_PKG.zx_trx_line_app_regimes_tbl whereas old applicable regimes for the line are in
9157: ZX_TRX_LINE_APP_REGIMES), look for this provider regime if applicable for non-updated lines. If not
9158: applicable for non-updated lines, then include that provider in ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl
9159: and set the partner_processing_flag to 'N' (Provider/Regime no longer applicable) in
9160: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl for that provider. */
9153:
9154: /*Provider/Regime No Longer Applicable: If a "provider regime" is no longer found applicable to entire
9155: transaction due to an update on a transaction line(s) (The new applicable regimes for the line are in
9156: ZX_GLOBAL_STRUCTURES_PKG.zx_trx_line_app_regimes_tbl whereas old applicable regimes for the line are in
9157: ZX_TRX_LINE_APP_REGIMES), look for this provider regime if applicable for non-updated lines. If not
9158: applicable for non-updated lines, then include that provider in ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl
9159: and set the partner_processing_flag to 'N' (Provider/Regime no longer applicable) in
9160: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl for that provider. */
9161: ELSE --regime no longer applicable
9318: END IF;
9319:
9320:
9321: /*Check if partner_processing_flag = 'N', then
9322: Delete Provider Tax Lines from the ZX_LINES and references to the provider in the ZX_TRX_LINE_APP_REGIMES for that regime.
9323: If partner recording is allowed for this event class, then
9324: Call partner's service Modify Doc Status with action DELETE*/
9325:
9326: IF ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl.EXISTS(l_regime_index) AND
9362: END IF;
9363: RETURN;
9364: END IF;
9365:
9366: /*Delete Provider Tax Lines from the ZX_TRX_LINE_APP_REGIMES*/
9367: --Call zx_line_app_regimes table_handler for deleting the non-applicable regimes
9368:
9369: ZX_TPI_SERVICES_PKG.trx_line_app_regimes_tbl_hdl (p_event_class_rec => p_event_class_rec,
9370: p_event => 'DELETE',