DBA Data[Home] [Help]

APPS.ENG_ECO_UTIL dependencies on FND_PROFILE

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

964: l_api_name CONSTANT VARCHAR2(30) := 'Reschedule_ECO';
965: l_api_version CONSTANT NUMBER := 1.0;
966: l_return_status VARCHAR2(1);
967:
968: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
969: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
970: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
971: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
972: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');

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

965: l_api_version CONSTANT NUMBER := 1.0;
966: l_return_status VARCHAR2(1);
967:
968: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
969: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
970: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
971: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
972: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
973: X_Model NUMBER := 1;

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

966: l_return_status VARCHAR2(1);
967:
968: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
969: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
970: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
971: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
972: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
973: X_Model NUMBER := 1;
974: X_OptionClass NUMBER := 2;

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

967:
968: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
969: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
970: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
971: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
972: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
973: X_Model NUMBER := 1;
974: X_OptionClass NUMBER := 2;
975: X_Planning NUMBER := 3;

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

968: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
969: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
970: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
971: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
972: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
973: X_Model NUMBER := 1;
974: X_OptionClass NUMBER := 2;
975: X_Planning NUMBER := 3;
976: X_Standard NUMBER := 4;

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

1377: l_api_name CONSTANT VARCHAR2(30) := 'Change_Effectivity_Date';
1378: l_api_version CONSTANT NUMBER := 1.0;
1379: l_return_status VARCHAR2(1);
1380:
1381: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
1382: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
1383: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
1384: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
1385: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');

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

1378: l_api_version CONSTANT NUMBER := 1.0;
1379: l_return_status VARCHAR2(1);
1380:
1381: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
1382: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
1383: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
1384: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
1385: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
1386: X_Model NUMBER := 1;

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

1379: l_return_status VARCHAR2(1);
1380:
1381: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
1382: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
1383: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
1384: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
1385: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
1386: X_Model NUMBER := 1;
1387: X_OptionClass NUMBER := 2;

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

1380:
1381: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
1382: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
1383: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
1384: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
1385: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
1386: X_Model NUMBER := 1;
1387: X_OptionClass NUMBER := 2;
1388: X_Planning NUMBER := 3;

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

1381: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
1382: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
1383: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
1384: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
1385: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
1386: X_Model NUMBER := 1;
1387: X_OptionClass NUMBER := 2;
1388: X_Planning NUMBER := 3;
1389: X_Standard NUMBER := 4;

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

2463: THEN
2464: --
2465: -- Get respective profile values
2466: --
2467: IF fnd_profile.value('BOM:STANDARD_ITEM_ACCESS') = '1'
2468: THEN
2469: Eng_Globals.Set_STD_Item_Access
2470: ( p_std_item_access => 4);
2471: ELSE

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

2472: Eng_Globals.Set_STD_Item_Access
2473: ( p_std_item_access => NULL);
2474: END IF;
2475:
2476: IF fnd_profile.value('BOM:MODEL_ITEM_ACCESS') = '1'
2477: THEN
2478: Eng_Globals.Set_MDL_Item_Access
2479: ( p_mdl_item_access => 1);
2480: Eng_Globals.Set_OC_Item_Access

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

2485: Eng_Globals.Set_OC_Item_Access
2486: ( p_oc_item_access => NULL);
2487: END IF;
2488:
2489: IF fnd_profile.value('BOM:PLANNING_ITEM_ACCESS') = '1'
2490: THEN
2491: Eng_Globals.Set_PLN_Item_Access
2492: ( p_pln_item_access => 3);
2493: ELSE