[Home] [Help]
60:
61:
62: CURSOR c_check_account(in_cust_account_id in number) IS
63: SELECT status,party_id
64: FROM hz_cust_accounts
65: WHERE cust_account_id = in_cust_account_id;
66:
67: CURSOR c_get_cust_account_id(in_cust_account_number in varchar2) IS
68: SELECT cust_account_id,party_id,status
65: WHERE cust_account_id = in_cust_account_id;
66:
67: CURSOR c_get_cust_account_id(in_cust_account_number in varchar2) IS
68: SELECT cust_account_id,party_id,status
69: FROM hz_cust_accounts
70: WHERE account_number=in_cust_account_number
71: AND status='A';
72:
73: CURSOR c_cust_account_id(in_cust_account_id in number) IS
71: AND status='A';
72:
73: CURSOR c_cust_account_id(in_cust_account_id in number) IS
74: SELECT party_id
75: FROM hz_cust_accounts
76: WHERE cust_account_id=in_cust_account_id
77: AND status='A';
78:
79: CURSOR c_related_cust_account_id (in_cust_account_id in number) IS
2921: SELECT role.cust_account_role_id,
2922: role.cust_acct_site_id
2923: FROM hz_org_contacts org,
2924: hz_relationships rel,
2925: hz_cust_accounts acct,
2926: hz_cust_account_roles role
2927: WHERE org.org_Contact_id = in_org_contact_id
2928: AND org.party_relationship_id = rel.relationship_id
2929: AND rel.object_id=acct.party_id
2939:
2940:
2941: CURSOR C_get_cust_id_from_party_id(l_Party_Id NUMBER) IS
2942: SELECT cust_account_id,account_number
2943: FROM hz_cust_accounts
2944: WHERE party_id = l_Party_Id
2945: and status = 'A';
2946:
2947: CURSOR c_check_org_contact(in_party_id in number,in_org_contact_id in number) IS
3569:
3570: CURSOR C_get_cust_id_from_party_id(l_Party_Id NUMBER) IS
3571: SELECT cust_account_id,
3572: account_number
3573: FROM hz_cust_accounts
3574: WHERE party_id = l_Party_Id
3575: and status = 'A';
3576:
3577: CURSOR party_rec(l_party_id in number) IS
4063:
4064: CURSOR C_get_cust_id_from_party_id(l_Party_Id NUMBER) IS
4065: SELECT cust_account_id,
4066: account_number
4067: FROM hz_cust_accounts
4068: WHERE party_id = l_Party_Id
4069: and status = 'A';
4070:
4071: CURSOR party_rec(l_party_id in number) IS
4408: -- local variables here
4409: cursor c_get_account_id(l_party_id number) is
4410: select cust_account_id
4411: --into p_cust_account_id -- commented for bug 3449269
4412: from hz_cust_accounts
4413: where party_id=l_party_id
4414: and status='A';
4415: l_debug_level NUMBER := oe_debug_pub.g_debug_level;
4416:
4490: END IF;
4491:
4492: select party_id
4493: into p_party_id
4494: from hz_cust_accounts
4495: where cust_account_id=p_cust_account_id;
4496:
4497: RETURN;
4498: END IF;
4553: if nvl(p_party_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4554: begin
4555: select party_id
4556: into p_party_id
4557: from hz_cust_accounts
4558: where cust_account_id = p_cust_account_id;
4559:
4560: IF l_debug_level > 0 THEN
4561: oe_debug_pub.add ('AAC:FSTI: also found party_id:'||p_party_id||', returning');
5480: END IF;
5481: begin
5482: select a.party_id
5483: into p_party_id
5484: from hz_cust_accounts a,
5485: hz_cust_acct_sites s,
5486: hz_cust_site_uses_all u
5487: where u.site_use_id=p_account_site_use_id
5488: and u.cust_acct_site_id=s.cust_acct_site_id
6099:
6100: ELSE
6101: Select Cust_Acct.Cust_account_id
6102: into l_id
6103: from HZ_CUST_ACCOUNTS Cust_Acct,
6104: HZ_PARTIES Party
6105: where Cust_Acct.Party_id = Party.party_id
6106: and cust_acct.status='A'
6107: and Party.Party_name = p_sold_to_org;
6158:
6159: pragma autonomous_transaction;
6160:
6161: BEGIN
6162: select 'Y' into x_found from HZ_CUST_ACCOUNTS where cust_account_id= p_cust_id;
6163: EXCEPTION
6164: WHEN NO_DATA_FOUND THEN
6165: x_found:='N';
6166: