[Home] [Help]
34: l_bkr_count number; -- Added for bug#7830847 by PNAVEENK on 27-1-2009
35: -- Get Tax Code
36: CURSOR c_party_info IS
37: SELECT jgzz_fiscal_code
38: FROM hz_parties
39: WHERE party_id = p_party_id;
40:
41: -- Collections score
42: CURSOR c_collections_score IS
1632: contact_point_id, phone_country_code, phone_area_code, phone_number, phone_extension,
1633: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('PHONE_LINE_TYPE', phone_line_type) phone_line_type_meaning,
1634: email_address, contact_point_type
1635: FROM hz_contact_points
1636: WHERE owner_table_name = 'HZ_PARTIES'
1637: AND owner_table_id = x_party_id
1638: AND ((contact_point_type = 'EMAIL') OR
1639: (contact_point_type = 'PHONE' AND phone_line_type NOT IN ('PAGER', 'FAX')))
1640: AND NVL(do_not_use_flag, 'N') = 'N'
1780:
1781: -- Get Tax Code
1782: CURSOR c_party_info IS
1783: SELECT jgzz_fiscal_code
1784: FROM hz_parties
1785: WHERE party_id = p_party_id;
1786:
1787: -- Collections score
1788: CURSOR c_collections_score IS
2540: WHERE party_relationship_id = p_party_relationship_id;
2541:
2542: CURSOR c_party(p_party_id NUMBER) IS
2543: SELECT object_version_number
2544: FROM hz_parties
2545: WHERE party_id = p_party_id;
2546:
2547: CURSOR c_contact_point(p_contact_point_id NUMBER) is
2548: SELECT *
2662: l_party_rel_create_rec.status := 'A';
2663: l_party_rel_create_rec.start_date := SYSDATE;
2664: l_party_rel_create_rec.relationship_type := p_type;
2665: l_party_rel_create_rec.relationship_code := p_type;
2666: l_party_rel_create_rec.subject_table_name := 'HZ_PARTIES';
2667: l_party_rel_create_rec.object_table_name := 'HZ_PARTIES';
2668: l_party_rel_create_rec.subject_type := 'ORGANIZATION';
2669: l_party_rel_create_rec.object_type := 'PERSON';
2670: --Begin-fix bug#4604755-JYPARK-09/12/2005-When create 'Collections'/'Dunning' default contact in Collections, set CREATED_BY_MODULE column value depending on lookup HZ_CREATED_BY_MODULES
2663: l_party_rel_create_rec.start_date := SYSDATE;
2664: l_party_rel_create_rec.relationship_type := p_type;
2665: l_party_rel_create_rec.relationship_code := p_type;
2666: l_party_rel_create_rec.subject_table_name := 'HZ_PARTIES';
2667: l_party_rel_create_rec.object_table_name := 'HZ_PARTIES';
2668: l_party_rel_create_rec.subject_type := 'ORGANIZATION';
2669: l_party_rel_create_rec.object_type := 'PERSON';
2670: --Begin-fix bug#4604755-JYPARK-09/12/2005-When create 'Collections'/'Dunning' default contact in Collections, set CREATED_BY_MODULE column value depending on lookup HZ_CREATED_BY_MODULES
2671: -- l_party_rel_create_rec.created_by_module := 'IEX-DEFAULT-CONTACT';
2679:
2680: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'));
2681:
2682: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'), 'Y') = 'N' THEN
2683: SELECT hz_parties_s.nextval
2684: INTO l_party_rel_create_rec.party_rec.party_number
2685: FROM dual;
2686: ELSE
2687: l_party_rel_create_rec.party_rec.party_number := '';