APPS.IBE_QUOTE_MISC_PVT dependencies on IBE_SH_QUOTE_ACCESS

Line 1998: FROM IBE_SH_QUOTE_ACCESS

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

Line 2625: from IBE_SH_QUOTE_ACCESS

2621: and quote_version = quote_ver;
2622:
2623: Cursor c_retrieval_number (c_retrieval_number NUMBER) is
2624: select quote_sharee_number, quote_sharee_id, end_date_active, update_privilege_type_code, quote_header_id
2625: from IBE_SH_QUOTE_ACCESS
2626: where quote_sharee_number = c_retrieval_number;
2627:
2628: Cursor c_recipient_no_retnum (c_quote_header_id NUMBER, c_party_id NUMBER, c_account_id NUMBER) is
2629: select quote_sharee_number, quote_sharee_id, end_date_active, update_privilege_type_code

Line 2630: from IBE_SH_QUOTE_ACCESS

2626: where quote_sharee_number = c_retrieval_number;
2627:
2628: Cursor c_recipient_no_retnum (c_quote_header_id NUMBER, c_party_id NUMBER, c_account_id NUMBER) is
2629: select quote_sharee_number, quote_sharee_id, end_date_active, update_privilege_type_code
2630: from IBE_SH_QUOTE_ACCESS
2631: where quote_header_id = c_quote_header_id
2632: and party_id = c_party_id
2633: and cust_account_id = c_account_id;
2634:

Line 4423: from ibe_sh_quote_access

4419: WHERE user_id = c_user_id;
4420:
4421: CURSOR c_getShareeInfo IS
4422: SELECT quote_header_id,update_privilege_type_code,end_date_active, party_id, cust_account_id
4423: from ibe_sh_quote_access
4424: where quote_sharee_number = p_quote_retrieval_number
4425: and quote_header_id = p_quote_header_id;
4426:
4427: CURSOR c_isSharee(c_party_id NUMBER) IS

Line 4429: from ibe_sh_quote_access

4425: and quote_header_id = p_quote_header_id;
4426:
4427: CURSOR c_isSharee(c_party_id NUMBER) IS
4428: SELECT count(*)
4429: from ibe_sh_quote_access
4430: where party_id = c_party_id
4431: and quote_header_id = p_quote_header_id;
4432:
4433: CURSOR c_getQuoteInfo IS

Line 4851: from ibe_sh_quote_access

4847: x_valid_flag out NOCOPY VARCHAR2) is
4848:
4849: cursor c_sharee_id(c_retrieval_num NUMBER) is
4850: select quote_sharee_id
4851: from ibe_sh_quote_access
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

Line 4930: IBE_SH_QUOTE_ACCESS_PKG.update_Row(

4926:
4927: OPEN c_sharee_id(p_retrieval_number);
4928: FETCH c_sharee_id into l_recip_id;
4929: CLOSE c_sharee_id;
4930: IBE_SH_QUOTE_ACCESS_PKG.update_Row(
4931: p_QUOTE_SHAREE_ID => l_recip_id
4932: ,p_party_id => p_party_id
4933: ,p_cust_account_id => p_cust_account_id);
4934: end if;