APPS.MSC_CL_GMP_UTILITY dependencies on FND_PROFILE

Line 1467: um_code_cursor := ' select fnd_profile.VALUE' ||at_apps_link

1463: /* The query is being modified to incorporate changes for 1830940 */
1464: /* B2989806 Added inline tables and outer joins to select aps_fmeff_id */
1465:
1466: /* NAMIT UOM Change, This should come from source */
1467: um_code_cursor := ' select fnd_profile.VALUE' ||at_apps_link
1468: ||' (''SY$UOM_HOURS'') from dual ' ; /* OPM UOM */
1469:
1470: OPEN um_code_ref FOR um_code_cursor ;
1471: FETCH um_code_ref INTO l_gmp_um_code;

Line 7135: um_code_cursor := ' select fnd_profile.VALUE' ||at_apps_link

7131: stmt_no := 0 ;
7132: Zero_tran := NULL ;
7133: fact_tran := NULL ;
7134: rsrc_setup := NULL ;
7135: um_code_cursor := ' select fnd_profile.VALUE' ||at_apps_link
7136: ||' (''BOM:HOUR_UOM_CODE'') from dual ' ;
7137:
7138: OPEN um_code_ref FOR um_code_cursor ;
7139: FETCH um_code_ref INTO l_profile;

Line 8106: IF NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N')= 'N' THEN

8102:
8103:
8104: /* Get the profile value for inflating usage by the utilization and
8105: efficiency */
8106: IF NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N')= 'N' THEN
8107: v_inflate_wip := 0 ;
8108: ELSE
8109: v_inflate_wip := 1 ;
8110: END IF;

Line 8113: um_code_cursor := ' select fnd_profile.VALUE' ||pdblink

8109: v_inflate_wip := 1 ;
8110: END IF;
8111:
8112: /* NAMIT UOM Change, This should come from source */
8113: um_code_cursor := ' select fnd_profile.VALUE' ||pdblink
8114: ||' (''SY$UOM_HOURS'') from dual ' ; /* OPM UOM */
8115:
8116: OPEN um_code_ref FOR um_code_cursor ;
8117: FETCH um_code_ref INTO l_gmp_um_code;

Line 10424: ex_code_cursor := ' select NVL(fnd_profile.VALUE' ||pdblink

10420: time_stamp ;
10421:
10422: /* Bug # 5238790 */
10423: l_profile := 0 ;
10424: ex_code_cursor := ' select NVL(fnd_profile.VALUE' ||pdblink
10425: ||' (''GMP_COLLECT_EXPR_ONHAND''),0) from dual ' ;
10426:
10427: OPEN ex_code_ref FOR ex_code_cursor ;
10428: FETCH ex_code_ref INTO l_profile;

Line 10432: mx_code_cursor := ' select to_date(fnd_profile.VALUE' ||pdblink

10428: FETCH ex_code_ref INTO l_profile;
10429: CLOSE ex_code_ref;
10430:
10431: /* B5501754 */
10432: mx_code_cursor := ' select to_date(fnd_profile.VALUE' ||pdblink
10433: ||' (''SY$MAX_DATE''),''YYYY/MM/DD'') from dual ' ;
10434:
10435: OPEN mx_code_ref FOR mx_code_cursor ;
10436: FETCH mx_code_ref INTO sy_max_date;

Line 10813: ex_code_cursor := ' select NVL(fnd_profile.VALUE' ||pdblink

10809: time_stamp ;
10810: pdoc_type := 'XFER';
10811: /* Bug # 5238790 */
10812: l_profile := 0 ;
10813: ex_code_cursor := ' select NVL(fnd_profile.VALUE' ||pdblink
10814: ||' (''GMP_COLLECT_EXPR_ONHAND''),0) from dual ' ;
10815:
10816: OPEN ex_code_ref FOR ex_code_cursor ;
10817: FETCH ex_code_ref INTO l_profile;

Line 10916: ex_code_cursor := ' select NVL(fnd_profile.VALUE' ||pdblink

10912: pdoc_type := 'XFER';
10913:
10914: /* Bug # 5238790 */
10915: l_profile := 0 ;
10916: ex_code_cursor := ' select NVL(fnd_profile.VALUE' ||pdblink
10917: ||' (''GMP_COLLECT_EXPR_ONHAND''),0) from dual ' ;
10918:
10919: OPEN ex_code_ref FOR ex_code_cursor ;
10920: FETCH ex_code_ref INTO l_profile;

Line 11318: ex_code_cursor := ' select NVL(fnd_profile.VALUE' ||pdblink

11314: g_instance_id := pinstance_id ;
11315:
11316: /* Bug # 5238790 */
11317: l_profile := 0 ;
11318: ex_code_cursor := ' select NVL(fnd_profile.VALUE' ||pdblink
11319: ||' (''GMP_COLLECT_EXPR_ONHAND''),0) from dual ' ;
11320:
11321: OPEN ex_code_ref FOR ex_code_cursor ;
11322: FETCH ex_code_ref INTO l_profile;

Line 11709: ic_code_cursor := ' select fnd_profile.VALUE' ||pdblink

11705: pdoc_type := 'OMSO' ;
11706: l_profile := NULL ;
11707:
11708: /* This profile value holds the Defualt Location */
11709: ic_code_cursor := ' select fnd_profile.VALUE' ||pdblink
11710: ||' (''IC$DEFAULT_LOCT'') from dual ' ;
11711:
11712: OPEN ic_code_ref FOR ic_code_cursor ;
11713: FETCH ic_code_ref INTO l_profile;

Line 11716: bs_code_cursor := ' select fnd_profile.VALUE' ||pdblink

11712: OPEN ic_code_ref FOR ic_code_cursor ;
11713: FETCH ic_code_ref INTO l_profile;
11714: CLOSE ic_code_ref;
11715:
11716: bs_code_cursor := ' select fnd_profile.VALUE' ||pdblink
11717: ||' (''BIS_PRIMARY_RATE_TYPE'') from dual ' ;
11718:
11719: OPEN bs_code_ref FOR bs_code_cursor ;
11720: FETCH bs_code_ref INTO b_profile;

Line 13600: l_user_id := to_number(FND_PROFILE.VALUE('USER_ID'));

13596: old_resource_id := -1;
13597: old_instance_id := -1;
13598: lsetup_updated := TRUE;
13599:
13600: l_user_id := to_number(FND_PROFILE.VALUE('USER_ID'));
13601:
13602: X_select := ' SELECT '
13603: ||' gbsr.sequence_dependent_id, '
13604: ||' crd.resource_id, '