DBA Data[Home] [Help]

APPS.GMP_APS_DS_PULL dependencies on FND_PROFILE

Line 8: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('GMP_DEBUG_ENABLED'),'N'); -- BUG: 8420747

4: /* Define Exceptions */
5: invalid_string_value EXCEPTION;
6: invalid_gmp_uom_profile EXCEPTION;
7:
8: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('GMP_DEBUG_ENABLED'),'N'); -- BUG: 8420747
9:
10: /* Record definition for the a line in a production order. */
11: TYPE product_typ IS RECORD(
12: batch_no VARCHAR2(32),

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

975:
976:
977: /* Get the profile value for inflating usage by the utilization and
978: efficiency */
979: IF NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N')= 'N' THEN
980: v_inflate_wip := 0 ;
981: ELSE
982: v_inflate_wip := 1 ;
983: END IF;

Line 989: IF NVL(FND_PROFILE.VALUE('GMP_WIP_BATCH_YIELD'),'N') = 'N' THEN

985: -- For alcoa Issue 13097786 Starts
986: -- Profile: Collect WiP Batches when Output is Over OR Fully yielded
987: -- Default Value = 'Yes'
988:
989: IF NVL(FND_PROFILE.VALUE('GMP_WIP_BATCH_YIELD'),'N') = 'N' THEN
990: -- Do not collect ('N'), Aloca need to set it to 'No'
991: v_Overyielded_wip := 0 ;
992: log_message('GMP:Collect WiP Batches when Output is Over OR Fully yielded = No' );
993: ELSE

Line 1003: -- l_gmp_um_code := fnd_profile.VALUE('BOM:HOUR_UOM_CODE'); /* OPM UOM */

999: -- For alcoa Issue 13097786 Ends
1000:
1001: /* Not pick the "GMP:UOM for Hour" Profile and pick "BOM:UOM for Hour" profile. */
1002: /* bug:6710684 Vpedarla made changes to fetch the profile value from source server*/
1003: -- l_gmp_um_code := fnd_profile.VALUE('BOM:HOUR_UOM_CODE'); /* OPM UOM */
1004: l_gmp_um_code := GMP_BOM_ROUTING_PKG.get_profile_value('BOM:HOUR_UOM_CODE', pdblink );
1005: /* bug: 6710684 end of changes */
1006:
1007: IF l_gmp_um_code IS NOT NULL THEN

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

5937: old_resource_id := -1;
5938: old_instance_id := -1;
5939: lsetup_updated := TRUE;
5940:
5941: l_user_id := to_number(FND_PROFILE.VALUE('USER_ID'));
5942:
5943: X_select := ' SELECT '
5944: ||' gbsr.sequence_dependent_id, '
5945: ||' crd.resource_id, '