DBA Data[Home] [Help]

APPS.MSD_SR_UTIL dependencies on FND_PROFILE

Line 330: x_master_org := fnd_profile.value('MSD_MASTER_ORG') ;

326: end ;
327:
328: /* Get the profile option MSD_MASTER_ORG */
329:
330: x_master_org := fnd_profile.value('MSD_MASTER_ORG') ;
331:
332: if (x_product_group_type = 'Y') then
333: if (x_master_org is NULL) then
334: select organization_id into x_master_org

Line 364: x_item_org := fnd_profile.value('MSD_ITEM_ORG') ;

360: begin
361:
362: /* Get the profile option MSD_ITEM_ORG */
363:
364: x_item_org := fnd_profile.value('MSD_ITEM_ORG') ;
365:
366: return x_item_org;
367:
368: exception

Line 380: x_cat_set_id := fnd_profile.value('MSD_CATEGORY_SET_NAME') ;

376: begin
377:
378: /* Get the profile option MSD_CATEGORY_SET_NAME */
379:
380: x_cat_set_id := fnd_profile.value('MSD_CATEGORY_SET_NAME') ;
381:
382: return x_cat_set_id ;
383:
384: exception

Line 397: x_conv_type := fnd_profile.value('MSD_CONVERSION_TYPE') ;

393: begin
394:
395: /* Get the profile option MSD_CONVERSION_TYPE */
396:
397: x_conv_type := fnd_profile.value('MSD_CONVERSION_TYPE') ;
398:
399: return x_conv_type;
400:
401: exception

Line 413: x_cust_attr := fnd_profile.value('MSD_CUSTOMER_ATTRIBUTE') ;

409: begin
410:
411: /* Get the profile option MSD_CUSTOMER_ATTRIBUTE */
412:
413: x_cust_attr := fnd_profile.value('MSD_CUSTOMER_ATTRIBUTE') ;
414:
415: return x_cust_attr;
416:
417: exception

Line 1038: x_ret_value := fnd_profile.save(p_profile_name,p_profile_value,p_profile_Level);

1034: p_profile_value IN VARCHAR2,
1035: p_profile_Level IN VARCHAR2) return number is
1036: x_ret_value boolean;
1037: begin
1038: x_ret_value := fnd_profile.save(p_profile_name,p_profile_value,p_profile_Level);
1039: if x_ret_value then
1040: return 0;
1041: else
1042: return 2;

Line 1445: x_cat_set_id := fnd_profile.value('MSD_EOL_CATEGORY_SET_NAME') ;

1441: IS
1442: x_cat_set_id number;
1443: BEGIN
1444: /* Get the profile option MSD_EOL_CATEGORY_SET_NAME */
1445: x_cat_set_id := fnd_profile.value('MSD_EOL_CATEGORY_SET_NAME') ;
1446:
1447: RETURN x_cat_set_id ;
1448:
1449: EXCEPTION