[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* Procedure to start the update resource workflow */
PROCEDURE start_update_resource_wf (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
p_resource_id IN jtf_rs_resource_extns.resource_id%type,
p_category IN jtf_rs_resource_extns.category%type,
p_resource_number IN jtf_rs_resource_extns.resource_number%type,
p_resource_name IN jtf_rs_resource_extns_vl.resource_name%type default fnd_api.g_miss_char,
p_address_id IN jtf_rs_resource_extns.address_id%type default fnd_api.g_miss_num,
p_source_email IN jtf_rs_resource_extns.source_email%type default fnd_api.g_miss_char,
p_source_phone IN jtf_rs_resource_extns.source_phone%type default fnd_api.g_miss_char,
p_source_office IN jtf_rs_resource_extns.source_office%type default fnd_api.g_miss_char,
p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,
p_primary_language IN jtf_rs_resource_extns.primary_language%type default fnd_api.g_miss_char,
p_secondary_language IN jtf_rs_resource_extns.secondary_language%type default fnd_api.g_miss_char,
p_cost_per_hr IN jtf_rs_resource_extns.cost_per_hr%type default fnd_api.g_miss_num,
p_attribute_access_level IN jtf_rs_table_attributes_b.attribute_access_level%type,
p_object_version_number IN jtf_rs_resource_extns.object_version_number%type,
--p_wf_display_name IN VARCHAR2 DEFAULT NULL,
p_wf_process IN VARCHAR2 DEFAULT 'EMP_UPDATE_PROCESS',
p_wf_item_type IN VARCHAR2 DEFAULT 'EMP_TYPE',
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_source_mobile_phone IN jtf_rs_resource_extns.source_mobile_phone%type default fnd_api.g_miss_char,
p_source_pager IN jtf_rs_resource_extns.source_pager%type default fnd_api.g_miss_char
)
IS
l_api_version CONSTANT NUMBER := 1.0;
SELECT user_name
FROM fnd_user
WHERE employee_id = l_employee_id
ORDER by creation_date desc;
SELECT category, resource_number, resource_name, source_name, source_number,
source_phone, source_email, source_office, source_location,
source_mailstop, source_mobile_phone, source_pager, time_zone,
support_site_id, primary_language, secondary_language, cost_per_hr,
address_id, user_id, source_id, source_mgr_id
FROM jtf_rs_resource_extns_vl
WHERE resource_id = l_resource_id;
SELECT description
FROM hr_locations
WHERE location_id = l_address_id;
SELECT name
FROM fnd_timezones_vl
WHERE upgrade_tz_id = l_timezone_id;
SELECT a.city
FROM hz_locations a, hz_party_site_uses c, hz_party_sites b
WHERE c.site_use_type = 'SUPPORT_SITE'
AND c.party_site_id = b.party_site_id
AND a.location_id = b.location_id
AND b.party_site_id = l_support_site_id;
CURSOR c_resource_update (l_resource_id number) IS
SELECT
DECODE (p_resource_name, fnd_api.g_miss_char, resource_name, p_resource_name) resource_name,
DECODE (p_source_email, fnd_api.g_miss_char, source_email, p_source_email) source_email,
DECODE (p_source_phone, fnd_api.g_miss_char, source_phone, p_source_phone) source_phone,
DECODE (p_source_office, fnd_api.g_miss_char, source_office, p_source_office) source_office,
DECODE (p_source_location, fnd_api.g_miss_char, source_location, p_source_location) source_location,
DECODE (p_source_mailstop, fnd_api.g_miss_char, source_mailstop, p_source_mailstop) source_mailstop,
DECODE (p_source_mobile_phone, fnd_api.g_miss_char, source_mobile_phone, p_source_mobile_phone) source_mobile_phone,
DECODE (p_source_pager, fnd_api.g_miss_char, source_pager, p_source_pager) source_pager,
DECODE (p_time_zone, fnd_api.g_miss_num, time_zone, p_time_zone) time_zone,
DECODE (p_support_site_id, fnd_api.g_miss_num, support_site_id, p_support_site_id) support_site_id,
DECODE (p_primary_language, fnd_api.g_miss_char, primary_language, p_primary_language) primary_language,
DECODE (p_secondary_language, fnd_api.g_miss_char, secondary_language, p_secondary_language) secondary_language,
DECODE (p_cost_per_hr, fnd_api.g_miss_num, cost_per_hr, p_cost_per_hr) cost_per_hr,
DECODE (p_address_id, fnd_api.g_miss_num, address_id, p_address_id) address_id
FROM jtf_rs_resource_extns_vl
WHERE resource_id = l_resource_id;
resource_rec c_resource_update%ROWTYPE;
OPEN c_resource_update(l_resource_id);
FETCH c_resource_update INTO resource_rec;
IF c_resource_update%NOTFOUND THEN
--dbms_output.put_line('The Resource passed is Invalid');
CLOSE c_resource_update;
SELECT jtf_rs_resource_wf_s.nextval INTO l_itemkey FROM dual;
SELECT fnd_global.user_name INTO l_requestor FROM dual;
END start_update_resource_wf;
PROCEDURE call_update_resource_api (
itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
resultout OUT NOCOPY VARCHAR2
)
IS
l_resource_id jtf_rs_resource_extns.resource_id%type;
jtf_rs_res_sswa_pub.update_resource (
P_API_VERSION => 1.0,
P_RESOURCE_ID => l_resource_id,
P_RESOURCE_NUMBER => l_resource_number,
P_RESOURCE_NAME => l_resource_name,
P_SOURCE_NAME => l_source_name,
P_SOURCE_EMAIL => l_source_email,
P_SOURCE_PHONE => l_source_phone,
P_SOURCE_OFFICE => l_source_office,
P_SOURCE_LOCATION => l_source_location,
P_SOURCE_MAILSTOP => l_source_mailstop,
P_TIME_ZONE => l_time_zone,
P_SUPPORT_SITE_ID => l_support_site_id,
P_PRIMARY_LANGUAGE => l_primary_language,
P_SECONDARY_LANGUAGE => l_secondary_language,
P_COST_PER_HR => l_cost_per_hr,
P_ADDRESS_ID => l_address_id,
P_OBJECT_VERSION_NUMBER => l_object_version_number,
P_APPROVED => l_approved,
X_RETURN_STATUS => x_return_status,
X_MSG_COUNT => x_msg_count,
X_MSG_DATA => x_msg_data,
P_SOURCE_MOBILE_PHONE => l_source_mobile_phone,
P_SOURCE_PAGER => l_source_pager
);
END call_update_resource_api;