DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on IBE_SH_QUOTE_ACCESS

Line 4578: This API is tyo determine if the contact point is saved against IBE_SH_QUOTE_ACCESS or HZ_PARTIES

4574:
4575: END Get_Speciality_Store_name;*/
4576:
4577: /********************************************************
4578: This API is tyo determine if the contact point is saved against IBE_SH_QUOTE_ACCESS or HZ_PARTIES
4579: If the contact point is saved against IBE_SH_QUOTE_ACCESS then notifications will only be
4580: sent to ad-hoc users, otherwise they will be sent to users who will be identified by their party_id
4581: in the HZ_PARTIES table
4582: *********************************************************/

Line 4579: If the contact point is saved against IBE_SH_QUOTE_ACCESS then notifications will only be

4575: END Get_Speciality_Store_name;*/
4576:
4577: /********************************************************
4578: This API is tyo determine if the contact point is saved against IBE_SH_QUOTE_ACCESS or HZ_PARTIES
4579: If the contact point is saved against IBE_SH_QUOTE_ACCESS then notifications will only be
4580: sent to ad-hoc users, otherwise they will be sent to users who will be identified by their party_id
4581: in the HZ_PARTIES table
4582: *********************************************************/
4583: procedure locate_contact_point

Line 4595: if rec_contact_point.owner_table_name = 'IBE_SH_QUOTE_ACCESS' then

4591:
4592: begin
4593:
4594: for rec_contact_point in c_contact_point loop
4595: if rec_contact_point.owner_table_name = 'IBE_SH_QUOTE_ACCESS' then
4596: x_create_adhoc_flag := FND_API.G_TRUE;
4597: end if;
4598: exit when c_contact_point%notfound;
4599: end loop;

Line 4665: from ibe_sh_quote_access

4661: CURSOR c_b2c_sharing(c_retrieval_number number) is
4662: select quote_name
4663: from aso_quote_headers_all
4664: where quote_header_id = (select quote_header_id
4665: from ibe_sh_quote_access
4666: where quote_sharee_number = c_retrieval_number);
4667: CURSOR c_get_recip_name(c_retrieval_number number) is
4668: select recipient_name
4669: from ibe_sh_quote_access

Line 4669: from ibe_sh_quote_access

4665: from ibe_sh_quote_access
4666: where quote_sharee_number = c_retrieval_number);
4667: CURSOR c_get_recip_name(c_retrieval_number number) is
4668: select recipient_name
4669: from ibe_sh_quote_access
4670: where quote_sharee_number = c_retrieval_number;
4671:
4672: rec_msite_name C_MSITE_NAME%ROWTYPE;
4673: rec_b2c_sharing c_b2c_sharing%ROWTYPE;