APPS.QPR_SR_UTIL dependencies on FND_PROFILE

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

364: p_profile_value IN VARCHAR2,
365: p_profile_Level IN VARCHAR2) return number is
366: x_ret_value boolean;
367: begin
368: x_ret_value := fnd_profile.save(p_profile_name,p_profile_value,p_profile_Level);
369: if x_ret_value then
370: return 0;
371: else
372: return 2;

Line 382: select decode( decode(nvl(lower(fnd_profile.value('QPR_CUSTOMER_ATTRIBUTE')), '1'), '1', '1',

378: x_customer_id number ;
379:
380:
381: cursor c_customer_id is
382: select decode( decode(nvl(lower(fnd_profile.value('QPR_CUSTOMER_ATTRIBUTE')), '1'), '1', '1',
383: 'attribute1', cust.attribute1,
384: 'attribute2', cust.attribute2,
385: 'attribute3', cust.attribute3,
386: 'attribute4', cust.attribute4,

Line 430: return(fnd_profile.value(p_para_name));

426: END;
427:
428: function read_parameter(p_para_name in varchar2) return varchar2 as
429: begin
430: return(fnd_profile.value(p_para_name));
431: end read_parameter;
432:
433: function get_base_uom(p_item_id in number,
434: p_instance_id in number default null) return varchar2 as

Line 1034: if (fnd_profile.value('QPR_CURRENCY_CODE') is null or

1030: function dm_parameters_ok return boolean
1031: is
1032: l_count number;
1033: begin
1034: if (fnd_profile.value('QPR_CURRENCY_CODE') is null or
1035: fnd_profile.value('QPR_CATEGORY_SET_NAME') is null or
1036: fnd_profile.value('QPR_MASTER_ORG') is null) then
1037: return false;
1038: else

Line 1035: fnd_profile.value('QPR_CATEGORY_SET_NAME') is null or

1031: is
1032: l_count number;
1033: begin
1034: if (fnd_profile.value('QPR_CURRENCY_CODE') is null or
1035: fnd_profile.value('QPR_CATEGORY_SET_NAME') is null or
1036: fnd_profile.value('QPR_MASTER_ORG') is null) then
1037: return false;
1038: else
1039: return true;

Line 1036: fnd_profile.value('QPR_MASTER_ORG') is null) then

1032: l_count number;
1033: begin
1034: if (fnd_profile.value('QPR_CURRENCY_CODE') is null or
1035: fnd_profile.value('QPR_CATEGORY_SET_NAME') is null or
1036: fnd_profile.value('QPR_MASTER_ORG') is null) then
1037: return false;
1038: else
1039: return true;
1040: end if;