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 1795: AND ORGANIZATION_ID = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_key3);

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

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

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