254:
255:
256: /*Private Procedures*/
257: PROCEDURE PERFORM_VALIDATE(X_RETURN_STATUS OUT NOCOPY VARCHAR2);
258: PROCEDURE PERFORM_LINE_CREATION(p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
259: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
260: X_RETURN_STATUS OUT NOCOPY VARCHAR2);
261: PROCEDURE PERFORM_LINE_DELETION (X_RETURN_STATUS OUT NOCOPY VARCHAR2);
262: PROCEDURE PERFORM_UPDATE (p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
255:
256: /*Private Procedures*/
257: PROCEDURE PERFORM_VALIDATE(X_RETURN_STATUS OUT NOCOPY VARCHAR2);
258: PROCEDURE PERFORM_LINE_CREATION(p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
259: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
260: X_RETURN_STATUS OUT NOCOPY VARCHAR2);
261: PROCEDURE PERFORM_LINE_DELETION (X_RETURN_STATUS OUT NOCOPY VARCHAR2);
262: PROCEDURE PERFORM_UPDATE (p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
263: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
258: PROCEDURE PERFORM_LINE_CREATION(p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
259: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
260: X_RETURN_STATUS OUT NOCOPY VARCHAR2);
261: PROCEDURE PERFORM_LINE_DELETION (X_RETURN_STATUS OUT NOCOPY VARCHAR2);
262: PROCEDURE PERFORM_UPDATE (p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
263: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
264: X_RETURN_STATUS OUT NOCOPY VARCHAR2);
265: FUNCTION SET_PARAMETERS(
266: l_Tax_Link IN OUT NOCOPY zx_tax_taxware_GEN.TaxParm,
259: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
260: X_RETURN_STATUS OUT NOCOPY VARCHAR2);
261: PROCEDURE PERFORM_LINE_DELETION (X_RETURN_STATUS OUT NOCOPY VARCHAR2);
262: PROCEDURE PERFORM_UPDATE (p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
263: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
264: X_RETURN_STATUS OUT NOCOPY VARCHAR2);
265: FUNCTION SET_PARAMETERS(
266: l_Tax_Link IN OUT NOCOPY zx_tax_taxware_GEN.TaxParm,
267: l_JurLink IN OUT NOCOPY zx_tax_taxware_GEN.JurParm,
270: l_TaxLink IN OUT NOCOPY zx_tax_taxware_GEN.TaxParm,
271: l_JurLink IN OUT NOCOPY zx_tax_taxware_GEN.JurParm,
272: l_OraLink IN OUT NOCOPY zx_tax_taxware_GEN.t_OraParm) RETURN BOOLEAN;
273: PROCEDURE TAX_RESULTS_PROCESSING(
274: p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
275: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
276: l_TaxLink IN OUT NOCOPY zx_tax_taxware_GEN.TaxParm,
277: l_JurLink IN OUT NOCOPY zx_tax_taxware_GEN.JurParm,
278: l_OraLink IN OUT NOCOPY zx_tax_taxware_GEN.t_OraParm,
271: l_JurLink IN OUT NOCOPY zx_tax_taxware_GEN.JurParm,
272: l_OraLink IN OUT NOCOPY zx_tax_taxware_GEN.t_OraParm) RETURN BOOLEAN;
273: PROCEDURE TAX_RESULTS_PROCESSING(
274: p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
275: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
276: l_TaxLink IN OUT NOCOPY zx_tax_taxware_GEN.TaxParm,
277: l_JurLink IN OUT NOCOPY zx_tax_taxware_GEN.JurParm,
278: l_OraLink IN OUT NOCOPY zx_tax_taxware_GEN.t_OraParm,
279: X_RETURN_STATUS OUT NOCOPY VARCHAR2);
580: pg_exempt_cont_flag_tab var2_tab;
581:
582:
583: PROCEDURE CALCULATE_TAX_API
584: (p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
585: x_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
586: x_error_status OUT NOCOPY VARCHAR2,
587: x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) is
588: l_rel_ret_code Varchar2(20);
581:
582:
583: PROCEDURE CALCULATE_TAX_API
584: (p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
585: x_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
586: x_error_status OUT NOCOPY VARCHAR2,
587: x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) is
588: l_rel_ret_code Varchar2(20);
589: Cursor item_lines_to_be_processed is
583: PROCEDURE CALCULATE_TAX_API
584: (p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
585: x_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
586: x_error_status OUT NOCOPY VARCHAR2,
587: x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) is
588: l_rel_ret_code Varchar2(20);
589: Cursor item_lines_to_be_processed is
590: select
591: internal_organization_id ,
868: l_return_status varchar2(30);
869: ptr number;
870: cnt_end NUMBER;
871: cnt NUMBER := 1;
872: l_tax_lines_tbl ZX_TAX_PARTNER_PKG.tax_lines_tbl_type;
873: Begin
874: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
875: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
876: END IF;
876: END IF;
877:
878: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
879: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
880: ' zx_tax_partner_pkg.G_BUSINESS_FLOW = ' || zx_tax_partner_pkg.G_BUSINESS_FLOW);
881: END IF;
882: IF zx_tax_partner_pkg.G_BUSINESS_FLOW = 'O2C' THEN
883: -- Verify the integration with the version of Taxware product is certified.
884: Begin
878: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
879: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
880: ' zx_tax_partner_pkg.G_BUSINESS_FLOW = ' || zx_tax_partner_pkg.G_BUSINESS_FLOW);
881: END IF;
882: IF zx_tax_partner_pkg.G_BUSINESS_FLOW = 'O2C' THEN
883: -- Verify the integration with the version of Taxware product is certified.
884: Begin
885: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
886: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1218: g_transaction_line_id := pg_trx_line_id_tab(i);
1219: g_trx_level_type := pg_trx_level_type_tab(i);
1220: g_docment_type_id := pg_doc_type_id_tab(i);
1221: g_trasaction_id := pg_trx_id_tab(i);
1222: g_tax_regime_code := zx_tax_partner_pkg.g_tax_regime_code;
1223:
1224: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1225: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1226: ' Selecting document type for event_class_mapping id '||pg_doc_type_id_tab(I));
1514: END IF;
1515: End perform_validate;
1516:
1517:
1518: PROCEDURE PERFORM_LINE_CREATION(p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
1519: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
1520: x_return_status OUT NOCOPY VARCHAR2)is
1521: l_TaxLink ZX_TAX_TAXWARE_GEN.TaxParm;
1522: l_JurLink ZX_TAX_TAXWARE_GEN.JurParm;
1515: End perform_validate;
1516:
1517:
1518: PROCEDURE PERFORM_LINE_CREATION(p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
1519: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
1520: x_return_status OUT NOCOPY VARCHAR2)is
1521: l_TaxLink ZX_TAX_TAXWARE_GEN.TaxParm;
1522: l_JurLink ZX_TAX_TAXWARE_GEN.JurParm;
1523: l_OraLink ZX_TAX_TAXWARE_GEN.t_OraParm;
1644: END IF;
1645:
1646: End;
1647:
1648: PROCEDURE PERFORM_UPDATE (p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
1649: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
1650: x_return_status OUT NOCOPY VARCHAR2) is
1651: l_api_name CONSTANT VARCHAR2(30) := 'PERFORM_UPDATE';
1652: l_return_status varchar2(30);
1645:
1646: End;
1647:
1648: PROCEDURE PERFORM_UPDATE (p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
1649: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
1650: x_return_status OUT NOCOPY VARCHAR2) is
1651: l_api_name CONSTANT VARCHAR2(30) := 'PERFORM_UPDATE';
1652: l_return_status varchar2(30);
1653: l_ret_code boolean;
2841:
2842: End;
2843:
2844: PROCEDURE TAX_RESULTS_PROCESSING(
2845: p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
2846: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
2847: l_TaxLink IN OUT NOCOPY zx_tax_taxware_GEN.TaxParm,
2848: l_JurLink IN OUT NOCOPY zx_tax_taxware_GEN.JurParm,
2849: l_OraLink IN OUT NOCOPY zx_tax_taxware_GEN.t_OraParm,
2842: End;
2843:
2844: PROCEDURE TAX_RESULTS_PROCESSING(
2845: p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
2846: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
2847: l_TaxLink IN OUT NOCOPY zx_tax_taxware_GEN.TaxParm,
2848: l_JurLink IN OUT NOCOPY zx_tax_taxware_GEN.JurParm,
2849: l_OraLink IN OUT NOCOPY zx_tax_taxware_GEN.t_OraParm,
2850: x_return_status OUT NOCOPY VARCHAR2) IS
2878: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2879: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2880: END IF;
2881:
2882: l_regime_code := zx_tax_partner_pkg.g_tax_regime_code;
2883: l_situs := 'SHIP_TO';/*need to check can we add any logic for this*/
2884:
2885: IF l_situs = 'SHIP_TO' THEN
2886: /* Bug 5090593: Making use of the location ids passed thru view.
3679: End Check_in_cache;
3680:
3681: PROCEDURE POPULATE_SYNC_TAX_AMTS(p_sync_tax_cnt IN NUMBER
3682: , p_tax IN zx_lines.tax%type
3683: , x_output_sync_tax_lines OUT NOCOPY zx_tax_partner_pkg.output_sync_tax_lines_tbl_type
3684: , x_return_status OUT NOCOPY VARCHAR2) IS
3685:
3686: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_SYNC_TAX_AMTS';
3687:
3751: END POPULATE_SYNC_TAX_AMTS;
3752:
3753:
3754: Procedure SYNCHRONIZE_TAXWARE_REPOSITORY
3755: (x_output_sync_tax_lines OUT NOCOPY zx_tax_partner_pkg.output_sync_tax_lines_tbl_type,
3756: x_return_status OUT NOCOPY varchar2,
3757: x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) is
3758: l_api_name CONSTANT VARCHAR2(100) := 'SYNCHRONIZE_TAXWARE_REPOSITORY';
3759: CURSOR TAX_LINES_TO_BE_PROCESSED is
3753:
3754: Procedure SYNCHRONIZE_TAXWARE_REPOSITORY
3755: (x_output_sync_tax_lines OUT NOCOPY zx_tax_partner_pkg.output_sync_tax_lines_tbl_type,
3756: x_return_status OUT NOCOPY varchar2,
3757: x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) is
3758: l_api_name CONSTANT VARCHAR2(100) := 'SYNCHRONIZE_TAXWARE_REPOSITORY';
3759: CURSOR TAX_LINES_TO_BE_PROCESSED is
3760: SELECT
3761: DOCUMENT_TYPE_ID ,
4088:
4089: End SYNCHRONIZE_TAXWARE_REPOSITORY;
4090:
4091: Procedure GLOBAL_DOCUMENT_UPDATE
4092: (x_transaction_rec IN zx_tax_partner_pkg.trx_rec_type,
4093: x_return_status OUT NOCOPY varchar2,
4094: x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) is
4095: l_cnt_of_options_gt NUMBER;
4096: l_cnt_of_hdr_extns_gt NUMBER;
4090:
4091: Procedure GLOBAL_DOCUMENT_UPDATE
4092: (x_transaction_rec IN zx_tax_partner_pkg.trx_rec_type,
4093: x_return_status OUT NOCOPY varchar2,
4094: x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) is
4095: l_cnt_of_options_gt NUMBER;
4096: l_cnt_of_hdr_extns_gt NUMBER;
4097: l_cnt_of_line_extns_gt NUMBER;
4098: l_cnt_of_loc_info_gt NUMBER;