DBA Data[Home] [Help]

APPS.OE_ORDER_CACHE dependencies on OE_SYS_PARAMETERS

Line 1012: l_set_of_books_id := OE_Sys_Parameters.VALUE('SET_OF_BOOKS_ID');

1008:
1009: -- Get set_of_books_id from profile option.
1010:
1011: --l_set_of_books_id := FND_PROFILE.VALUE('OE_SET_OF_BOOKS_ID');
1012: l_set_of_books_id := OE_Sys_Parameters.VALUE('SET_OF_BOOKS_ID');
1013:
1014:
1015: IF l_set_of_books_id IS NOT NULL THEN
1016:

Line 1535: l_key2 := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_key3);

1531: oe_debug_pub.add('Entering OE_ORDER_CACHE.Load_Item'||p_key3, 1);
1532: end if;
1533:
1534: -- Always store validation_org in l_key2.
1535: l_key2 := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_key3);
1536:
1537: if l_debug_level > 0 then
1538: OE_DEBUG_PUB.ADD('p_key1 is' || p_key1, 3);
1539: OE_DEBUG_PUB.ADD('prev item: ' || g_item_rec.inventory_item_id, 3);

Line 1793: AND ORGANIZATION_ID = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_key3);

1789: ,g_item_rec.restrict_subinventories_code
1790:
1791: FROM MTL_SYSTEM_ITEMS
1792: WHERE INVENTORY_ITEM_ID = p_key1
1793: AND ORGANIZATION_ID = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_key3);
1794:
1795: if l_debug_level > 0 then
1796: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_ITEM - item doesnt exist in ship_from', 2);
1797: end if;

Line 2312: l_set_of_books_id := OE_Sys_Parameters.VALUE('SET_OF_BOOKS_ID');

2308: Return Number
2309: IS
2310: l_set_of_books_id Number;
2311: BEGIN
2312: l_set_of_books_id := OE_Sys_Parameters.VALUE('SET_OF_BOOKS_ID');
2313:
2314: RETURN l_set_of_books_id;
2315: END Get_Set_Of_Books;
2316: