APPS.ICX_ITEM_DIAG_PVT dependencies on FND_PROFILE

Line 501: SELECT UPPER(decode( fnd_profile.value('REQUISITION_TYPE'),'INTERNAL','icxzi','PURCHASE','icxzp','icxzb') || SQE_SEQUENCE)

497:
498: cursor sqe is
499: select rownum,SQE_OWNER#,SQE_NAME,SQE_QUERY from ctxsys.dr$sqe
500: where SQE_NAME in (
501: SELECT UPPER(decode( fnd_profile.value('REQUISITION_TYPE'),'INTERNAL','icxzi','PURCHASE','icxzp','icxzb') || SQE_SEQUENCE)
502: FROM
503: ICX_CAT_CONTENT_ZONES_B zoneb,
504: ICX_CAT_STORE_CONTENTS_V contentv
505: WHERE

Line 1336: fnd_profile.get('POR_AUTO_CREATE_SHOPPING_CAT', l_option_value);

1332: l_po_category_id number;
1333: l_ret varchar2(1000);
1334: begin
1335: IF g_auto_map_category = 'Y' THEN
1336: fnd_profile.get('POR_AUTO_CREATE_SHOPPING_CAT', l_option_value);
1337: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'1 POR_AUTO_CREATE_SHOPPING_CAT='||l_option_value);
1338: fnd_profile.put('POR_AUTO_CREATE_SHOPPING_CAT', 'Y');
1339:
1340: open create_ip_cat;

Line 1338: fnd_profile.put('POR_AUTO_CREATE_SHOPPING_CAT', 'Y');

1334: begin
1335: IF g_auto_map_category = 'Y' THEN
1336: fnd_profile.get('POR_AUTO_CREATE_SHOPPING_CAT', l_option_value);
1337: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'1 POR_AUTO_CREATE_SHOPPING_CAT='||l_option_value);
1338: fnd_profile.put('POR_AUTO_CREATE_SHOPPING_CAT', 'Y');
1339:
1340: open create_ip_cat;
1341: loop
1342: fetch create_ip_cat into l_po_category_id;

Line 1358: fnd_profile.put('POR_AUTO_CREATE_SHOPPING_CAT', l_option_value);

1354:
1355: end loop;
1356: close create_ip_cat;
1357:
1358: fnd_profile.put('POR_AUTO_CREATE_SHOPPING_CAT', l_option_value);
1359:
1360: END IF;
1361: l_po_category_id:=0;
1362: