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 488: update zx_exemptions

484: where COLL_TAX_AUTHORITY_ID = p_ptp_id_from;
485:
486: arp_message.set_line('Updating zx_jurisdictions_b for tax Authorities...');
487:
488: update zx_exemptions
489: set ISSUING_TAX_AUTHORITY_ID = p_ptp_id_to,
490: last_update_date = sysdate,
491: last_updated_by = g_user_id,
492: last_update_login = g_login_id,

Line 519: PROCEDURE ZX_EXEMPTIONS_P (

515: END IF;
516: ---------------------------------------------------------------------------------
517: end ZX_TAX_AUTH_MERGE;
518:
519: PROCEDURE ZX_EXEMPTIONS_P (
520: p_entity_name in hz_merge_dictionary.entity_name%type,
521: p_from_id in oks_billing_profiles_b.id%type,
522: x_to_id in out nocopy oks_billing_profiles_b.id%type,
523: p_from_fk_id in hz_merge_parties.from_party_id%type,

Line 540: from zx_exemptions exemp

536: , effective_to
537: , EXEMPTION_TYPE_CODE
538: , EXEMPTION_STATUS_CODE
539: ,TAX_REGIME_CODE
540: from zx_exemptions exemp
541: where party_tax_profile_id = p_fk_id;
542:
543: CURSOR to_exemption (l_certificate_number varchar2,
544: l_effective_from zx_exemptions.effective_from%type,

Line 544: l_effective_from zx_exemptions.effective_from%type,

540: from zx_exemptions exemp
541: where party_tax_profile_id = p_fk_id;
542:
543: CURSOR to_exemption (l_certificate_number varchar2,
544: l_effective_from zx_exemptions.effective_from%type,
545: l_effective_to zx_exemptions.effective_to%type,
546: l_type_code zx_exemptions.exemption_type_code%type,
547: l_status_code zx_exemptions.exemption_status_code%type,
548: l_tax_regime_code zx_exemptions.tax_regime_code%type)

Line 545: l_effective_to zx_exemptions.effective_to%type,

541: where party_tax_profile_id = p_fk_id;
542:
543: CURSOR to_exemption (l_certificate_number varchar2,
544: l_effective_from zx_exemptions.effective_from%type,
545: l_effective_to zx_exemptions.effective_to%type,
546: l_type_code zx_exemptions.exemption_type_code%type,
547: l_status_code zx_exemptions.exemption_status_code%type,
548: l_tax_regime_code zx_exemptions.tax_regime_code%type)
549: IS

Line 546: l_type_code zx_exemptions.exemption_type_code%type,

542:
543: CURSOR to_exemption (l_certificate_number varchar2,
544: l_effective_from zx_exemptions.effective_from%type,
545: l_effective_to zx_exemptions.effective_to%type,
546: l_type_code zx_exemptions.exemption_type_code%type,
547: l_status_code zx_exemptions.exemption_status_code%type,
548: l_tax_regime_code zx_exemptions.tax_regime_code%type)
549: IS
550: select TAX_EXEMPTION_ID

Line 547: l_status_code zx_exemptions.exemption_status_code%type,

543: CURSOR to_exemption (l_certificate_number varchar2,
544: l_effective_from zx_exemptions.effective_from%type,
545: l_effective_to zx_exemptions.effective_to%type,
546: l_type_code zx_exemptions.exemption_type_code%type,
547: l_status_code zx_exemptions.exemption_status_code%type,
548: l_tax_regime_code zx_exemptions.tax_regime_code%type)
549: IS
550: select TAX_EXEMPTION_ID
551: from zx_exemptions exemp

Line 548: l_tax_regime_code zx_exemptions.tax_regime_code%type)

544: l_effective_from zx_exemptions.effective_from%type,
545: l_effective_to zx_exemptions.effective_to%type,
546: l_type_code zx_exemptions.exemption_type_code%type,
547: l_status_code zx_exemptions.exemption_status_code%type,
548: l_tax_regime_code zx_exemptions.tax_regime_code%type)
549: IS
550: select TAX_EXEMPTION_ID
551: from zx_exemptions exemp
552: where party_tax_profile_id = p_to_fk_id

Line 551: from zx_exemptions exemp

547: l_status_code zx_exemptions.exemption_status_code%type,
548: l_tax_regime_code zx_exemptions.tax_regime_code%type)
549: IS
550: select TAX_EXEMPTION_ID
551: from zx_exemptions exemp
552: where party_tax_profile_id = p_to_fk_id
553: and exempt_certificate_number = l_certificate_number
554: and effective_from = l_effective_from
555: and nvl(effective_to,l_effective_to) = l_effective_to

Line 562: l_proc_name varchar2(30) := 'ZX_EXEMPTIONS';

558: and tax_regime_code = l_tax_regime_code;
559: to_exemption_rec to_exemption%ROWTYPE;
560:
561: -- Enter the procedure variables here.
562: l_proc_name varchar2(30) := 'ZX_EXEMPTIONS';
563: l_count number(10) := 0;
564:
565: -- Logging Infra
566: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_EXEMPTIONS_P ';

Line 566: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_EXEMPTIONS_P ';

562: l_proc_name varchar2(30) := 'ZX_EXEMPTIONS';
563: l_count number(10) := 0;
564:
565: -- Logging Infra
566: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_EXEMPTIONS_P ';
567: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
568:
569: BEGIN
570: -- arp_message.set_line(g_api_name||'.'||l_proc_name);

Line 604: update zx_exemptions

600: ,rec_exe.exemption_status_code
601: ,rec_exe.tax_regime_code);
602: FETCH to_exemption INTO to_exemption_rec;
603: IF to_exemption%NOTFOUND THEN
604: update zx_exemptions
605: set --merged_to_exemption_id = l_exemption_id_to,
606: party_tax_profile_id = p_to_fk_id,
607: last_update_date = sysdate,
608: last_updated_by = g_user_id,

Line 636: end ZX_EXEMPTIONS_P;

632: l_log_msg := l_procedure_name||' (-) ';
633: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.END ', l_log_msg);
634: END IF;
635: ---------------------------------------------------------------------------------
636: end ZX_EXEMPTIONS_P;
637:
638: PROCEDURE ZX_CUSTOMER_VETO (
639: p_ptp_id_from in number,
640: p_ptp_id_to in number,

Line 895: ZX_EXEMPTIONS_P(

891: p_batch_id => p_batch_id,
892: p_batch_party_id => p_batch_party_id,
893: x_return_status => x_return_status);
894:
895: ZX_EXEMPTIONS_P(
896: p_entity_name => p_entity_name,
897: p_from_id => p_from_id,
898: x_to_id => x_to_id,
899: p_from_fk_id => l_ptp_id_from,