[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
2919: SELECT role.cust_account_role_id,
2920: role.cust_acct_site_id
2921: FROM hz_org_contacts org,
2922: hz_relationships rel,
2923: hz_cust_accounts acct,
2924: hz_cust_account_roles role
2925: WHERE org.org_Contact_id = in_org_contact_id
2926: AND org.party_relationship_id = rel.relationship_id
2927: AND rel.object_id=acct.party_id
2937:
2938:
2939: CURSOR C_get_cust_id_from_party_id(l_Party_Id NUMBER) IS
2940: SELECT cust_account_id,account_number
2941: FROM hz_cust_accounts
2942: WHERE party_id = l_Party_Id
2943: and status = 'A';
2944:
2945: CURSOR c_check_org_contact(in_party_id in number,in_org_contact_id in number) IS
3567:
3568: CURSOR C_get_cust_id_from_party_id(l_Party_Id NUMBER) IS
3569: SELECT cust_account_id,
3570: account_number
3571: FROM hz_cust_accounts
3572: WHERE party_id = l_Party_Id
3573: and status = 'A';
3574:
3575: CURSOR party_rec(l_party_id in number) IS
4061:
4062: CURSOR C_get_cust_id_from_party_id(l_Party_Id NUMBER) IS
4063: SELECT cust_account_id,
4064: account_number
4065: FROM hz_cust_accounts
4066: WHERE party_id = l_Party_Id
4067: and status = 'A';
4068:
4069: CURSOR party_rec(l_party_id in number) IS
4406: -- local variables here
4407: cursor c_get_account_id(l_party_id number) is
4408: select cust_account_id
4409: --into p_cust_account_id -- commented for bug 3449269
4410: from hz_cust_accounts
4411: where party_id=l_party_id
4412: and status='A';
4413: l_debug_level NUMBER := oe_debug_pub.g_debug_level;
4414:
4488: END IF;
4489:
4490: select party_id
4491: into p_party_id
4492: from hz_cust_accounts
4493: where cust_account_id=p_cust_account_id;
4494:
4495: RETURN;
4496: END IF;
4551: if nvl(p_party_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4552: begin
4553: select party_id
4554: into p_party_id
4555: from hz_cust_accounts
4556: where cust_account_id = p_cust_account_id;
4557:
4558: IF l_debug_level > 0 THEN
4559: oe_debug_pub.add ('AAC:FSTI: also found party_id:'||p_party_id||', returning');
5478: END IF;
5479: begin
5480: select a.party_id
5481: into p_party_id
5482: from hz_cust_accounts a,
5483: hz_cust_acct_sites s,
5484: hz_cust_site_uses_all u
5485: where u.site_use_id=p_account_site_use_id
5486: and u.cust_acct_site_id=s.cust_acct_site_id
6097:
6098: ELSE
6099: Select Cust_Acct.Cust_account_id
6100: into l_id
6101: from HZ_CUST_ACCOUNTS Cust_Acct,
6102: HZ_PARTIES Party
6103: where Cust_Acct.Party_id = Party.party_id
6104: and cust_acct.status='A'
6105: and Party.Party_name = p_sold_to_org;
6156:
6157: pragma autonomous_transaction;
6158:
6159: BEGIN
6160: select 'Y' into x_found from HZ_CUST_ACCOUNTS where cust_account_id= p_cust_id;
6161: EXCEPTION
6162: WHEN NO_DATA_FOUND THEN
6163: x_found:='N';
6164: