APPS.ARH_CPROF1_PKG dependencies on HZ_CUSTOMER_PROFILES

Line 37: from hz_customer_profiles

33: --
34: declare
35: cursor cust_hold is
36: select credit_hold
37: from hz_customer_profiles
38: where cust_account_id = p_customer_id
39: and site_use_id is null;
40: begin
41: for c in cust_hold

Line 60: from hz_customer_profiles

56: --
57: declare
58: cursor site_hold is
59: select credit_hold
60: from hz_customer_profiles
61: where cust_account_id = p_customer_id
62: and site_use_id = p_site_use_id;
63: begin
64: for s in site_hold

Line 120: update hz_customer_profiles

116: --
117: -- UPDATE THE SITE LEVEL PROFILE
118: --
119:
120: update hz_customer_profiles
121: set dunning_letters = p_send_dunning_letters
122: where cust_account_id = p_customer_id
123: and site_use_id = p_site_use_id;
124:

Line 126: update hz_customer_profiles

122: where cust_account_id = p_customer_id
123: and site_use_id = p_site_use_id;
124:
125: if SQL%NOTFOUND then
126: update hz_customer_profiles
127: set dunning_letters = p_send_dunning_letters
128: where cust_account_id = p_customer_id
129: and site_use_id is null;
130: end if;

Line 138: update hz_customer_profiles

134: --
135: -- UPDATE THE CUSTOMER LEVEL PROFILE
136: --
137:
138: update hz_customer_profiles
139: set dunning_letters = p_send_dunning_letters
140: where cust_account_id = p_customer_id
141: and site_use_id is null;
142:

Line 163: update hz_customer_profiles

159: p_credit_hold IN varchar2) RETURN BOOLEAN AS
160:
161: BEGIN
162: if (p_site_use_id is null) then
163: update hz_customer_profiles
164: set credit_hold = p_credit_hold
165: where cust_account_id = p_customer_id
166: and site_use_id is null;
167: else

Line 168: update hz_customer_profiles

164: set credit_hold = p_credit_hold
165: where cust_account_id = p_customer_id
166: and site_use_id is null;
167: else
168: update hz_customer_profiles
169: set credit_hold = p_credit_hold
170: where cust_account_id = p_customer_id
171: and site_use_id = p_site_use_id;
172: end if;