DBA Data[Home] [Help]

APPS.ZX_TAXWARE_TAX_SERVICE_PKG dependencies on ZX_TAX_PARTNER_PKG

Line 258: PROCEDURE PERFORM_LINE_CREATION(p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,

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,

Line 259: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_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,

Line 262: PROCEDURE PERFORM_UPDATE (p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_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,

Line 263: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_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,
267: l_JurLink IN OUT NOCOPY zx_tax_taxware_GEN.JurParm,

Line 274: p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,

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,

Line 275: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,

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);

Line 584: (p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,

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);

Line 585: x_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,

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

Line 587: x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) 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 ,

Line 872: l_tax_lines_tbl ZX_TAX_PARTNER_PKG.tax_lines_tbl_type;

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;

Line 880: ' zx_tax_partner_pkg.G_BUSINESS_FLOW = ' || zx_tax_partner_pkg.G_BUSINESS_FLOW);

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

Line 882: IF zx_tax_partner_pkg.G_BUSINESS_FLOW = 'O2C' THEN

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,

Line 1222: g_tax_regime_code := zx_tax_partner_pkg.g_tax_regime_code;

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));

Line 1518: PROCEDURE PERFORM_LINE_CREATION(p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,

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;

Line 1519: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,

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;

Line 1648: PROCEDURE PERFORM_UPDATE (p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,

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);

Line 1649: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,

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;

Line 2845: p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,

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,

Line 2846: p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,

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

Line 2882: l_regime_code := zx_tax_partner_pkg.g_tax_regime_code;

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.

Line 3683: , x_output_sync_tax_lines OUT NOCOPY zx_tax_partner_pkg.output_sync_tax_lines_tbl_type

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:

Line 3755: (x_output_sync_tax_lines OUT NOCOPY zx_tax_partner_pkg.output_sync_tax_lines_tbl_type,

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

Line 3757: x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) 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 ,

Line 4092: (x_transaction_rec IN zx_tax_partner_pkg.trx_rec_type,

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;

Line 4094: x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) is

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;