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_PARTY_MERGE_PKG dependencies on ZX_EXEMPTIONS

Line 456: UPDATE zx_exemptions

452: WHERE COLL_TAX_AUTHORITY_ID = p_ptp_id_from;
453:
454: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_jurisdictions_b for tax Authorities...');
455:
456: UPDATE zx_exemptions
457: set ISSUING_TAX_AUTHORITY_ID = p_ptp_id_to,
458: last_update_date = SYSDATE,
459: last_updated_by = G_USER_ID,
460: last_update_login = G_LOGIN_ID,

Line 488: PROCEDURE ZX_EXEMPTIONS_PVT (

484: end ZX_TAX_AUTH_MERGE_PVT;
485:
486:
487:
488: PROCEDURE ZX_EXEMPTIONS_PVT (
489: p_entity_name in hz_merge_dictionary.entity_name%type,
490: p_from_id in oks_billing_profiles_b.id%type,
491: x_to_id in out nocopy oks_billing_profiles_b.id%type,
492: p_from_fk_id in hz_merge_parties.from_party_id%type,

Line 518: FROM zx_exemptions exemp

514: , TAX
515: , TAX_JURISDICTION_ID
516: , PRODUCT_ID
517: , TAX_STATUS_CODE
518: FROM zx_exemptions exemp
519: WHERE party_tax_profile_id = p_fk_id;
520:
521: CURSOR to_exemption (l_certificate_number varchar2,
522: l_effective_from zx_exemptions.effective_from%type,

Line 522: l_effective_from zx_exemptions.effective_from%type,

518: FROM zx_exemptions exemp
519: WHERE party_tax_profile_id = p_fk_id;
520:
521: CURSOR to_exemption (l_certificate_number varchar2,
522: l_effective_from zx_exemptions.effective_from%type,
523: l_effective_to zx_exemptions.effective_to%type,
524: l_type_code zx_exemptions.exemption_type_code%type,
525: l_status_code zx_exemptions.exemption_status_code%type,
526: l_tax_regime_code zx_exemptions.tax_regime_code%type,

Line 523: l_effective_to zx_exemptions.effective_to%type,

519: WHERE party_tax_profile_id = p_fk_id;
520:
521: CURSOR to_exemption (l_certificate_number varchar2,
522: l_effective_from zx_exemptions.effective_from%type,
523: l_effective_to zx_exemptions.effective_to%type,
524: l_type_code zx_exemptions.exemption_type_code%type,
525: l_status_code zx_exemptions.exemption_status_code%type,
526: l_tax_regime_code zx_exemptions.tax_regime_code%type,
527: l_tax_rate_code zx_exemptions.tax_rate_code%type,

Line 524: l_type_code zx_exemptions.exemption_type_code%type,

520:
521: CURSOR to_exemption (l_certificate_number varchar2,
522: l_effective_from zx_exemptions.effective_from%type,
523: l_effective_to zx_exemptions.effective_to%type,
524: l_type_code zx_exemptions.exemption_type_code%type,
525: l_status_code zx_exemptions.exemption_status_code%type,
526: l_tax_regime_code zx_exemptions.tax_regime_code%type,
527: l_tax_rate_code zx_exemptions.tax_rate_code%type,
528: l_cust_account_id zx_exemptions.cust_account_id%type,

Line 525: l_status_code zx_exemptions.exemption_status_code%type,

521: CURSOR to_exemption (l_certificate_number varchar2,
522: l_effective_from zx_exemptions.effective_from%type,
523: l_effective_to zx_exemptions.effective_to%type,
524: l_type_code zx_exemptions.exemption_type_code%type,
525: l_status_code zx_exemptions.exemption_status_code%type,
526: l_tax_regime_code zx_exemptions.tax_regime_code%type,
527: l_tax_rate_code zx_exemptions.tax_rate_code%type,
528: l_cust_account_id zx_exemptions.cust_account_id%type,
529: l_site_use_id zx_exemptions.site_use_id%type,

Line 526: l_tax_regime_code zx_exemptions.tax_regime_code%type,

522: l_effective_from zx_exemptions.effective_from%type,
523: l_effective_to zx_exemptions.effective_to%type,
524: l_type_code zx_exemptions.exemption_type_code%type,
525: l_status_code zx_exemptions.exemption_status_code%type,
526: l_tax_regime_code zx_exemptions.tax_regime_code%type,
527: l_tax_rate_code zx_exemptions.tax_rate_code%type,
528: l_cust_account_id zx_exemptions.cust_account_id%type,
529: l_site_use_id zx_exemptions.site_use_id%type,
530: l_exempt_reason_code zx_exemptions.exempt_reason_code%type,

Line 527: l_tax_rate_code zx_exemptions.tax_rate_code%type,

523: l_effective_to zx_exemptions.effective_to%type,
524: l_type_code zx_exemptions.exemption_type_code%type,
525: l_status_code zx_exemptions.exemption_status_code%type,
526: l_tax_regime_code zx_exemptions.tax_regime_code%type,
527: l_tax_rate_code zx_exemptions.tax_rate_code%type,
528: l_cust_account_id zx_exemptions.cust_account_id%type,
529: l_site_use_id zx_exemptions.site_use_id%type,
530: l_exempt_reason_code zx_exemptions.exempt_reason_code%type,
531: l_content_owner_id zx_exemptions.content_owner_id%type,

Line 528: l_cust_account_id zx_exemptions.cust_account_id%type,

524: l_type_code zx_exemptions.exemption_type_code%type,
525: l_status_code zx_exemptions.exemption_status_code%type,
526: l_tax_regime_code zx_exemptions.tax_regime_code%type,
527: l_tax_rate_code zx_exemptions.tax_rate_code%type,
528: l_cust_account_id zx_exemptions.cust_account_id%type,
529: l_site_use_id zx_exemptions.site_use_id%type,
530: l_exempt_reason_code zx_exemptions.exempt_reason_code%type,
531: l_content_owner_id zx_exemptions.content_owner_id%type,
532: l_tax zx_exemptions.tax%type,

Line 529: l_site_use_id zx_exemptions.site_use_id%type,

525: l_status_code zx_exemptions.exemption_status_code%type,
526: l_tax_regime_code zx_exemptions.tax_regime_code%type,
527: l_tax_rate_code zx_exemptions.tax_rate_code%type,
528: l_cust_account_id zx_exemptions.cust_account_id%type,
529: l_site_use_id zx_exemptions.site_use_id%type,
530: l_exempt_reason_code zx_exemptions.exempt_reason_code%type,
531: l_content_owner_id zx_exemptions.content_owner_id%type,
532: l_tax zx_exemptions.tax%type,
533: l_tax_jurisdiction_id zx_exemptions.tax_jurisdiction_id%type,

Line 530: l_exempt_reason_code zx_exemptions.exempt_reason_code%type,

526: l_tax_regime_code zx_exemptions.tax_regime_code%type,
527: l_tax_rate_code zx_exemptions.tax_rate_code%type,
528: l_cust_account_id zx_exemptions.cust_account_id%type,
529: l_site_use_id zx_exemptions.site_use_id%type,
530: l_exempt_reason_code zx_exemptions.exempt_reason_code%type,
531: l_content_owner_id zx_exemptions.content_owner_id%type,
532: l_tax zx_exemptions.tax%type,
533: l_tax_jurisdiction_id zx_exemptions.tax_jurisdiction_id%type,
534: l_product_id zx_exemptions.product_id%type,

Line 531: l_content_owner_id zx_exemptions.content_owner_id%type,

527: l_tax_rate_code zx_exemptions.tax_rate_code%type,
528: l_cust_account_id zx_exemptions.cust_account_id%type,
529: l_site_use_id zx_exemptions.site_use_id%type,
530: l_exempt_reason_code zx_exemptions.exempt_reason_code%type,
531: l_content_owner_id zx_exemptions.content_owner_id%type,
532: l_tax zx_exemptions.tax%type,
533: l_tax_jurisdiction_id zx_exemptions.tax_jurisdiction_id%type,
534: l_product_id zx_exemptions.product_id%type,
535: l_tax_status_code zx_exemptions.tax_status_code%type)

Line 532: l_tax zx_exemptions.tax%type,

528: l_cust_account_id zx_exemptions.cust_account_id%type,
529: l_site_use_id zx_exemptions.site_use_id%type,
530: l_exempt_reason_code zx_exemptions.exempt_reason_code%type,
531: l_content_owner_id zx_exemptions.content_owner_id%type,
532: l_tax zx_exemptions.tax%type,
533: l_tax_jurisdiction_id zx_exemptions.tax_jurisdiction_id%type,
534: l_product_id zx_exemptions.product_id%type,
535: l_tax_status_code zx_exemptions.tax_status_code%type)
536: IS

Line 533: l_tax_jurisdiction_id zx_exemptions.tax_jurisdiction_id%type,

529: l_site_use_id zx_exemptions.site_use_id%type,
530: l_exempt_reason_code zx_exemptions.exempt_reason_code%type,
531: l_content_owner_id zx_exemptions.content_owner_id%type,
532: l_tax zx_exemptions.tax%type,
533: l_tax_jurisdiction_id zx_exemptions.tax_jurisdiction_id%type,
534: l_product_id zx_exemptions.product_id%type,
535: l_tax_status_code zx_exemptions.tax_status_code%type)
536: IS
537: SELECT TAX_EXEMPTION_ID

Line 534: l_product_id zx_exemptions.product_id%type,

530: l_exempt_reason_code zx_exemptions.exempt_reason_code%type,
531: l_content_owner_id zx_exemptions.content_owner_id%type,
532: l_tax zx_exemptions.tax%type,
533: l_tax_jurisdiction_id zx_exemptions.tax_jurisdiction_id%type,
534: l_product_id zx_exemptions.product_id%type,
535: l_tax_status_code zx_exemptions.tax_status_code%type)
536: IS
537: SELECT TAX_EXEMPTION_ID
538: FROM zx_exemptions exemp

Line 535: l_tax_status_code zx_exemptions.tax_status_code%type)

531: l_content_owner_id zx_exemptions.content_owner_id%type,
532: l_tax zx_exemptions.tax%type,
533: l_tax_jurisdiction_id zx_exemptions.tax_jurisdiction_id%type,
534: l_product_id zx_exemptions.product_id%type,
535: l_tax_status_code zx_exemptions.tax_status_code%type)
536: IS
537: SELECT TAX_EXEMPTION_ID
538: FROM zx_exemptions exemp
539: WHERE party_tax_profile_id = p_to_fk_id

Line 538: FROM zx_exemptions exemp

534: l_product_id zx_exemptions.product_id%type,
535: l_tax_status_code zx_exemptions.tax_status_code%type)
536: IS
537: SELECT TAX_EXEMPTION_ID
538: FROM zx_exemptions exemp
539: WHERE party_tax_profile_id = p_to_fk_id
540: AND exempt_certificate_number = l_certificate_number
541: AND effective_from = l_effective_from
542: AND NVL(effective_to,l_effective_to) = l_effective_to

Line 563: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_EXEMPTIONS_PVT ';

559: -- Enter the procedure variables here.
560: l_count number(10) := 0;
561:
562: -- Logging Infra
563: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_EXEMPTIONS_PVT ';
564: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
565:
566: BEGIN
567:

Line 609: UPDATE zx_exemptions

605: ,rec_exe.product_id);
606: LOOP
607: FETCH to_exemption INTO to_exemption_rec;
608: IF to_exemption%NOTFOUND THEN
609: UPDATE zx_exemptions
610: set --merged_to_exemption_id = l_exemption_id_to,
611: party_tax_profile_id = p_to_fk_id,
612: last_update_date = SYSDATE,
613: last_updated_by = G_USER_ID,

Line 643: end ZX_EXEMPTIONS_PVT;

639: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
640: l_log_msg := l_procedure_name||' (-) ';
641: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
642: END IF;
643: end ZX_EXEMPTIONS_PVT;
644:
645: PROCEDURE ZX_CUSTOMER_VETO_PVT (
646: p_ptp_id_from in number,
647: p_ptp_id_to in number,

Line 976: ZX_EXEMPTIONS_PVT(

972: p_batch_id => p_batch_id,
973: p_batch_party_id => p_batch_party_id,
974: x_return_status => x_return_status);
975:
976: ZX_EXEMPTIONS_PVT(
977: p_entity_name => p_entity_name,
978: p_from_id => p_from_id,
979: x_to_id => x_to_id,
980: p_from_fk_id => l_ptp_id_from,

Line 1388: INSERT INTO zx_exemptions

1384: 'Inserting exemption records');
1385: END IF;
1386: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Inserting exemption records');
1387: FORALL i in 1..l_tbl_from_ptp_id.count
1388: INSERT INTO zx_exemptions
1389: (tax_exemption_id
1390: ,exemption_type_code
1391: ,exemption_status_code
1392: ,tax_regime_code

Line 1441: zx_exemptions_s.nextval

1437: ,site_use_id
1438: ,duplicate_exemption
1439: )
1440: SELECT
1441: zx_exemptions_s.nextval
1442: ,exemption_type_code
1443: ,exemption_status_code
1444: ,tax_regime_code
1445: ,tax_status_code

Line 1491: FROM zx_exemptions

1487: ,l_tbl_to_ptp_id(i)
1488: ,l_tbl_to_acct_id(i)
1489: ,site_use_id
1490: ,duplicate_exemption
1491: FROM zx_exemptions
1492: WHERE party_tax_profile_id = l_tbl_from_ptp_id(i);
1493: --
1494: -- Processing for Exemption records end
1495: -----------------------------------------------------------------

Line 1730: INSERT INTO zx_exemptions

1726: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
1727: 'Merge_Site_Exemptions_Pvt(+)');
1728: END IF;
1729:
1730: INSERT INTO zx_exemptions
1731: (tax_exemption_id
1732: ,exemption_type_code
1733: ,exemption_status_code
1734: ,tax_regime_code

Line 1779: zx_exemptions_s.nextval

1775: ,site_use_id
1776: ,duplicate_exemption
1777: )
1778: SELECT
1779: zx_exemptions_s.nextval
1780: ,exemption_type_code
1781: ,exemption_status_code
1782: ,tax_regime_code
1783: ,tax_status_code

Line 1825: FROM zx_exemptions

1821: ,p_to_ptp_id
1822: ,cust_account_id
1823: ,site_use_id
1824: ,duplicate_exemption
1825: FROM zx_exemptions
1826: WHERE party_tax_profile_id = p_from_ptp_id;
1827:
1828: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1829: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

Line 1830: SQL%ROWCOUNT||' record(s) created in ZX_Exemptions');

1826: WHERE party_tax_profile_id = p_from_ptp_id;
1827:
1828: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1829: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
1830: SQL%ROWCOUNT||' record(s) created in ZX_Exemptions');
1831: END IF;
1832:
1833: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1834: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,