DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on IBE_SH_QUOTE_ACCESS

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

4669:
4670: END Get_Speciality_Store_name;*/
4671:
4672: /********************************************************
4673: This API is tyo determine if the contact point is saved against IBE_SH_QUOTE_ACCESS or HZ_PARTIES
4674: If the contact point is saved against IBE_SH_QUOTE_ACCESS then notifications will only be
4675: sent to ad-hoc users, otherwise they will be sent to users who will be identified by their party_id
4676: in the HZ_PARTIES table
4677: *********************************************************/

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

4670: END Get_Speciality_Store_name;*/
4671:
4672: /********************************************************
4673: This API is tyo determine if the contact point is saved against IBE_SH_QUOTE_ACCESS or HZ_PARTIES
4674: If the contact point is saved against IBE_SH_QUOTE_ACCESS then notifications will only be
4675: sent to ad-hoc users, otherwise they will be sent to users who will be identified by their party_id
4676: in the HZ_PARTIES table
4677: *********************************************************/
4678: procedure locate_contact_point

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

4686:
4687: begin
4688:
4689: for rec_contact_point in c_contact_point loop
4690: if rec_contact_point.owner_table_name = 'IBE_SH_QUOTE_ACCESS' then
4691: x_create_adhoc_flag := FND_API.G_TRUE;
4692: end if;
4693: exit when c_contact_point%notfound;
4694: end loop;

Line 4760: from ibe_sh_quote_access

4756: CURSOR c_b2c_sharing(c_retrieval_number number) is
4757: select quote_name
4758: from aso_quote_headers_all
4759: where quote_header_id = (select quote_header_id
4760: from ibe_sh_quote_access
4761: where quote_sharee_number = c_retrieval_number);
4762: CURSOR c_get_recip_name(c_retrieval_number number) is
4763: select recipient_name
4764: from ibe_sh_quote_access

Line 4764: from ibe_sh_quote_access

4760: from ibe_sh_quote_access
4761: where quote_sharee_number = c_retrieval_number);
4762: CURSOR c_get_recip_name(c_retrieval_number number) is
4763: select recipient_name
4764: from ibe_sh_quote_access
4765: where quote_sharee_number = c_retrieval_number;
4766:
4767: rec_msite_name C_MSITE_NAME%ROWTYPE;
4768: rec_b2c_sharing c_b2c_sharing%ROWTYPE;