DBA Data[Home] [Help]

APPS.INV_ORGHIERARCHY_PVT dependencies on FND_GLOBAL

Line 345: -- Using fnd_global.per_business_group_id instead.

341: TO_NUMBER( FND_PROFILE.VALUE( 'RESP_ID' ) );
342: l_security_profile_id :=
343: TO_NUMBER( FND_PROFILE.value( 'PER_SECURITY_PROFILE_ID' ) );
344: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.
345: -- Using fnd_global.per_business_group_id instead.
346: l_business_group_id :=
347: -- TO_NUMBER( FND_PROFILE.VALUE( 'PER_BUSINESS_GROUP_ID' ) );
348: TO_NUMBER( FND_GLOBAL.per_business_group_id );
349:

Line 348: TO_NUMBER( FND_GLOBAL.per_business_group_id );

344: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.
345: -- Using fnd_global.per_business_group_id instead.
346: l_business_group_id :=
347: -- TO_NUMBER( FND_PROFILE.VALUE( 'PER_BUSINESS_GROUP_ID' ) );
348: TO_NUMBER( FND_GLOBAL.per_business_group_id );
349:
350:
351: -- Note: oe_debug_pub is part of 11i baseline
352: oe_debug_pub.add( 'Responsibility Id: ' || l_responsibility_id, 2 );

Line 535: -- Using fnd_global.per_business_group_id instead.

531: -- bug#2563291 fix
532: -- get profile business group id of the responsibility
533:
534: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.
535: -- Using fnd_global.per_business_group_id instead.
536:
537: -- l_business_group_id := TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'));
538: l_business_group_id := TO_NUMBER(FND_GLOBAL.per_business_group_id);
539:

Line 538: l_business_group_id := TO_NUMBER(FND_GLOBAL.per_business_group_id);

534: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.
535: -- Using fnd_global.per_business_group_id instead.
536:
537: -- l_business_group_id := TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'));
538: l_business_group_id := TO_NUMBER(FND_GLOBAL.per_business_group_id);
539:
540: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
541: THEN
542: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

Line 551: , 'User :'||fnd_global.user_id||

547: );
548:
549: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
550: , 'INV_ORGHIERARCHY_PVT.contained_in_hierarchy '
551: , 'User :'||fnd_global.user_id||
552: ':Resp :'||fnd_global.resp_id||
553: ':Appl :'||fnd_global.resp_appl_id||
554: ':New_Msg:Business Grp :'||fnd_global.per_business_group_id
555: );

Line 552: ':Resp :'||fnd_global.resp_id||

548:
549: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
550: , 'INV_ORGHIERARCHY_PVT.contained_in_hierarchy '
551: , 'User :'||fnd_global.user_id||
552: ':Resp :'||fnd_global.resp_id||
553: ':Appl :'||fnd_global.resp_appl_id||
554: ':New_Msg:Business Grp :'||fnd_global.per_business_group_id
555: );
556: END IF;

Line 553: ':Appl :'||fnd_global.resp_appl_id||

549: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
550: , 'INV_ORGHIERARCHY_PVT.contained_in_hierarchy '
551: , 'User :'||fnd_global.user_id||
552: ':Resp :'||fnd_global.resp_id||
553: ':Appl :'||fnd_global.resp_appl_id||
554: ':New_Msg:Business Grp :'||fnd_global.per_business_group_id
555: );
556: END IF;
557:

Line 554: ':New_Msg:Business Grp :'||fnd_global.per_business_group_id

550: , 'INV_ORGHIERARCHY_PVT.contained_in_hierarchy '
551: , 'User :'||fnd_global.user_id||
552: ':Resp :'||fnd_global.resp_id||
553: ':Appl :'||fnd_global.resp_appl_id||
554: ':New_Msg:Business Grp :'||fnd_global.per_business_group_id
555: );
556: END IF;
557:
558: IF l_business_group_id IS NOT NULL THEN

Line 1293: -- Using fnd_global.per_business_group_id instead.

1289: AND ltrim(rtrim(OS.NAME)) = ltrim(rtrim(c_hierarchy_name))
1290: --Bug 9775787
1291: AND (OS.BUSINESS_GROUP_ID =
1292: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.
1293: -- Using fnd_global.per_business_group_id instead.
1294: -- TO_NUMBER( FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') ) OR
1295: TO_NUMBER(FND_GLOBAL.per_business_group_id) OR
1296: OS.BUSINESS_GROUP_ID IS NULL);
1297:

Line 1295: TO_NUMBER(FND_GLOBAL.per_business_group_id) OR

1291: AND (OS.BUSINESS_GROUP_ID =
1292: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.
1293: -- Using fnd_global.per_business_group_id instead.
1294: -- TO_NUMBER( FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') ) OR
1295: TO_NUMBER(FND_GLOBAL.per_business_group_id) OR
1296: OS.BUSINESS_GROUP_ID IS NULL);
1297:
1298:
1299: -- cursor to obtain the parent organization id for the organization structure

Line 1367: -- Using fnd_global.per_business_group_id instead.

1363: );
1364: END IF;
1365:
1366: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.
1367: -- Using fnd_global.per_business_group_id instead.
1368: -- l_business_group_id := TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'));
1369: l_business_group_id := TO_NUMBER(FND_GLOBAL.per_business_group_id);
1370:
1371: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 1369: l_business_group_id := TO_NUMBER(FND_GLOBAL.per_business_group_id);

1365:
1366: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.
1367: -- Using fnd_global.per_business_group_id instead.
1368: -- l_business_group_id := TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'));
1369: l_business_group_id := TO_NUMBER(FND_GLOBAL.per_business_group_id);
1370:
1371: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1372: THEN
1373: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE