DBA Data[Home] [Help]

APPS.ENG_ECO_UTIL dependencies on FND_PROFILE

Line 1355: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));

1351: l_api_name CONSTANT VARCHAR2(30) := 'Reschedule_ECO';
1352: l_api_version CONSTANT NUMBER := 1.0;
1353: l_return_status VARCHAR2(1);
1354:
1355: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
1356: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
1357: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
1358: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
1359: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');

Line 1356: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));

1352: l_api_version CONSTANT NUMBER := 1.0;
1353: l_return_status VARCHAR2(1);
1354:
1355: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
1356: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
1357: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
1358: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
1359: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
1360: X_Model NUMBER := 1;

Line 1357: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');

1353: l_return_status VARCHAR2(1);
1354:
1355: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
1356: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
1357: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
1358: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
1359: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
1360: X_Model NUMBER := 1;
1361: X_OptionClass NUMBER := 2;

Line 1358: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');

1354:
1355: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
1356: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
1357: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
1358: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
1359: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
1360: X_Model NUMBER := 1;
1361: X_OptionClass NUMBER := 2;
1362: X_Planning NUMBER := 3;

Line 1359: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');

1355: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
1356: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
1357: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
1358: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
1359: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
1360: X_Model NUMBER := 1;
1361: X_OptionClass NUMBER := 2;
1362: X_Planning NUMBER := 3;
1363: X_Standard NUMBER := 4;

Line 1768: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));

1764: l_api_name CONSTANT VARCHAR2(30) := 'Change_Effectivity_Date';
1765: l_api_version CONSTANT NUMBER := 1.0;
1766: l_return_status VARCHAR2(1);
1767:
1768: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
1769: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
1770: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
1771: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
1772: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');

Line 1769: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));

1765: l_api_version CONSTANT NUMBER := 1.0;
1766: l_return_status VARCHAR2(1);
1767:
1768: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
1769: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
1770: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
1771: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
1772: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
1773: X_Model NUMBER := 1;

Line 1770: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');

1766: l_return_status VARCHAR2(1);
1767:
1768: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
1769: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
1770: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
1771: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
1772: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
1773: X_Model NUMBER := 1;
1774: X_OptionClass NUMBER := 2;

Line 1771: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');

1767:
1768: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
1769: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
1770: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
1771: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
1772: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
1773: X_Model NUMBER := 1;
1774: X_OptionClass NUMBER := 2;
1775: X_Planning NUMBER := 3;

Line 1772: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');

1768: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
1769: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
1770: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
1771: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
1772: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
1773: X_Model NUMBER := 1;
1774: X_OptionClass NUMBER := 2;
1775: X_Planning NUMBER := 3;
1776: X_Standard NUMBER := 4;

Line 2894: IF fnd_profile.value('BOM:STANDARD_ITEM_ACCESS') = '1'

2890: THEN
2891: --
2892: -- Get respective profile values
2893: --
2894: IF fnd_profile.value('BOM:STANDARD_ITEM_ACCESS') = '1'
2895: THEN
2896: Eng_Globals.Set_STD_Item_Access
2897: ( p_std_item_access => 4);
2898: ELSE

Line 2903: IF fnd_profile.value('BOM:MODEL_ITEM_ACCESS') = '1'

2899: Eng_Globals.Set_STD_Item_Access
2900: ( p_std_item_access => NULL);
2901: END IF;
2902:
2903: IF fnd_profile.value('BOM:MODEL_ITEM_ACCESS') = '1'
2904: THEN
2905: Eng_Globals.Set_MDL_Item_Access
2906: ( p_mdl_item_access => 1);
2907: Eng_Globals.Set_OC_Item_Access

Line 2916: IF fnd_profile.value('BOM:PLANNING_ITEM_ACCESS') = '1'

2912: Eng_Globals.Set_OC_Item_Access
2913: ( p_oc_item_access => NULL);
2914: END IF;
2915:
2916: IF fnd_profile.value('BOM:PLANNING_ITEM_ACCESS') = '1'
2917: THEN
2918: Eng_Globals.Set_PLN_Item_Access
2919: ( p_pln_item_access => 3);
2920: ELSE