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.AMW_LOAD_PROC_DATA dependencies on FND_PROFILE

Line 736: l_amw_delt_process_intf := NVL(fnd_profile.VALUE ('AMW_DELT_PROCESS_INTF'), 'N');

732:
733: --
734: -- get profile info FOR deleting records from interface table
735: --
736: l_amw_delt_process_intf := NVL(fnd_profile.VALUE ('AMW_DELT_PROCESS_INTF'), 'N');
737: IF v_error_found THEN
738: ---Commenting the rollback FOR now ....
739: ---ROLLBACK;
740: l_process_flag := NULL;

Line 1524: l_amw_process_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_PROC_OWNER_COL'),'AMW_RL_PROC_OWNER_ROLE');

1520: **/
1521: ---04.22.2005 npanandi: commented out above grants for now
1522:
1523: ---04.22.2005 npanandi: added below grants bug 4323387
1524: l_amw_process_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_PROC_OWNER_COL'),'AMW_RL_PROC_OWNER_ROLE');
1525: if(p_process_rec.process_owner_id is not null) then
1526: add_owner_privilege(
1527: p_role_name => l_amw_process_owner_col
1528: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'

Line 1535: l_amw_application_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_APPL_OWNER_COL'),'AMW_RL_PROC_APPL_OWNER_ROLE');

1531: ,p_party_id => P_PROCESS_REC.process_owner_id);
1532: end if;
1533:
1534: if(p_process_rec.application_owner_id is not null) then
1535: l_amw_application_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_APPL_OWNER_COL'),'AMW_RL_PROC_APPL_OWNER_ROLE');
1536: add_owner_privilege(
1537: p_role_name => l_amw_application_owner_col
1538: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
1539: ,p_grantee_type => 'P'

Line 1545: l_amw_finance_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_FINANCE_OWNER_COL'),'AMW_RL_PROC_FINANCE_OWNER_ROLE');

1541: ,p_party_id => P_PROCESS_REC.application_owner_id);
1542: end if;
1543:
1544: if(p_process_rec.finance_owner_id is not null) then
1545: l_amw_finance_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_FINANCE_OWNER_COL'),'AMW_RL_PROC_FINANCE_OWNER_ROLE');
1546: add_owner_privilege(
1547: p_role_name => l_amw_finance_owner_col
1548: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
1549: ,p_grantee_type => 'P'

Line 1773: l_amw_process_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_PROC_OWNER_COL'),'AMW_RL_PROC_OWNER_ROLE');

1769: raise no_data_found;
1770: end if;
1771:
1772: ---04.22.2005 npanandi: added below grants bug 4323387
1773: l_amw_process_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_PROC_OWNER_COL'),'AMW_RL_PROC_OWNER_ROLE');
1774: if(p_process_rec.process_owner_id is not null) then
1775: ---04.29.2005 npanandi: check here to see
1776: ---if the role is ProcessOwner Role, then
1777: ---whether to add or to replace

Line 1792: l_amw_application_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_APPL_OWNER_COL'),'AMW_RL_PROC_APPL_OWNER_ROLE');

1788: ,p_party_id => P_PROCESS_REC.process_owner_id);
1789: end if;
1790:
1791: if(p_process_rec.application_owner_id is not null) then
1792: l_amw_application_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_APPL_OWNER_COL'),'AMW_RL_PROC_APPL_OWNER_ROLE');
1793: ---04.29.2005 npanandi: check here to see
1794: ---if the role is ProcessOwner Role, then
1795: ---whether to add or to replace
1796: if(l_amw_application_owner_col = 'AMW_RL_PROC_OWNER_ROLE')then

Line 1810: l_amw_finance_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_FINANCE_OWNER_COL'),'AMW_RL_PROC_FINANCE_OWNER_ROLE');

1806: ,p_party_id => P_PROCESS_REC.application_owner_id);
1807: end if;
1808:
1809: if(p_process_rec.finance_owner_id is not null) then
1810: l_amw_finance_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_FINANCE_OWNER_COL'),'AMW_RL_PROC_FINANCE_OWNER_ROLE');
1811: ---04.29.2005 npanandi: check here to see
1812: ---if the role is ProcessOwner Role, then
1813: ---whether to add or to replace
1814: if(l_amw_finance_owner_col = 'AMW_RL_PROC_OWNER_ROLE')then

Line 1960: l_security_switch := NVL(fnd_profile.VALUE ('AMW_DATA_SECURITY_SWITCH'), 'N');

1956: open c_get_user_name;
1957: fetch c_get_user_name into l_user_name;
1958: close c_get_user_name;
1959:
1960: l_security_switch := NVL(fnd_profile.VALUE ('AMW_DATA_SECURITY_SWITCH'), 'N');
1961:
1962: if(l_security_switch = 'Y') then ---check for Upd prvlg only if Security mode is set on
1963: l_has_access := fnd_data_security.check_function(
1964: p_api_version => 1