APPS.ZX_TCM_GET_EXEMPT_PKG dependencies on ZX_SECURITY

Line 149: AND content_owner_id = nvl(p_event_class_rec.first_pty_org_id,ZX_SECURITY.G_FIRST_PARTY_ORG_ID)

145: AND (tax_jurisdiction_id is null or tax_jurisdiction_id = p_tax_jurisdiction_id)
146: AND (product_id is null or product_id = p_inventory_item_id)
147: AND effective_from <= p_tax_date
148: AND (effective_to >= p_tax_date or effective_to is null)
149: AND content_owner_id = nvl(p_event_class_rec.first_pty_org_id,ZX_SECURITY.G_FIRST_PARTY_ORG_ID)
150: order by select_order1, tax_rate_code NULLS LAST, tax_jurisdiction_id NULLS LAST, tax_status_code NULLS LAST, tax NULLS LAST;
151:
152: CURSOR exemptions2(p_ptp_id NUMBER,
153: p_cust_account_id IN NUMBER,

Line 184: AND content_owner_id = nvl(p_event_class_rec.first_pty_org_id,ZX_SECURITY.G_FIRST_PARTY_ORG_ID)

180: AND (tax_jurisdiction_id is null or tax_jurisdiction_id = p_tax_jurisdiction_id)
181: AND (product_id is null or product_id = p_inventory_item_id)
182: AND effective_from <= p_tax_date
183: AND (effective_to >= p_tax_date or effective_to is null)
184: AND content_owner_id = nvl(p_event_class_rec.first_pty_org_id,ZX_SECURITY.G_FIRST_PARTY_ORG_ID)
185: order by select_order2,
186: select_order1,
187: tax_rate_code NULLS LAST, tax_jurisdiction_id NULLS LAST,
188: tax_status_code NULLS LAST, tax NULLS LAST;

Line 224: AND content_owner_id = nvl(p_event_class_rec.first_pty_org_id,ZX_SECURITY.G_FIRST_PARTY_ORG_ID)

220: AND (tax_jurisdiction_id is null or tax_jurisdiction_id = p_tax_jurisdiction_id)
221: AND (product_id is null or product_id = p_inventory_item_id)
222: AND effective_from <= p_tax_date
223: AND (effective_to >= p_tax_date or effective_to is null)
224: AND content_owner_id = nvl(p_event_class_rec.first_pty_org_id,ZX_SECURITY.G_FIRST_PARTY_ORG_ID)
225: order by select_order2,
226: select_order1,
227: tax_rate_code NULLS LAST, tax_jurisdiction_id NULLS LAST,
228: tax_status_code NULLS LAST, tax NULLS LAST;

Line 905: nvl(p_event_class_rec.first_pty_org_id,ZX_SECURITY.G_FIRST_PARTY_ORG_ID)

901: and exempt_reason_code = p_reason_code
902: and party_tax_profile_id = p_bill_to_party_ptp_id
903: and tax_regime_code = p_tax_regime_code
904: and content_owner_id =
905: nvl(p_event_class_rec.first_pty_org_id,ZX_SECURITY.G_FIRST_PARTY_ORG_ID)
906: and nvl(tax_status_code,'X') = nvl(p_tax_status_code,'X')
907: and nvl(tax,'X') = nvl(p_tax,'X')
908: and nvl(tax_jurisdiction_id,-999) = nvl(l_tax_jurisdiction_id,-999)
909: and exemption_status_code = 'UNAPPROVED';

Line 945: 'Content owner id '||to_char(nvl(p_event_class_rec.first_pty_org_id,ZX_SECURITY.G_FIRST_PARTY_ORG_ID)) || ' ' ||

941: 'Tax Regime Code '|| p_TAX_REGIME_CODE || ' '||
942: 'Tax '|| p_TAX || ' '||
943: 'Tax Status Code ' ||p_TAX_STATUS_CODE || ' ' ||
944: 'Tax Rate Code '||p_tax_rate_code || ' ' ||
945: 'Content owner id '||to_char(nvl(p_event_class_rec.first_pty_org_id,ZX_SECURITY.G_FIRST_PARTY_ORG_ID)) || ' ' ||
946: 'Exemption Certificate Number '|| p_exempt_certificate_number || ' ' ||
947: 'Reason Code '|| p_REASON_CODE || ' ' ||
948: 'Start Date '|| to_char(nvl(l_start_date, trunc(sysdate))) || ' ' ||
949: 'Bill to party ptp id '|| to_char(p_bill_to_party_ptp_id) || ' ' ||

Line 991: nvl(p_event_class_rec.first_pty_org_id,ZX_SECURITY.G_FIRST_PARTY_ORG_ID),

987: p_TAX_REGIME_CODE,
988: p_TAX,
989: p_TAX_STATUS_CODE,
990: p_tax_rate_code,
991: nvl(p_event_class_rec.first_pty_org_id,ZX_SECURITY.G_FIRST_PARTY_ORG_ID),
992: p_exempt_certificate_number,
993: p_REASON_CODE,
994: nvl(l_start_date, trunc(sysdate)),
995: p_bill_to_party_ptp_id,