APPS.MSC_HORIZONTAL_PLAN_SC dependencies on FND_PROFILE

Line 2555: l_customer_prg := FND_PROFILE.value('MSC_HP_EXTENSION_PROGRAM');

2551: l_customer_prg varchar2(500);
2552: l_statement varchar2(1000);
2553:
2554: BEGIN
2555: l_customer_prg := FND_PROFILE.value('MSC_HP_EXTENSION_PROGRAM');
2556: if l_customer_prg is not null then
2557: l_statement :=
2558: ' begin ' || l_customer_prg|| '(' || arg_query_id || '); end;';
2559: EXECUTE IMMEDIATE l_statement;

Line 2658: nvl(fnd_profile.value('MSC_HP_ITEM_LIMIT'),30);

2654: sr_instance_id2 <> sr_instance_id)
2655: and organization_id <> -1;
2656:
2657: p_item_limit number :=
2658: nvl(fnd_profile.value('MSC_HP_ITEM_LIMIT'),30);
2659: p_org_exist boolean;
2660:
2661: BEGIN
2662:

Line 3049: l_dock_date_prof number := nvl(FND_PROFILE.Value('MSC_PO_DOCK_DATE_CALC_PREF'),1);

3045:
3046: l_plan_start_date date;
3047: l_plan_type number;
3048: l_optimized_plan number;
3049: l_dock_date_prof number := nvl(FND_PROFILE.Value('MSC_PO_DOCK_DATE_CALC_PREF'),1);
3050:
3051: cursor item_record is
3052: select distinct number2,number1
3053: from msc_form_query