APPS.POA_BIS_ALERTS dependencies on FND_PROFILE

Line 107: l_sob_id := fnd_profile.value('GL_SET_OF_BKS_ID');

103: BEGIN
104: x_progress := '001';
105:
106: IF (p_org_id = -1) THEN
107: l_sob_id := fnd_profile.value('GL_SET_OF_BKS_ID');
108: ELSE
109: SELECT to_number(org_information1) INTO l_sob_id
110: FROM hr_organization_information
111: WHERE organization_id = p_org_id

Line 897: insert_row('L_URL', fnd_profile.value('ICX_REPORT_LINK') ||

893: insert_row('L_SENDER', l_app_name, NULL, l_value_tbl);
894: get_report_param(p_target_level_short_name,
895: to_number(l_target_orgs(l_index).org_level_value_id),
896: l_start_date, l_end_date, l_period_type, l_param);
897: insert_row('L_URL', fnd_profile.value('ICX_REPORT_LINK') ||
898: 'OracleOASIS.RunReport?report='|| l_measure_short_name ||
899: '&' || 'parameters=' || l_param || '&' ||
900: 'responsibility_id=' ||
901: l_target_rec.notify_resp1_id, NULL, l_value_tbl);

Line 922: set_value('L_URL', fnd_profile.value('ICX_REPORT_LINK') ||

918: to_char(l_range_high,POA_BIS_ALERTS.g_percent_mask),l_value_tbl);
919: get_report_param(p_target_level_short_name,
920: to_number(l_target_orgs(l_index).org_level_value_id),
921: l_start_date, l_end_date, l_period_type, l_param);
922: set_value('L_URL', fnd_profile.value('ICX_REPORT_LINK') ||
923: 'OracleOASIS.RunReport?report='|| l_measure_short_name ||
924: '&' || 'parameters=' || l_param || '&' ||
925: 'responsibility_id=' ||
926: l_target_rec.notify_resp2_id, NULL, l_value_tbl);

Line 948: set_value('L_URL', fnd_profile.value('ICX_REPORT_LINK') ||

944: to_char(l_range_high,POA_BIS_ALERTS.g_percent_mask),l_value_tbl);
945: get_report_param(p_target_level_short_name,
946: to_number(l_target_orgs(l_index).org_level_value_id),
947: l_start_date, l_end_date, l_period_type, l_param);
948: set_value('L_URL', fnd_profile.value('ICX_REPORT_LINK') ||
949: 'OracleOASIS.RunReport?report='|| l_measure_short_name ||
950: '&' || 'parameters=' || l_param || '&' ||
951: 'responsibility_id=' ||
952: l_target_rec.notify_resp3_id, NULL, l_value_tbl);