APPS.CTO_UPDATE_ITEMS_PK dependencies on FND_PROFILE

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

71: | FP bugfix 4861996
72: | added condition ic1.category_set_id = ic.category_set_id
73: *============================================================================*/
74:
75: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);
76:
77: g_atp_flag varchar2(1) := 'N' ;
78: gUserId number := nvl(Fnd_Global.USER_ID, -1);
79: gLoginId number := nvl(Fnd_Global.LOGIN_ID, -1);

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

2123:
2124:
2125: lStmtNumber := 90;
2126:
2127: IF ( nvl(fnd_profile.value('CST_AVG_COSTING_OPTION'), '1') = '2' ) THEN
2128: FOR v_layer in c_layer
2129: LOOP
2130:
2131: --

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

3102:
3103: lStmtNumber := 10;
3104: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
3105:
3106: lItemType := FND_PROFILE.Value('BOM:CONFIG_ITEM_TYPE');
3107:
3108: --perf bugfix 4905887 (sql id 16105473)
3109: --Removed comments to extent possible
3110:

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

3881: WriteToLog('Entering Update_Pc_Items', 3);
3882: lStmtNumber := 10;
3883: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
3884:
3885: lItemType := FND_PROFILE.Value('BOM:CONFIG_ITEM_TYPE');
3886:
3887: select substr(attribute_name, instr(attribute_name, '.' )+ 1), control_level
3888: BULK COLLECT
3889: INTO g_attribute_name_tab, g_control_level_tab