APPS.IBE_QUOTE_MISC_PVT dependencies on IBE_SH_QUOTE_ACCESS

Line 1997: FROM IBE_SH_QUOTE_ACCESS

1993: BEGIN
1994:
1995: SELECT update_privilege_type_code
1996: INTO l_privilege_type_code
1997: FROM IBE_SH_QUOTE_ACCESS
1998: WHERE quote_header_id = p_quote_header_id
1999: AND quote_sharee_number = p_sharee_number;
2000:
2001: RETURN l_privilege_type_code;

Line 2507: from IBE_SH_QUOTE_ACCESS

2503: and quote_version = quote_ver;
2504:
2505: Cursor c_retrieval_number (c_retrieval_number NUMBER) is
2506: select quote_sharee_number, quote_sharee_id, end_date_active, update_privilege_type_code, quote_header_id
2507: from IBE_SH_QUOTE_ACCESS
2508: where quote_sharee_number = c_retrieval_number;
2509:
2510: Cursor c_recipient_no_retnum (c_quote_header_id NUMBER, c_party_id NUMBER, c_account_id NUMBER) is
2511: select quote_sharee_number, quote_sharee_id, end_date_active, update_privilege_type_code

Line 2512: from IBE_SH_QUOTE_ACCESS

2508: where quote_sharee_number = c_retrieval_number;
2509:
2510: Cursor c_recipient_no_retnum (c_quote_header_id NUMBER, c_party_id NUMBER, c_account_id NUMBER) is
2511: select quote_sharee_number, quote_sharee_id, end_date_active, update_privilege_type_code
2512: from IBE_SH_QUOTE_ACCESS
2513: where quote_header_id = c_quote_header_id
2514: and party_id = c_party_id
2515: and cust_account_id = c_account_id;
2516:

Line 4304: from ibe_sh_quote_access

4300: WHERE user_id = c_user_id;
4301:
4302: CURSOR c_getShareeInfo IS
4303: SELECT quote_header_id,update_privilege_type_code,end_date_active, party_id, cust_account_id
4304: from ibe_sh_quote_access
4305: where quote_sharee_number = p_quote_retrieval_number
4306: and quote_header_id = p_quote_header_id;
4307:
4308: CURSOR c_isSharee(c_party_id NUMBER) IS

Line 4310: from ibe_sh_quote_access

4306: and quote_header_id = p_quote_header_id;
4307:
4308: CURSOR c_isSharee(c_party_id NUMBER) IS
4309: SELECT count(*)
4310: from ibe_sh_quote_access
4311: where party_id = c_party_id
4312: and quote_header_id = p_quote_header_id;
4313:
4314: CURSOR c_getQuoteInfo IS

Line 4709: from ibe_sh_quote_access

4705: x_valid_flag out NOCOPY VARCHAR2) is
4706:
4707: cursor c_sharee_id(c_retrieval_num NUMBER) is
4708: select quote_sharee_id
4709: from ibe_sh_quote_access
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

Line 4788: IBE_SH_QUOTE_ACCESS_PKG.update_Row(

4784:
4785: OPEN c_sharee_id(p_retrieval_number);
4786: FETCH c_sharee_id into l_recip_id;
4787: CLOSE c_sharee_id;
4788: IBE_SH_QUOTE_ACCESS_PKG.update_Row(
4789: p_QUOTE_SHAREE_ID => l_recip_id
4790: ,p_party_id => p_party_id
4791: ,p_cust_account_id => p_cust_account_id);
4792: end if;