APPS.MSC_HORIZONTAL_PLAN_SC dependencies on FND_PROFILE

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

2731: l_customer_prg varchar2(500);
2732: l_statement varchar2(1000);
2733:
2734: BEGIN
2735: l_customer_prg := FND_PROFILE.value('MSC_HP_EXTENSION_PROGRAM');
2736: if l_customer_prg is not null then
2737: l_statement :=
2738: ' begin ' || l_customer_prg|| '(' || arg_query_id || '); end;';
2739: EXECUTE IMMEDIATE l_statement;

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

2834: sr_instance_id2 <> sr_instance_id)
2835: and organization_id <> -1;
2836:
2837: p_item_limit number :=
2838: nvl(fnd_profile.value('MSC_HP_ITEM_LIMIT'),30);
2839: p_org_exist boolean;
2840:
2841: BEGIN
2842:

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

3229:
3230: l_plan_start_date date;
3231: l_plan_type number;
3232: l_optimized_plan number;
3233: l_dock_date_prof number := nvl(FND_PROFILE.Value('MSC_PO_DOCK_DATE_CALC_PREF'),1);
3234:
3235: cursor item_record is
3236: select distinct number2,number1
3237: from msc_form_query