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 605: lValue fnd_profile_option_values.profile_option_value%type;

601: profile_val in number)
602: return integer
603: is
604:
605: lValue fnd_profile_option_values.profile_option_value%type;
606: loldvalue fnd_profile_option_values.profile_option_value%type;
607: lValidOrg number;
608:
609:

Line 606: loldvalue fnd_profile_option_values.profile_option_value%type;

602: return integer
603: is
604:
605: lValue fnd_profile_option_values.profile_option_value%type;
606: loldvalue fnd_profile_option_values.profile_option_value%type;
607: lValidOrg number;
608:
609:
610: cursor validation_org is

Line 612: from fnd_profile_options PO ,

608:
609:
610: cursor validation_org is
611: select distinct POV.profile_option_value
612: from fnd_profile_options PO ,
613: fnd_profile_option_values POV,
614: fnd_responsibility FR,
615: fnd_profile_options PO2,
616: fnd_profile_option_values POV2

Line 613: fnd_profile_option_values POV,

609:
610: cursor validation_org is
611: select distinct POV.profile_option_value
612: from fnd_profile_options PO ,
613: fnd_profile_option_values POV,
614: fnd_responsibility FR,
615: fnd_profile_options PO2,
616: fnd_profile_option_values POV2
617: where PO.profile_option_name = 'SO_ORGANIZATION_ID'

Line 615: fnd_profile_options PO2,

611: select distinct POV.profile_option_value
612: from fnd_profile_options PO ,
613: fnd_profile_option_values POV,
614: fnd_responsibility FR,
615: fnd_profile_options PO2,
616: fnd_profile_option_values POV2
617: where PO.profile_option_name = 'SO_ORGANIZATION_ID'
618: and POV.application_id = PO.application_id
619: and POV.profile_option_id = PO.profile_option_id

Line 616: fnd_profile_option_values POV2

612: from fnd_profile_options PO ,
613: fnd_profile_option_values POV,
614: fnd_responsibility FR,
615: fnd_profile_options PO2,
616: fnd_profile_option_values POV2
617: where PO.profile_option_name = 'SO_ORGANIZATION_ID'
618: and POV.application_id = PO.application_id
619: and POV.profile_option_id = PO.profile_option_id
620: and POV.level_id = 10003

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

974: -- end bugfix 2001824
975:
976:
977: lStmtNumber := 510;
978: lSourceCode := fnd_profile.value('ONT_SOURCE_CODE');
979: IF PG_DEBUG <> 0 THEN
980: oe_debug_pub.add ('delink_item: ' || 'lSourceCode is '||lSourceCode, 2);
981: END IF;
982:

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

3698: -- Bugfix 3779636
3699:
3700: lStmtNumber := 699;
3701:
3702: l_inv_ctp := fnd_profile.value('INV_CTP');
3703:
3704: IF PG_DEBUG <> 0 THEN
3705: oe_debug_pub.add('Get_Mandatory_Components: INV_CTP ( 4 = PDS ): ' || l_inv_ctp,1);
3706: END IF;

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

4148: lReturnStatus := fnd_api.G_RET_STS_SUCCESS;
4149:
4150: gUserId := nvl(Fnd_Global.USER_ID, -1);
4151: gLoginId := nvl(Fnd_Global.LOGIN_ID, -1);
4152: lCiDel := FND_PROFILE.Value('BOM:CONFIG_ITEM_DELIMITER');
4153:
4154:
4155:
4156: /* BUG #1957336 Change for preconfigure bom by Sushant Sawant */

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

4553:
4554:
4555:
4556: -- rkaza. 10/21/2004. bug 3860077. Item type should be null if profile is null.
4557: lItemType := FND_PROFILE.Value('BOM:CONFIG_ITEM_TYPE');
4558:
4559: /*-----------------------------------------------------------+
4560: Insert a row into the mtl_system_items table.
4561: +------------------------------------------------------------*/

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

7240: -- Only when this profile is set to "Inventory and WIP", should the records be inserted in CQL.
7241: -- 1 = Inventory Only
7242: -- 2 = Inventory and WIP
7243:
7244: IF ( nvl(fnd_profile.value('CST_AVG_COSTING_OPTION'), '1') = '2' ) THEN
7245: FOR v_layer in c_layer
7246: LOOP
7247:
7248: --