APPS.MSC_X_HZ_PLAN dependencies on FND_PROFILE

Line 2722: and category_set_id = FND_PROFILE.VALUE('MSCX_CP_HZ_CATEGORY_SET');

2718: IS
2719: SELECT distinct inventory_item_id
2720: FROM msc_item_categories
2721: where category_name = arg_category_name
2722: and category_set_id = FND_PROFILE.VALUE('MSCX_CP_HZ_CATEGORY_SET');
2723:
2724: BEGIN
2725:
2726:

Line 2744: l_query_id,sysdate,fnd_profile.value('USER_ID'),sysdate,fnd_profile.value('USER_ID'),null,

2740: REQUEST_ID,CHAR1,CHAR2,CHAR3,CHAR4,CHAR5,CHAR6,CHAR7,CHAR8,CHAR9,PROGRAM_UPDATE_DATE,
2741: PROGRAM_APPLICATION_ID,PROGRAM_ID,NUMBER16,CHAR10,CHAR11,CHAR12,CHAR13,CHAR14,CHAR15 )
2742: VALUES
2743: (
2744: l_query_id,sysdate,fnd_profile.value('USER_ID'),sysdate,fnd_profile.value('USER_ID'),null,
2745: null,null,null,null,null,null,null,null, l_item_id,null,null,null,null,
2746: null,null,null,null,null,null,null,null,null,null,
2747: null,null,null,null,null,null,null,null,null,null,null,
2748: null,null,null,null,null,null,null,null,null

Line 3986: v_default_cal_code := FND_PROFILE.VALUE('MSC_X_DEFAULT_CALENDAR');

3982: v_graphtitle := get_lookup_name('MSC_X_GRAPH_OPTION', v_graphtype);
3983: end if;
3984:
3985: --get the default calendar
3986: v_default_cal_code := FND_PROFILE.VALUE('MSC_X_DEFAULT_CALENDAR');
3987: --v_default_cal_code := 'CP-Mon-70';
3988:
3989:
3990: -- get the buckets with default calendar and initialise the array