APPS.OE_CNCL_VALUE_TO_ID dependencies on OE_SYS_PARAMETERS

Line 401: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');

397: RETURN NULL;
398: END IF;
399:
400:
401: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
402: IF l_debug_level > 0 THEN
403: oe_debug_pub.add( 'CUSTOMER RELATIONS='||LCUSTOMER_RELATIONS ) ;
404: END IF;
405:

Line 1078: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');

1074: OR p_invoice_to_org IS NULL
1075: THEN
1076: RETURN NULL;
1077: END IF;
1078: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
1079:
1080: IF lcustomer_relations = 'N' THEN
1081:
1082: OPEN c_invoice_to_org_id;

Line 1931: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');

1927: THEN
1928: RETURN NULL;
1929: END IF;
1930:
1931: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
1932:
1933: IF lcustomer_relations = 'N' THEN
1934: OPEN c_ship_to_org_id;
1935: FETCH c_ship_to_org_id

Line 2568: AND organization_id = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

2564: FROM mtl_system_items_vl
2565: WHERE concatenated_segments =p_inventory_item
2566: AND customer_order_enabled_flag = 'Y'
2567: AND bom_item_type in (1,2,4)
2568: AND organization_id = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2569:
2570: RETURN l_id;
2571:
2572: EXCEPTION