DBA Data[Home] [Help]

APPS.ECEPOI dependencies on OE_SYS_PARAMETERS

Line 169: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG',l_orgid);

165: from hz_cust_acct_sites st, hz_cust_site_uses_all su
166: where st.cust_acct_site_id = p_address_id
167: and su.cust_acct_site_id = st.cust_acct_site_id
168: and su.site_use_code= 'SHIP_TO' and rownum =1;
169: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG',l_orgid);
170: If nvl(lcustomer_relations ,'N') = 'N' Then
171: SELECT site_use_id
172: INTO l_site_use_id
173: FROM oe_ship_to_orgs_v

Line 213: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG',l_orgid);

209: from hz_cust_acct_sites st, hz_cust_site_uses_all su
210: where st.cust_acct_site_id = p_address_id
211: and su.cust_acct_site_id = st.cust_acct_site_id
212: and su.site_use_code= 'BILL_TO' and rownum =1;
213: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG',l_orgid);
214: If nvl(lcustomer_relations ,'N') = 'N' Then
215: SELECT site_use_id
216: INTO l_site_use_id
217: FROM oe_invoice_to_orgs_v

Line 494: l_organization_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_org_id);

490: ec_debug.pl(3,'Sold to Org ID ',p_sold_to_org_id);
491: ec_debug.pl(3,'Org ID ',p_org_id);
492: ec_debug.pl(3,'Ordered Item ',p_ordered_item);
493:
494: l_organization_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_org_id);
495: ec_debug.pl(3,'Organization ID ',l_organization_ID);
496:
497: IF (p_item_identifier_type) = 'INT' THEN
498: SELECT description