DBA Data[Home] [Help]

APPS.IBE_QUOTE_SAVE_PVT dependencies on IBE_SH_QUOTE_ACCESS

Line 1185: FROM IBE_SH_QUOTE_ACCESS, fnd_user fnd

1181: cust_account_id,
1182: quote_sharee_number,
1183: contact_point_id,
1184: fnd.customer_id shared_by_party_id
1185: FROM IBE_SH_QUOTE_ACCESS, fnd_user fnd
1186: where quote_header_id = c_quote_header_id
1187: and ibe_sh_quote_access.created_by = fnd.user_id;
1188: rec_get_recipients c_get_recipients%rowtype;
1189: l_qte_access_rec IBE_QUOTE_SAVESHARE_pvt.quote_access_rec_type

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

1183: contact_point_id,
1184: fnd.customer_id shared_by_party_id
1185: FROM IBE_SH_QUOTE_ACCESS, fnd_user fnd
1186: where quote_header_id = c_quote_header_id
1187: and ibe_sh_quote_access.created_by = fnd.user_id;
1188: rec_get_recipients c_get_recipients%rowtype;
1189: l_qte_access_rec IBE_QUOTE_SAVESHARE_pvt.quote_access_rec_type
1190: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
1191:

Line 1220: FROM ibe_sh_quote_access

1216: -- need to delete contact point
1217: -- delete all shares need table handle and generate table handle
1218:
1219: /*DELETE
1220: FROM ibe_sh_quote_access
1221: WHERE quote_header_id = p_quote_header_id;*/
1222:
1223: FOR rec_get_recipients in c_get_recipients(p_Quote_HEADER_ID) LOOP
1224: l_qte_access_rec.quote_sharee_id := rec_get_recipients.quote_sharee_id;

Line 1341: from ibe_sh_quote_access

1337: where status_code = 'INACTIVE';
1338:
1339: cursor c_get_recip_id(c_qte_header_id number) is
1340: select quote_sharee_id
1341: from ibe_sh_quote_access
1342: where quote_header_id = c_qte_header_id;
1343:
1344: cursor c_get_party_id is
1345: select party_id, cust_account_id

Line 1389: from ibe_sh_quote_access

1385: -- if initiator is specified, and owner is not initiator,
1386: -- send a retieval number here and to the save call (if expunge=F)
1387: if ((p_initiator_party_id <> FND_API.G_MISS_NUM) and l_party_id <> p_initiator_party_id) then
1388: select quote_sharee_number into l_retrieval_number
1389: from ibe_sh_quote_access
1390: where party_id = p_initiator_party_id
1391: and quote_header_id = p_quote_header_id
1392: and cust_account_id = p_initiator_account_id;
1393: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 7320: from ibe_sh_quote_access

7316: AND publish_flag = 'Y';
7317:
7318: CURSOR c_is_shared_cart(c_quote_header_id NUMBER) IS
7319: select count(*) is_shared_cart
7320: from ibe_sh_quote_access
7321: where quote_header_id = c_quote_header_id;
7322:
7323: rec_is_shared_cart c_is_shared_cart%rowtype;
7324: rec_check_for_quote c_check_for_quote%rowtype;