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 1984: IF ( nvl(fnd_profile.value('CST_AVG_COSTING_OPTION'), '1') = '2' ) THEN

1980:
1981:
1982: lStmtNumber := 90;
1983:
1984: IF ( nvl(fnd_profile.value('CST_AVG_COSTING_OPTION'), '1') = '2' ) THEN
1985: FOR v_layer in c_layer
1986: LOOP
1987:
1988: --

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

2933:
2934: lStmtNumber := 10;
2935: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
2936:
2937: lItemType := FND_PROFILE.Value('BOM:CONFIG_ITEM_TYPE');
2938:
2939: --perf bugfix 4905887 (sql id 16105473)
2940: --Removed comments to extent possible
2941:

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

3669: WriteToLog('Entering Update_Pc_Items', 3);
3670: lStmtNumber := 10;
3671: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
3672:
3673: lItemType := FND_PROFILE.Value('BOM:CONFIG_ITEM_TYPE');
3674:
3675: select substr(attribute_name, instr(attribute_name, '.' )+ 1), control_level
3676: BULK COLLECT
3677: INTO g_attribute_name_tab, g_control_level_tab