[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 ;
1206: WHERE quote_header_id = c_qte_header_id;
1207:
1208: CURSOR c_party_type(c_acct_id NUMBER) IS
1209: SELECT p.party_type
1210: FROM HZ_PARTIES p, HZ_CUST_ACCOUNTS a
1211: where p.party_id = a.party_id
1212: and a.cust_account_id = c_acct_id;
1213:
1214: CURSOR c_bank_acct(c_ba_id NUMBER) IS
1228: WHERE quote_header_id = c_qtehdr_id
1229: and quote_line_id is null;
1230:
1231: CURSOR c_party_name(c_party_id NUMBER) IS
1232: SELECT substr(party_name,1,50) from HZ_PARTIES
1233: WHERE party_type = 'PERSON' and party_id = c_party_id
1234: UNION
1235: SELECT substr(party_name,1,50) from HZ_PARTIES
1236: WHERE party_id = (SELECT subject_id from HZ_RELATIONSHIPS
1231: CURSOR c_party_name(c_party_id NUMBER) IS
1232: SELECT substr(party_name,1,50) from HZ_PARTIES
1233: WHERE party_type = 'PERSON' and party_id = c_party_id
1234: UNION
1235: SELECT substr(party_name,1,50) from HZ_PARTIES
1236: WHERE party_id = (SELECT subject_id from HZ_RELATIONSHIPS
1237: WHERE party_id = c_party_id
1238: and subject_type = 'PERSON'
1239: and object_type = 'ORGANIZATION');