APPS.IBE_QUOTE_SAVE_PVT dependencies on IBE_SH_QUOTE_ACCESS

Line 1166: FROM IBE_SH_QUOTE_ACCESS, fnd_user fnd

1162: cust_account_id,
1163: quote_sharee_number,
1164: contact_point_id,
1165: fnd.customer_id shared_by_party_id
1166: FROM IBE_SH_QUOTE_ACCESS, fnd_user fnd
1167: where quote_header_id = c_quote_header_id
1168: and ibe_sh_quote_access.created_by = fnd.user_id;
1169: rec_get_recipients c_get_recipients%rowtype;
1170: l_qte_access_rec IBE_QUOTE_SAVESHARE_pvt.quote_access_rec_type

Line 1168: and ibe_sh_quote_access.created_by = fnd.user_id;

1164: contact_point_id,
1165: fnd.customer_id shared_by_party_id
1166: FROM IBE_SH_QUOTE_ACCESS, fnd_user fnd
1167: where quote_header_id = c_quote_header_id
1168: and ibe_sh_quote_access.created_by = fnd.user_id;
1169: rec_get_recipients c_get_recipients%rowtype;
1170: l_qte_access_rec IBE_QUOTE_SAVESHARE_pvt.quote_access_rec_type
1171: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
1172:

Line 1201: FROM ibe_sh_quote_access

1197: -- need to delete contact point
1198: -- delete all shares need table handle and generate table handle
1199:
1200: /*DELETE
1201: FROM ibe_sh_quote_access
1202: WHERE quote_header_id = p_quote_header_id;*/
1203:
1204: FOR rec_get_recipients in c_get_recipients(p_Quote_HEADER_ID) LOOP
1205: l_qte_access_rec.quote_sharee_id := rec_get_recipients.quote_sharee_id;

Line 1322: from ibe_sh_quote_access

1318: where status_code = 'INACTIVE';
1319:
1320: cursor c_get_recip_id(c_qte_header_id number) is
1321: select quote_sharee_id
1322: from ibe_sh_quote_access
1323: where quote_header_id = c_qte_header_id;
1324:
1325: cursor c_get_party_id is
1326: select party_id, cust_account_id

Line 1370: from ibe_sh_quote_access

1366: -- if initiator is specified, and owner is not initiator,
1367: -- send a retieval number here and to the save call (if expunge=F)
1368: if ((p_initiator_party_id <> FND_API.G_MISS_NUM) and l_party_id <> p_initiator_party_id) then
1369: select quote_sharee_number into l_retrieval_number
1370: from ibe_sh_quote_access
1371: where party_id = p_initiator_party_id
1372: and quote_header_id = p_quote_header_id
1373: and cust_account_id = p_initiator_account_id;
1374: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 7184: from ibe_sh_quote_access

7180: AND publish_flag = 'Y';
7181:
7182: CURSOR c_is_shared_cart(c_quote_header_id NUMBER) IS
7183: select count(*) is_shared_cart
7184: from ibe_sh_quote_access
7185: where quote_header_id = c_quote_header_id;
7186:
7187: rec_is_shared_cart c_is_shared_cart%rowtype;
7188: rec_check_for_quote c_check_for_quote%rowtype;