eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_CONFIG_ITEM_PK dependencies on FND_PROFILE

Line 340: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);

336: |
337: +-----------------------------------------------------------------------------*/
338:
339:
340: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);
341:
342: g_atp_flag varchar2(1) := 'N' ;
343:
344: TYPE ATTRIB_NAME_TAB_TYPE is table of mtl_item_attributes.attribute_name%type index by binary_integer ;

Line 680: lValue fnd_profile_option_values.profile_option_value%type;

676: profile_val in number)
677: return integer
678: is
679:
680: lValue fnd_profile_option_values.profile_option_value%type;
681: loldvalue fnd_profile_option_values.profile_option_value%type;
682: lValidOrg number;
683:
684:

Line 681: loldvalue fnd_profile_option_values.profile_option_value%type;

677: return integer
678: is
679:
680: lValue fnd_profile_option_values.profile_option_value%type;
681: loldvalue fnd_profile_option_values.profile_option_value%type;
682: lValidOrg number;
683:
684:
685: cursor validation_org is

Line 687: from fnd_profile_options PO ,

683:
684:
685: cursor validation_org is
686: select distinct POV.profile_option_value
687: from fnd_profile_options PO ,
688: fnd_profile_option_values POV,
689: fnd_responsibility FR,
690: fnd_profile_options PO2,
691: fnd_profile_option_values POV2

Line 688: fnd_profile_option_values POV,

684:
685: cursor validation_org is
686: select distinct POV.profile_option_value
687: from fnd_profile_options PO ,
688: fnd_profile_option_values POV,
689: fnd_responsibility FR,
690: fnd_profile_options PO2,
691: fnd_profile_option_values POV2
692: where PO.profile_option_name = 'SO_ORGANIZATION_ID'

Line 690: fnd_profile_options PO2,

686: select distinct POV.profile_option_value
687: from fnd_profile_options PO ,
688: fnd_profile_option_values POV,
689: fnd_responsibility FR,
690: fnd_profile_options PO2,
691: fnd_profile_option_values POV2
692: where PO.profile_option_name = 'SO_ORGANIZATION_ID'
693: and POV.application_id = PO.application_id
694: and POV.profile_option_id = PO.profile_option_id

Line 691: fnd_profile_option_values POV2

687: from fnd_profile_options PO ,
688: fnd_profile_option_values POV,
689: fnd_responsibility FR,
690: fnd_profile_options PO2,
691: fnd_profile_option_values POV2
692: where PO.profile_option_name = 'SO_ORGANIZATION_ID'
693: and POV.application_id = PO.application_id
694: and POV.profile_option_id = PO.profile_option_id
695: and POV.level_id = 10003

Line 1057: lSourceCode := fnd_profile.value('ONT_SOURCE_CODE');

1053: -- end bugfix 2001824
1054:
1055:
1056: lStmtNumber := 510;
1057: lSourceCode := fnd_profile.value('ONT_SOURCE_CODE');
1058: IF PG_DEBUG <> 0 THEN
1059: oe_debug_pub.add ('delink_item: ' || 'lSourceCode is '||lSourceCode, 2);
1060: END IF;
1061:

Line 1531: FND_PROFILE.Get('ONT_BYPASS_ATP', l_bypassatp_profile_value);

1527: -- Bug 14474393
1528: -- The visible demand flag has to be updated only if the profile
1529: -- OM:Bypass ATP is not Y
1530: --
1531: FND_PROFILE.Get('ONT_BYPASS_ATP', l_bypassatp_profile_value);
1532:
1533: IF PG_DEBUG <> 0 THEN
1534: oe_debug_pub.add('delink_item: Value of the profile ONT_BYPASS_ATP :' ||l_bypassatp_profile_value ,3);
1535: END IF;

Line 3795: l_inv_ctp := fnd_profile.value('INV_CTP');

3791: -- Bugfix 3779636
3792:
3793: lStmtNumber := 699;
3794:
3795: l_inv_ctp := fnd_profile.value('INV_CTP');
3796:
3797: IF PG_DEBUG <> 0 THEN
3798: oe_debug_pub.add('Get_Mandatory_Components: INV_CTP ( 4 = PDS ): ' || l_inv_ctp,1);
3799: END IF;

Line 4247: lCiDel := FND_PROFILE.Value('BOM:CONFIG_ITEM_DELIMITER');

4243: lReturnStatus := fnd_api.G_RET_STS_SUCCESS;
4244:
4245: gUserId := nvl(Fnd_Global.USER_ID, -1);
4246: gLoginId := nvl(Fnd_Global.LOGIN_ID, -1);
4247: lCiDel := FND_PROFILE.Value('BOM:CONFIG_ITEM_DELIMITER');
4248:
4249:
4250:
4251: /* BUG #1957336 Change for preconfigure bom by Sushant Sawant */

Line 4652: lItemType := FND_PROFILE.Value('BOM:CONFIG_ITEM_TYPE');

4648:
4649:
4650:
4651: -- rkaza. 10/21/2004. bug 3860077. Item type should be null if profile is null.
4652: lItemType := FND_PROFILE.Value('BOM:CONFIG_ITEM_TYPE');
4653:
4654: /*-----------------------------------------------------------+
4655: Insert a row into the mtl_system_items table.
4656: +------------------------------------------------------------*/

Line 7429: IF ( nvl(fnd_profile.value('CST_AVG_COSTING_OPTION'), '1') = '2' ) THEN

7425: -- Only when this profile is set to "Inventory and WIP", should the records be inserted in CQL.
7426: -- 1 = Inventory Only
7427: -- 2 = Inventory and WIP
7428:
7429: IF ( nvl(fnd_profile.value('CST_AVG_COSTING_OPTION'), '1') = '2' ) THEN
7430: FOR v_layer in c_layer
7431: LOOP
7432:
7433: --

Line 8556: FND_PROFILE.Get('ONT_BYPASS_ATP', l_bypassatp_profile_value);

8552: -- Bug 14474393
8553: -- The visible demand flag has to be updated only if the profile
8554: -- OM:Bypass ATP is not Y
8555: --
8556: FND_PROFILE.Get('ONT_BYPASS_ATP', l_bypassatp_profile_value);
8557:
8558: IF PG_DEBUG <> 0 THEN
8559: oe_debug_pub.add('link_item: Value of the profile ONT_BYPASS_ATP :' ||l_bypassatp_profile_value ,3);
8560: END IF;