eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.MSC_GET_NAME dependencies on FND_PROFILE

Line 3365: and category_set_id = fnd_profile.value('MSR_BUDGET_CATEGORY_SET')

3361: cursor category_id_c is
3362: select sr_category_id
3363: from msc_item_categories
3364: where category_name = p_category_name
3365: and category_set_id = fnd_profile.value('MSR_BUDGET_CATEGORY_SET')
3366: and rownum =1 ;
3367:
3368:
3369: cursor category_id_c1 is

Line 3373: and category_set_id = fnd_profile.value('MSR_BUDGET_CATEGORY_SET')

3369: cursor category_id_c1 is
3370: select sr_category_id
3371: from msc_item_categories
3372: where category_name = p_category_name
3373: and category_set_id = fnd_profile.value('MSR_BUDGET_CATEGORY_SET')
3374: and organization_id=p_org_id
3375: and sr_instance_id=p_inst_id
3376: and rownum =1 ;
3377:

Line 3382: and category_set_id = fnd_profile.value('MSR_BUDGET_CATEGORY_SET')

3378: cursor category_id_inst is
3379: select sr_category_id
3380: from msc_item_categories
3381: where category_name = p_category_name
3382: and category_set_id = fnd_profile.value('MSR_BUDGET_CATEGORY_SET')
3383: and sr_instance_id=p_inst_id
3384: and rownum =1 ;
3385:
3386: l_category_id number;

Line 4776: l_value := fnd_profile.value('MSC_SRA_CATEGORY_SET');

4772: open c_default_cat;
4773: fetch c_default_cat into l_value;
4774: close c_default_cat;
4775: if l_value is null then
4776: l_value := fnd_profile.value('MSC_SRA_CATEGORY_SET');
4777: end if;
4778: else
4779: l_key := null;
4780: open pref_def_c;

Line 6158: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_QTY'),2);

6154:
6155: begin
6156: case arg_number_type
6157: when 1 -- MSC_RP_DEC_QTY
6158: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_QTY'),2);
6159: when 2 -- MSC_RP_DEC_TIME
6160: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_TIME'),2);
6161: when 3 -- MSC_RP_DEC_QTY_AGG
6162: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_QTY_AGG'),0);

Line 6160: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_TIME'),2);

6156: case arg_number_type
6157: when 1 -- MSC_RP_DEC_QTY
6158: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_QTY'),2);
6159: when 2 -- MSC_RP_DEC_TIME
6160: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_TIME'),2);
6161: when 3 -- MSC_RP_DEC_QTY_AGG
6162: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_QTY_AGG'),0);
6163: when 4 -- MSC_RP_DEC_TIME_AGG
6164: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_TIME_AGG'),0);

Line 6162: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_QTY_AGG'),0);

6158: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_QTY'),2);
6159: when 2 -- MSC_RP_DEC_TIME
6160: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_TIME'),2);
6161: when 3 -- MSC_RP_DEC_QTY_AGG
6162: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_QTY_AGG'),0);
6163: when 4 -- MSC_RP_DEC_TIME_AGG
6164: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_TIME_AGG'),0);
6165: when 5 -- MSC_RP_DEC_CURR
6166: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_CURR'),2);

Line 6164: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_TIME_AGG'),0);

6160: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_TIME'),2);
6161: when 3 -- MSC_RP_DEC_QTY_AGG
6162: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_QTY_AGG'),0);
6163: when 4 -- MSC_RP_DEC_TIME_AGG
6164: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_TIME_AGG'),0);
6165: when 5 -- MSC_RP_DEC_CURR
6166: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_CURR'),2);
6167: when 6 -- MSC_RP_DEC_RATIO
6168: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_RATIO'),2);

Line 6166: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_CURR'),2);

6162: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_QTY_AGG'),0);
6163: when 4 -- MSC_RP_DEC_TIME_AGG
6164: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_TIME_AGG'),0);
6165: when 5 -- MSC_RP_DEC_CURR
6166: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_CURR'),2);
6167: when 6 -- MSC_RP_DEC_RATIO
6168: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_RATIO'),2);
6169: else dec_count:= 2;
6170:

Line 6168: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_RATIO'),2);

6164: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_TIME_AGG'),0);
6165: when 5 -- MSC_RP_DEC_CURR
6166: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_CURR'),2);
6167: when 6 -- MSC_RP_DEC_RATIO
6168: then dec_count:= nvl(fnd_profile.value('MSC_RP_DEC_RATIO'),2);
6169: else dec_count:= 2;
6170:
6171: end case;
6172: return trunc(arg_value,dec_count);

Line 6241: l_profile := fnd_profile.value('MSC_ASCP_IGNORE_CMRO_EAM_WO');

6237: FUNCTION IS_CMRO_EAM_INTG_ENABLED RETURN BOOLEAN IS
6238: l_response boolean:= false;
6239: l_profile number;
6240: begin
6241: l_profile := fnd_profile.value('MSC_ASCP_IGNORE_CMRO_EAM_WO');
6242: if nvl(l_profile,1) = 2 then
6243: l_response := true;
6244: end if;
6245: return l_response;