APPS.IBE_QUOTE_MISC_PVT dependencies on HZ_PARTIES

Line 2016: Cursor c_hz_parties(c_party_id NUMBER) IS

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

Line 2018: FROM hz_parties

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

Line 2020: c_hz_parties_rec c_hz_parties%rowtype;

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

Line 2023: FOR c_hz_parties_rec IN c_hz_parties(p_partyId) LOOP

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

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

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

Line 4714: from aso_quote_headers_all a, hz_parties p

4710: where quote_sharee_number = c_retrieval_num ;
4711:
4712: cursor c_get_sold_to(c_quote_header_id NUMBER) is
4713: select cust_account_id, party_type
4714: from aso_quote_headers_all a, hz_parties p
4715: where a.party_id = p.party_id
4716: and quote_header_id = c_quote_header_id;
4717:
4718: cursor c_get_party_type(c_party_id NUMBER) is

Line 4720: from hz_parties

4716: and quote_header_id = c_quote_header_id;
4717:
4718: cursor c_get_party_type(c_party_id NUMBER) is
4719: select party_type
4720: from hz_parties
4721: where party_id = c_party_id;
4722:
4723: rec_get_sold_to c_get_sold_to%rowtype;
4724:

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

4989: RETURN VARCHAR2
4990: IS
4991: CURSOR C1 IS
4992: select HP.party_id,HP.party_name
4993: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
4994: and HPR.subject_type = 'PERSON'
4995: and HPR.object_type = 'ORGANIZATION'
4996: and hp.party_id=HPR.subject_id;
4997: CURSOR C2 IS

Line 4999: from hz_parties HP where party_id = p_party_id;

4995: and HPR.object_type = 'ORGANIZATION'
4996: and hp.party_id=HPR.subject_id;
4997: CURSOR C2 IS
4998: select party_id,party_name
4999: from hz_parties HP where party_id = p_party_id;
5000: l_party_name VARCHAR2(360);
5001: l_party_id NUMBER;
5002: BEGIN
5003: IF p_party_type = 'PARTY_RELATIONSHIP' THEN