APPS.MRP_SOURCING_API_PK dependencies on FND_PROFILE

Line 4: p_cutoff_history_days NUMBER := NVL(TO_NUMBER(FND_PROFILE.VALUE('MRP_CUTOFF_HISTORY_DAYS')),9999);

1: PACKAGE BODY MRP_SOURCING_API_PK AS
2: /* $Header: MRPSAPIB.pls 120.2 2006/03/08 04:50:40 davashia noship $ */
3:
4: p_cutoff_history_days NUMBER := NVL(TO_NUMBER(FND_PROFILE.VALUE('MRP_CUTOFF_HISTORY_DAYS')),9999);
5: mrdebug BOOLEAN := FALSE;
6: cutoff_history_date NUMBER := to_number(to_char(trunc(SYSDATE),'j')) - p_cutoff_history_days;
7:
8: FUNCTION validate_item(

Line 20: mrdebug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';

16: var_stk VARCHAR2(10);
17: var_restrict NUMBER;
18: BEGIN
19:
20: mrdebug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
21: SELECT stock_enabled_flag, restrict_subinventories_code
22: INTO var_stk,
23: var_restrict
24: FROM mtl_system_items

Line 116: mrdebug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';

112: arg_error_message := null;
113: /* arg_source_organization_id := null; */
114: arg_vendor_id := null;
115: arg_vendor_site_code := null;
116: mrdebug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
117:
118: /*------------------------------------------------------------+
119: | First check the item-sub level if the mode is Inventory |
120: | or both |

Line 307: TO_NUMBER(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));

303: | before checking MRP sources get the |
304: | default assignment set id |
305: +-----------------------------------------*/
306: var_set_id :=
307: TO_NUMBER(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
308:
309: if var_set_id is null
310: then
311: fnd_message.set_name('MRP', 'MRCONC-CANNOT GET PROFILE');