APPS.IBE_QUOTE_MISC_PVT dependencies on HZ_PARTIES

Line 2017: Cursor c_hz_parties(c_party_id NUMBER) IS

2013: ) RETURN VARCHAR2
2014: IS
2015: l_PartyType Varchar2(30);
2016:
2017: Cursor c_hz_parties(c_party_id NUMBER) IS
2018: SELECT party_type
2019: FROM hz_parties
2020: WHERE party_id = c_party_id;
2021: c_hz_parties_rec c_hz_parties%rowtype;

Line 2019: FROM hz_parties

2015: l_PartyType Varchar2(30);
2016:
2017: Cursor c_hz_parties(c_party_id NUMBER) IS
2018: SELECT party_type
2019: FROM hz_parties
2020: WHERE party_id = c_party_id;
2021: c_hz_parties_rec c_hz_parties%rowtype;
2022:
2023: BEGIN

Line 2021: c_hz_parties_rec c_hz_parties%rowtype;

2017: Cursor c_hz_parties(c_party_id NUMBER) IS
2018: SELECT party_type
2019: FROM hz_parties
2020: WHERE party_id = c_party_id;
2021: c_hz_parties_rec c_hz_parties%rowtype;
2022:
2023: BEGIN
2024: FOR c_hz_parties_rec IN c_hz_parties(p_partyId) LOOP
2025: l_PartyType := rtrim(c_hz_parties_rec.party_type);

Line 2024: FOR c_hz_parties_rec IN c_hz_parties(p_partyId) LOOP

2020: WHERE party_id = c_party_id;
2021: c_hz_parties_rec c_hz_parties%rowtype;
2022:
2023: BEGIN
2024: FOR c_hz_parties_rec IN c_hz_parties(p_partyId) LOOP
2025: l_PartyType := rtrim(c_hz_parties_rec.party_type);
2026: END LOOP;
2027:
2028: If (l_PartyType = 'PERSON') Then

Line 2025: l_PartyType := rtrim(c_hz_parties_rec.party_type);

2021: c_hz_parties_rec c_hz_parties%rowtype;
2022:
2023: BEGIN
2024: FOR c_hz_parties_rec IN c_hz_parties(p_partyId) LOOP
2025: l_PartyType := rtrim(c_hz_parties_rec.party_type);
2026: END LOOP;
2027:
2028: If (l_PartyType = 'PERSON') Then
2029: return 'B2C';

Line 4856: from aso_quote_headers_all a, hz_parties p

4852: where quote_sharee_number = c_retrieval_num ;
4853:
4854: cursor c_get_sold_to(c_quote_header_id NUMBER) is
4855: select cust_account_id, party_type
4856: from aso_quote_headers_all a, hz_parties p
4857: where a.party_id = p.party_id
4858: and quote_header_id = c_quote_header_id;
4859:
4860: cursor c_get_party_type(c_party_id NUMBER) is

Line 4862: from hz_parties

4858: and quote_header_id = c_quote_header_id;
4859:
4860: cursor c_get_party_type(c_party_id NUMBER) is
4861: select party_type
4862: from hz_parties
4863: where party_id = c_party_id;
4864:
4865: rec_get_sold_to c_get_sold_to%rowtype;
4866:

Line 5135: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id

5131: RETURN VARCHAR2
5132: IS
5133: CURSOR C1 IS
5134: select HP.party_id,HP.party_name
5135: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
5136: and HPR.subject_type = 'PERSON'
5137: and HPR.object_type = 'ORGANIZATION'
5138: and hp.party_id=HPR.subject_id;
5139: CURSOR C2 IS

Line 5141: from hz_parties HP where party_id = p_party_id;

5137: and HPR.object_type = 'ORGANIZATION'
5138: and hp.party_id=HPR.subject_id;
5139: CURSOR C2 IS
5140: select party_id,party_name
5141: from hz_parties HP where party_id = p_party_id;
5142: l_party_name VARCHAR2(360);
5143: l_party_id NUMBER;
5144: BEGIN
5145: IF p_party_type = 'PARTY_RELATIONSHIP' THEN