[Home] [Help]
1536: /* The query is being modified to incorporate changes for 1830940 */
1537: /* B2989806 Added inline tables and outer joins to select aps_fmeff_id */
1538:
1539: /* NAMIT UOM Changes */
1540: -- l_gmp_um_code := fnd_profile.VALUE('SY$UOM_HOURS'); /* OPM UOM */
1541: l_gmp_um_code := get_profile_value('SY$UOM_HOURS', at_apps_link );
1542:
1543: IF l_gmp_um_code IS NOT NULL THEN
1544: /* Get the UOM code and UOM Class corresponding to "GMP: UOM for Hour" Profile */
7613: rsrc_setup := NULL ;
7614: /* bug: 6710684 Vpedarla making changes to take the profile value from source server
7615: and also made changes to use procedure get_profile_value */
7616: -- commented the below code line
7617: -- l_profile := FND_PROFILE.VALUE('BOM:HOUR_UOM_CODE');
7618: l_profile := get_profile_value('BOM:HOUR_UOM_CODE' , at_apps_link);
7619:
7620: -- ZERO Transitions (Alternate Resources are considered)
7621: stmt_no := 910 ;
8118: LOG_MESSAGE(' get_profile_value called for profile '
8119: ||profile_name||' with dblink '||pdblink);
8120:
8121: uom_code_dblink :=
8122: 'SELECT fnd_profile.VALUE'||pdblink||'('''||profile_name||''')'||' FROM dual ';
8123:
8124: OPEN uom_code_ref for uom_code_dblink ;
8125: FETCH uom_code_ref INTO l_gmp_um_code;
8126: CLOSE uom_code_ref;
8643: END; -- B6795244
8644:
8645: /* Get the profile value for inflating usage by the utilization and
8646: efficiency from destination */
8647: IF NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N')= 'N' THEN
8648: v_inflate_wip := 0 ;
8649: ELSE
8650: v_inflate_wip := 1 ;
8651: END IF;
8651: END IF;
8652:
8653: /* NAMIT UOM Changes */
8654: /* bug:6710684 Vpedarla made changes to fetch the profile value from source server*/
8655: -- l_gmp_um_code := fnd_profile.VALUE('SY$UOM_HOURS'); /* OPM UOM */
8656: l_gmp_um_code := get_profile_value('SY$UOM_HOURS', pdblink );
8657:
8658: IF l_gmp_um_code IS NOT NULL THEN
8659: /* Get the UOM code and UOM Class corresponding to "GMP: UOM for Hour" Profile */
11078:
11079: /* Bug # 5238790 */
11080: l_profile := 0 ;
11081:
11082: -- l_profile := NVL(FND_PROFILE.VALUE('GMP_COLLECT_EXPR_ONHAND'),0) ;
11083: /* bug:6710684 Vpedarla made changes to fetch the profile value from source server*/
11084: l_profile := NVL(get_profile_value('GMP_COLLECT_EXPR_ONHAND', pdblink ),0);
11085:
11086: onhand_count := 1;
11086: onhand_count := 1;
11087: v_onhand_cursor := NULL;
11088: insert_count := 1;
11089:
11090: -- sy_max_date := to_date(FND_PROFILE.VALUE('SY$MAX_DATE'),'YYYY/MM/DD'); -- Bug:6030499 Vpedarla
11091: /* bug:6710684 Vpedarla made changes to fetch the profile value from source server*/
11092: sy_max_date := to_date(get_profile_value('SY$MAX_DATE', pdblink ),'YYYY/MM/DD');
11093:
11094: /* Query to select the production order details where the batch/fpo is pending
11496: pdoc_type := 'XFER';
11497: /* Bug # 5238790 */
11498: l_profile := 0 ;
11499:
11500: -- l_profile := nvl(FND_PROFILE.VALUE('GMP_COLLECT_EXPR_ONHAND'),0) ;
11501: /* bug:6710684 Vpedarla made changes to fetch the profile value from source server*/
11502: l_profile := NVL(get_profile_value('GMP_COLLECT_EXPR_ONHAND', pdblink ),0);
11503:
11504: --Bug: 6030499 Vpedarla
11665: pdoc_type := 'XFER';
11666:
11667: /* Bug # 5238790 */
11668: l_profile := 0 ;
11669: -- l_profile := nvl(FND_PROFILE.VALUE('GMP_COLLECT_EXPR_ONHAND'),0) ;
11670: /* bug:6710684 Vpedarla made changes to fetch the profile value from source server*/
11671: l_profile := NVL(get_profile_value('GMP_COLLECT_EXPR_ONHAND', pdblink ),0);
11672:
11673: return_status := TRUE ;
12067: g_instance_id := pinstance_id ;
12068:
12069: /* Bug # 5238790 */
12070: l_profile := 0 ;
12071: -- l_profile := nvl(FND_PROFILE.VALUE('GMP_COLLECT_EXPR_ONHAND'),0) ;
12072: /* bug:6710684 Vpedarla made changes to fetch the profile value from source server*/
12073: l_profile := NVL(GMP_BOM_ROUTING_PKG.get_profile_value('GMP_COLLECT_EXPR_ONHAND', pdblink ),0);
12074:
12075: IF api_mode THEN
12481:
12482: log_message('Entering into the Program, Begin ');
12483:
12484: /* This profile value holds the Defualt Location */
12485: -- l_profile := FND_PROFILE.value('IC$DEFAULT_LOCT') ;
12486: /* bug:6710684 Vpedarla made changes to fetch the profile value from source server*/
12487: l_profile := GMP_BOM_ROUTING_PKG.get_profile_value('IC$DEFAULT_LOCT', pdblink );
12488:
12489: log_message('Default Location = ' || l_profile );
12487: l_profile := GMP_BOM_ROUTING_PKG.get_profile_value('IC$DEFAULT_LOCT', pdblink );
12488:
12489: log_message('Default Location = ' || l_profile );
12490:
12491: -- b_profile := fnd_profile.value('BIS_PRIMARY_RATE_TYPE') ;
12492: /* bug:6710684 Vpedarla made changes to fetch the profile value from source server*/
12493: b_profile := GMP_BOM_ROUTING_PKG.get_profile_value('BIS_PRIMARY_RATE_TYPE', pdblink );
12494:
12495: log_message('Primary Rate = ' || b_profile);
14391: old_resource_id := -1;
14392: old_instance_id := -1;
14393: lsetup_updated := TRUE;
14394:
14395: l_user_id := to_number(FND_PROFILE.VALUE('USER_ID'));
14396:
14397: X_select := ' SELECT '
14398: ||' gbsr.sequence_dependent_id, '
14399: ||' crd.resource_id, '