86: select 1
87: into dummy
88: from dual
89: where not exists ( select 1
90: from hz_cust_accounts
91: where account_number = p_customer_number
92: and ( ( p_rowid is null ) or (rowid <> p_rowid))
93: );
94:
174: select 1
175: into dummy
176: from dual
177: where not exists ( select 1
178: from hz_cust_accounts c
179: where c.orig_system_reference = p_orig_system_reference
180: and ( ( p_rowid is null ) or (c.rowid <> p_rowid)));
181:
182: exception
216: l_status VARCHAR2(1);
217: l_lock_status NUMBER;
218: CURSOR statuscur IS
219: SELECT status
220: FROM hz_cust_accounts
221: WHERE rowid = p_rowid;
222:
223: BEGIN
224: -- bug 2092530: removed the check to the ar_alt_name_search profile
277: | ra customers.statement_site_use_id = hz_cust_site_uses.site_use_id (+) |
278: | |
279: | These queries can now be changed to: |
280: | |
281: | ARP_CUST_PKG.get_statement_site(hz_cust_accounts.cust_account_id) = |
282: | hz_cust_site_uses.site_use_id (+) |
283: | |
284: | Make sure you donot pass a constant as an argument when making use |
285: | of this function in a query which is supposed to succeed even if the |
295: | and replaced with hz counterparts |
296: +===========================================================================*/
297:
298: FUNCTION get_statement_site (
299: p_customer_id IN hz_cust_accounts.cust_account_id%type
300: )
301: RETURN NUMBER is
302:
303: v_statement_site_use_id hz_cust_site_uses.site_use_id%type;
357: | ra customers.dunning_site_use_id = hz_cust_site_uses.site_use_id (+) |
358: | |
359: | These queries can now be changed to: |
360: | |
361: | ARP_CUST_PKG.get_dunning(hz_cust_accounts.cust_account_id) = |
362: | hz_cust_site_uses.site_use_id (+) |
363: | |
364: | Make sure you donot pass a constant as an argument when making use |
365: | of this function in a query which is supposed to succeed even if the |
375: | and replaced with hz counterparts |
376: +===========================================================================*/
377:
378: FUNCTION get_dunning_site (
379: p_customer_id IN hz_cust_accounts.cust_account_id%type
380: )
381: RETURN NUMBER is
382:
383: v_dunning_site_use_id hz_cust_site_uses.site_use_id%type;
436: | |
437: +===========================================================================+*/
438: --
439: FUNCTION get_current_dunning_type (
440: p_customer_id IN hz_cust_accounts.cust_account_id%type,
441: p_bill_to_site_id IN NUMBER
442: )
443: return varchar2 is
444: --
467: hz_cust_acct_sites ad_cus,
468: hz_customer_profiles cust_pro,
469: hz_customer_profiles site_pro,
470: ar_dunning_letter_sets dls,
471: hz_cust_accounts cus
472: where su.site_use_code = 'BILL_TO'
473: and su.status = 'A'
474: and su.site_use_id = p_bill_to_site_id
475: and ad_cus.cust_acct_site_id = su.cust_acct_site_id
544: END;
545:
546: --
547: FUNCTION get_primary_billto_site (
548: p_customer_id IN hz_cust_accounts.cust_account_id%type
549: )
550: RETURN NUMBER is
551:
552: v_billto_site_use_id hz_cust_site_uses.site_use_id%type;