eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_UTILITY dependencies on FND_PROFILE

Line 1607: l_per_business_group number := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');

1603: l_app_tab_name varchar2(2000);
1604: l_add_where_clause varchar2(2000);
1605: l_id_column_name varchar2(2000);
1606: l_stmt varchar2(2000);
1607: l_per_business_group number := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
1608: BEGIN
1609: IF p_value_set_id IS NOT NULL THEN
1610: -- Check if a valid value set id is passed and fetch its validation type.
1611: chk_if_valid_value_set(p_value_set_id => p_value_set_id,

Line 1657: -- Replace FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') with business_group_id;

1653: IF INSTR(UPPER(l_stmt), ':1') <> 0 THEN
1654: -- Replace :1 with business_group_id;
1655: l_stmt := REPLACE(l_stmt, ':1', 'BUSINESS_GROUP_ID');
1656: ELSE
1657: -- Replace FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') with business_group_id;
1658: l_stmt := REPLACE(l_stmt, 'FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')', 'BUSINESS_GROUP_ID');
1659: END IF;
1660: -- FOR RBC
1661: if instr(upper(l_stmt),':$PROFILES$.PER_BUSINESS_GROUP_ID') > 0 then

Line 1658: l_stmt := REPLACE(l_stmt, 'FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')', 'BUSINESS_GROUP_ID');

1654: -- Replace :1 with business_group_id;
1655: l_stmt := REPLACE(l_stmt, ':1', 'BUSINESS_GROUP_ID');
1656: ELSE
1657: -- Replace FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') with business_group_id;
1658: l_stmt := REPLACE(l_stmt, 'FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')', 'BUSINESS_GROUP_ID');
1659: END IF;
1660: -- FOR RBC
1661: if instr(upper(l_stmt),':$PROFILES$.PER_BUSINESS_GROUP_ID') > 0 then
1662: hr_utility.set_location('inside bg pattern',11);

Line 1663: l_stmt := REPLACE(l_stmt,':$PROFILES$.PER_BUSINESS_GROUP_ID','FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')');

1659: END IF;
1660: -- FOR RBC
1661: if instr(upper(l_stmt),':$PROFILES$.PER_BUSINESS_GROUP_ID') > 0 then
1662: hr_utility.set_location('inside bg pattern',11);
1663: l_stmt := REPLACE(l_stmt,':$PROFILES$.PER_BUSINESS_GROUP_ID','FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')');
1664:
1665: end if;
1666: if instr(upper(l_stmt),':$FLEX$.PER_DATES_STANDARD') > 0 then
1667: hr_utility.set_location('inside date pattern',11);

Line 1714: l_per_business_group number := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');

1710: l_app_tab_name varchar2(2000);
1711: l_add_where_clause varchar2(2000);
1712: l_id_column_name varchar2(2000);
1713: l_stmt varchar2(2000);
1714: l_per_business_group number := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
1715: BEGIN
1716: IF p_value_set_id IS NOT NULL THEN
1717: -- Check if a valid value set id is passed and fetch its validation type.
1718: chk_if_valid_value_set(p_value_set_id => p_value_set_id,

Line 1763: -- Replace FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') with business_group_id;

1759: IF INSTR(UPPER(l_stmt), ':1') <> 0 THEN
1760: -- Replace :1 with business_group_id;
1761: l_stmt := REPLACE(l_stmt, ':1', 'BUSINESS_GROUP_ID');
1762: ELSE
1763: -- Replace FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') with business_group_id;
1764: l_stmt := REPLACE(l_stmt, 'FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')', 'BUSINESS_GROUP_ID');
1765: END IF;
1766: if instr(upper(l_stmt),':$PROFILES$.PER_BUSINESS_GROUP_ID') > 0 then
1767: hr_utility.set_location('inside bg pattern',11);

Line 1764: l_stmt := REPLACE(l_stmt, 'FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')', 'BUSINESS_GROUP_ID');

1760: -- Replace :1 with business_group_id;
1761: l_stmt := REPLACE(l_stmt, ':1', 'BUSINESS_GROUP_ID');
1762: ELSE
1763: -- Replace FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') with business_group_id;
1764: l_stmt := REPLACE(l_stmt, 'FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')', 'BUSINESS_GROUP_ID');
1765: END IF;
1766: if instr(upper(l_stmt),':$PROFILES$.PER_BUSINESS_GROUP_ID') > 0 then
1767: hr_utility.set_location('inside bg pattern',11);
1768: l_stmt := REPLACE(l_stmt,':$PROFILES$.PER_BUSINESS_GROUP_ID','FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')');

Line 1768: l_stmt := REPLACE(l_stmt,':$PROFILES$.PER_BUSINESS_GROUP_ID','FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')');

1764: l_stmt := REPLACE(l_stmt, 'FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')', 'BUSINESS_GROUP_ID');
1765: END IF;
1766: if instr(upper(l_stmt),':$PROFILES$.PER_BUSINESS_GROUP_ID') > 0 then
1767: hr_utility.set_location('inside bg pattern',11);
1768: l_stmt := REPLACE(l_stmt,':$PROFILES$.PER_BUSINESS_GROUP_ID','FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')');
1769: end if;
1770: if instr(upper(l_stmt),':$FLEX$.PER_DATES_STANDARD') > 0 then
1771: hr_utility.set_location('inside date pattern',11);
1772: l_stmt := REPLACE(l_stmt,'TO_DATE(:$FLEX$.PER_DATES_STANDARD,''YYYY/MM/DD HH24:MI:SS'')','trunc(sysdate)');