[Home] [Help]
13: /*-----------------------------------------------------------------------------
14:
15: Get_Settings
16: - retrives the foreign keys from IBE_ORD_ONECLICK
17: - retrives user's main email address associated with partyid in HZ_PARTIES
18: - validates the address usage via calls to IBE_ADDRESS_V2PVT.valid_usages
19:
20: Key Input: party id and account id
21:
67: IS select email_address
68: from HZ_CONTACT_POINTS
69: where
70: contact_point_type = 'EMAIL' and
71: owner_table_name = 'HZ_PARTIES' and
72: status = 'A' and
73: owner_table_id = owner_id and primary_flag = 'Y';
74:
75: l_usage_codes JTF_VARCHAR2_TABLE_100 ;
1199: WHERE quote_header_id = c_qte_header_id;
1200:
1201: CURSOR c_party_type(c_acct_id NUMBER) IS
1202: SELECT p.party_type
1203: FROM HZ_PARTIES p, HZ_CUST_ACCOUNTS a
1204: where p.party_id = a.party_id
1205: and a.cust_account_id = c_acct_id;
1206:
1207: CURSOR c_bank_acct(c_ba_id NUMBER) IS
1221: WHERE quote_header_id = c_qtehdr_id
1222: and quote_line_id is null;
1223:
1224: CURSOR c_party_name(c_party_id NUMBER) IS
1225: SELECT substr(party_name,1,50) from HZ_PARTIES
1226: WHERE party_type = 'PERSON' and party_id = c_party_id
1227: UNION
1228: SELECT substr(party_name,1,50) from HZ_PARTIES
1229: WHERE party_id = (SELECT subject_id from HZ_RELATIONSHIPS
1224: CURSOR c_party_name(c_party_id NUMBER) IS
1225: SELECT substr(party_name,1,50) from HZ_PARTIES
1226: WHERE party_type = 'PERSON' and party_id = c_party_id
1227: UNION
1228: SELECT substr(party_name,1,50) from HZ_PARTIES
1229: WHERE party_id = (SELECT subject_id from HZ_RELATIONSHIPS
1230: WHERE party_id = c_party_id
1231: and subject_type = 'PERSON'
1232: and object_type = 'ORGANIZATION');