[Home] [Help]
134: -- 18-AUG-2000 -- Sakthi/William - Created.
135: --
136: --
137: procedure Check_customer_name_or_id
138: ( p_customer_id IN hz_cust_accounts.cust_account_id%TYPE -- ra_customers.customer_id%TYPE -- for 4363092 TCA changes
139: ,p_customer_name IN hz_parties.party_name%TYPE -- ra_customers.customer_name%TYPE -- for 4363092 TCA changes
140: ,p_check_id_flag IN VARCHAR2
141: ,x_customer_id OUT NOCOPY hz_cust_accounts.cust_account_id%TYPE -- ra_customers.customer_id%TYPE -- for 4363092 TCA changes --File.Sql.39 bug 4440895
142: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
137: procedure Check_customer_name_or_id
138: ( p_customer_id IN hz_cust_accounts.cust_account_id%TYPE -- ra_customers.customer_id%TYPE -- for 4363092 TCA changes
139: ,p_customer_name IN hz_parties.party_name%TYPE -- ra_customers.customer_name%TYPE -- for 4363092 TCA changes
140: ,p_check_id_flag IN VARCHAR2
141: ,x_customer_id OUT NOCOPY hz_cust_accounts.cust_account_id%TYPE -- ra_customers.customer_id%TYPE -- for 4363092 TCA changes --File.Sql.39 bug 4440895
142: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
143: ,x_error_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
144: IS
145: BEGIN
157: SELECT cust_acct.cust_account_id
158: INTO x_customer_id
159: FROM
160: hz_parties party,
161: hz_cust_accounts cust_acct
162: WHERE
163: cust_acct.party_id = party.party_id
164: and cust_acct.cust_account_id = p_customer_id;
165:
180: SELECT cust_acct.cust_account_id
181: INTO x_customer_id
182: FROM
183: hz_parties party,
184: hz_cust_accounts cust_acct
185: WHERE
186: cust_acct.party_id = party.party_id
187: and substrb(party.party_name,1,50) = p_customer_name;
188: