[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT task_type_id
FROM jtf_task_types_b
WHERE rule = 'DISPATCH'
AND NVL (schedule_flag, 'N') = 'Y'
AND task_type_id = p_task_type_id;
select object_version_number from jtf_tasks_b where task_id = v_task_id;
select resource_id
from jtf_rs_resource_extns
where user_id = v_user_id;
select decode(category, 'EMPLOYEE', 'RS_EMPLOYEE',
'PARTNER', 'RS_PARTNER',
'SUPPLIER_CONTACT', 'RS_SUPPLIER_CONTACT',
'OTHER', 'RS_OTHER',
'PARTY', 'RS_PARTY',
'TBH', 'RS_TBH',
'VENUE', 'RS_VENUE', category)
from JTF_RS_RESOURCE_EXTNS
where resource_id = v_resource_id ;
select count(*) from jtf_task_resources_vl
where resource_id = v_resource_id and resource_type = v_resource_type;
SELECT
SKILL_TYPE_ID
, SKILL_ID
, SKILL_LEVEL_ID , DISABLED_FLAG
FROM CSF_REQUIRED_SKILLS_B
WHERE HAS_SKILL_TYPE = 'TASK'
AND HAS_SKILL_ID = V_TASK_ID;
CURSOR C_CST_ACCESS_HRS_EXISTS(v_task_id number) is select 'Y' from csf_access_hours_vl where task_id=v_task_id;
CURSOR C_CST_ACCESS_HRS(v_task_id number) IS select * from CSF_ACCESS_HOURS_VL where task_id = v_task_id;
Select address_id,
location_id
from jtf_tasks_b
where task_id = v_task_id ;
p_date_selected => l_task_rec.date_selected
);
lets update the row with the disable flag
This is a temporary fix as there is no API from CSF_SKILL
to update the row or set the DISABLE_FLAG while creating
To be removed once that is in. A bug is filed (# 3292940)
*/
IF (R_FIND_SKILL.DISABLED_FLAG = 'Y') THEN
UPDATE CSF_REQUIRED_SKILLS_B
SET DISABLED_FLAG = 'Y'
WHERE SKILL_ID = R_FIND_SKILL.SKILL_ID
AND HAS_SKILL_ID = x_follow_up_task_id
AND SKILL_TYPE_ID = R_FIND_SKILL.SKILL_TYPE_ID
AND SKILL_LEVEL_ID = R_FIND_SKILL.SKILL_LEVEL_ID;
p_LAST_UPDATED_BY => FND_GLOBAL.user_id,
p_LAST_UPDATE_DATE => sysdate,
p_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,
x_return_status => l_return_status,
x_msg_data => l_msg_data,
x_msg_count => l_msg_count
);
select customer_id from cs_incidents_all where incident_id = v_incident_id;
Select name
from jtf_task_types_vl
where TASK_TYPE_ID = v_task_type_id;
select resource_id
from jtf_rs_resource_extns
where user_id = v_user_id;
select decode(category, 'EMPLOYEE', 'RS_EMPLOYEE',
'PARTNER', 'RS_PARTNER',
'SUPPLIER_CONTACT', 'RS_SUPPLIER_CONTACT',
'OTHER', 'RS_OTHER',
'PARTY', 'RS_PARTY',
'TBH', 'RS_TBH',
'VENUE', 'RS_VENUE', category)
from JTF_RS_RESOURCE_EXTNS
where resource_id = v_resource_id ;
select count(*) from jtf_task_resources_vl
where resource_id = v_resource_id and resource_type = v_resource_type;
Select incident_number,
incident_location_type,
incident_location_id
from cs_incidents_all
where incident_id = v_incident_id ;
p_date_selected => NULL,
p_category_id => null,
p_show_on_calendar => null,
p_owner_status_id => null,
p_template_id => null,
p_template_group_id => null
);
, p_prob_code IN VARCHAR2 -- Addition for inserting problem code
, p_cust_po_number IN varchar2 -- Bug 5059169
, p_attribute_1 IN VARCHAR2 -- Addition for insert DFF data with create SR
, p_attribute_2 IN VARCHAR2
, p_attribute_3 IN VARCHAR2
, p_attribute_4 IN VARCHAR2
, p_attribute_5 IN VARCHAR2
, p_attribute_6 IN VARCHAR2
, p_attribute_7 IN VARCHAR2
, p_attribute_8 IN VARCHAR2
, p_attribute_9 IN VARCHAR2
, p_attribute_10 IN VARCHAR2
, p_attribute_11 IN VARCHAR2
, p_attribute_12 IN VARCHAR2
, p_attribute_13 IN VARCHAR2
, p_attribute_14 IN VARCHAR2
, p_attribute_15 IN VARCHAR2
, p_context IN VARCHAR2
)IS
l_api_name CONSTANT VARCHAR2(30) := 'Create_new_SR';
Select caller_type,
customer_id ,
install_site_id ,
account_id ,
external_reference,
system_id ,
bill_to_site_id ,
ship_to_site_id ,
bill_to_party_id ,
ship_to_party_id ,
incident_location_type,
incident_location_id,
-- bug # 5182686
customer_email_id,
customer_phone_id,
category_set_id,
category_id
from cs_incidents_all
where incident_id = v_incident_id;
select contact_point_id
from
HZ_PARTY_CONTACT_POINTS_V
where
party_id = v_party_id
and contact_point_type = v_contact_type
and primary_flag = 'Y';
select
category_id
from
MTL_ITEM_CATEGORIES
where
INVENTORY_ITEM_ID = v_inv_item_id
and organization_id = v_org_id
and category_set_id = v_cat_set_id;
SELECT party_type FROM hz_parties WHERE party_id = v_contact_id;
SELECT CS_HZ_SR_CONTACT_POINTS_S.NEXTVAL FROM DUAL;
SELECT
LOCATION_ID,
LOCATION_TYPE_CODE,
OWNER_PARTY_ID,
OWNER_PARTY_ACCOUNT_ID,
SYSTEM_ID,
EXTERNAL_REFERENCE
from csi_item_instances
where instance_id = v_instance_id;
SELECT
c.party_id party_id,
nvl(a.party_site_id , 0) party_site_id
from hz_party_sites a, hz_party_site_uses b ,csi_i_parties c
where a.party_id(+) = c.party_id
and c.RELATIONSHIP_TYPE_CODE = v_type
and c.instance_id = v_instance_id
and b.party_site_id(+) = a.party_site_id
and b.site_use_type(+) = v_type
and b.status(+) = 'A'
and trunc(SYSDATE) BETWEEN TRUNC(NVL(b.begin_date,SYSDATE)) and
TRUNC(NVL(b.end_date,SYSDATE));
select party_site_id
from hz_party_sites
where party_id = v_party_id
and location_id = v_location_id;
--keep on Selecting
IF (p_old_incident_id <> 0) THEN
OPEN c_incident_record(p_old_incident_id);
l_service_request_rec.last_update_program_code := 'FS-WIRELESS'; -- Bug 3939638: Changing from 'PMCON'
-- Addition for insert DFF data with create SR
l_service_request_rec.request_attribute_1 := p_attribute_1 ;
SELECT CONVERSION_RATE/24
FROM MTL_UOM_CONVERSIONS
WHERE UOM_CLASS = 'Time'
AND UOM_CODE = l_uom_code
AND INVENTORY_ITEM_ID = 0;
SELECT count(*)
INTO l_count
FROM Hz_Party_Sites s
WHERE s.party_site_id = p_install_site_id
AND s.status = 'A'
-- Belongs to SR Customer
AND ( s.party_id = p_customer_id
-- or one of its relationships
OR s.party_id IN (
SELECT r.party_id
FROM Hz_Relationships r
WHERE r.object_id = p_customer_id
AND r.status = 'A'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(r.START_DATE, SYSDATE)) AND TRUNC(NVL(r.END_DATE, SYSDATE)) )
-- or one of its Related parties
OR s.party_id IN (
SELECT sub.party_id
FROM Hz_Parties p,
Hz_Parties sub,
Hz_Parties obj,
Hz_Relationships r
WHERE obj.party_id = p_customer_id
AND sub.status = 'A'
AND sub.party_type IN ('PERSON','ORGANIZATION')
AND p.party_id = r.party_id
AND r.object_id = obj.party_id
AND r.subject_id = sub.party_id ));
PROCEDURE UPDATE_TASK_FLEX
(
p_task_id IN NUMBER
, p_attribute_1 IN VARCHAR2
, p_attribute_2 IN VARCHAR2
, p_attribute_3 IN VARCHAR2
, p_attribute_4 IN VARCHAR2
, p_attribute_5 IN VARCHAR2
, p_attribute_6 IN VARCHAR2
, p_attribute_7 IN VARCHAR2
, p_attribute_8 IN VARCHAR2
, p_attribute_9 IN VARCHAR2
, p_attribute_10 IN VARCHAR2
, p_attribute_11 IN VARCHAR2
, p_attribute_12 IN VARCHAR2
, p_attribute_13 IN VARCHAR2
, p_attribute_14 IN VARCHAR2
, p_attribute_15 IN VARCHAR2
, p_context IN VARCHAR2
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_error OUT NOCOPY VARCHAR2
) IS
l_msg_count number;
select object_version_number from jtf_tasks_b where task_id = v_task_id;
csf_tasks_pub.update_task (
p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_TRUE,
p_object_version_number => l_object_version_number,
p_task_id => p_task_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => l_msg_data,
p_attribute1 => p_attribute_1,
p_attribute2 => p_attribute_2,
p_attribute3 => p_attribute_3,
p_attribute4 => p_attribute_4,
p_attribute5 => p_attribute_5,
p_attribute6 => p_attribute_6,
p_attribute7 => p_attribute_7,
p_attribute8 => p_attribute_8,
p_attribute9 => p_attribute_9,
p_attribute10 => p_attribute_10,
p_attribute11 => p_attribute_11,
p_attribute12 => p_attribute_12,
p_attribute13 => p_attribute_13,
p_attribute14 => p_attribute_14,
p_attribute15 => p_attribute_15,
p_attribute_category => p_context
);
END UPDATE_TASK_FLEX;
Procedure added to update schedule start/end date and Planned Efforts
*/
PROCEDURE UPDATE_SCH_DATE_TASK
( p_task_id IN NUMBER
, p_scheduled_start_date IN DATE
, p_scheduled_end_date IN DATE
, p_planned_effort IN NUMBER
, p_planned_effort_uom IN VARCHAR
, p_allow_overlap IN VARCHAR
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_error OUT NOCOPY VARCHAR2
) IS
l_object_version_number number;
select object_version_number from jtf_tasks_b where task_id = v_task_id;
CSF_TASKS_PUB.Update_Task
( p_api_version => 1.0
, p_init_msg_list => fnd_api.g_false
, p_commit => fnd_api.g_false
, p_validation_level => l_validation_level
, p_find_overlap => l_find_overlap
, p_task_id => p_task_id
, p_object_version_number => l_object_version_number
, p_planned_start_date => fnd_api.g_miss_date
, p_planned_end_date => fnd_api.g_miss_date
, p_scheduled_start_date => p_scheduled_start_date
, p_scheduled_end_date => p_scheduled_end_date
, p_actual_start_date => fnd_api.g_miss_date
, p_actual_end_date => fnd_api.g_miss_date
, p_timezone_id => fnd_api.g_miss_num
, p_source_object_type_code => fnd_api.g_miss_char
, p_source_object_id => fnd_api.g_miss_num
, p_source_object_name => fnd_api.g_miss_char
, p_task_status_id => fnd_api.g_miss_num
, p_task_type_id => fnd_api.g_miss_num
, p_task_priority_id => fnd_api.g_miss_num
, p_owner_type_code => fnd_api.g_miss_char
, p_owner_id => fnd_api.g_miss_num
, p_owner_territory_id => fnd_api.g_miss_num
, p_assigned_by_id => fnd_api.g_miss_num
, p_customer_id => fnd_api.g_miss_num
, p_cust_account_id => fnd_api.g_miss_num
, p_address_id => fnd_api.g_miss_num
, p_task_name => fnd_api.g_miss_char
, p_description => fnd_api.g_miss_char
, p_duration => fnd_api.g_miss_num
, p_duration_uom => fnd_api.g_miss_char
, p_planned_effort => p_planned_effort
, p_planned_effort_uom => p_planned_effort_uom
, p_actual_effort => fnd_api.g_miss_num
, p_actual_effort_uom => fnd_api.g_miss_char
, p_percentage_complete => fnd_api.g_miss_num
, p_reason_code => fnd_api.g_miss_char
, p_private_flag => fnd_api.g_miss_char
, p_publish_flag => fnd_api.g_miss_char
, p_restrict_closure_flag => fnd_api.g_miss_char
, p_attribute1 => fnd_api.g_miss_char
, p_attribute2 => fnd_api.g_miss_char
, p_attribute3 => fnd_api.g_miss_char
, p_attribute4 => fnd_api.g_miss_char
, p_attribute5 => fnd_api.g_miss_char
, p_attribute6 => fnd_api.g_miss_char
, p_attribute7 => fnd_api.g_miss_char
, p_attribute8 => fnd_api.g_miss_char
, p_attribute9 => fnd_api.g_miss_char
, p_attribute10 => fnd_api.g_miss_char
, p_attribute11 => fnd_api.g_miss_char
, p_attribute12 => fnd_api.g_miss_char
, p_attribute13 => fnd_api.g_miss_char
, p_attribute14 => fnd_api.g_miss_char
, p_attribute15 => fnd_api.g_miss_char
, p_attribute_category => fnd_api.g_miss_char
, p_date_selected => fnd_api.g_miss_char
, p_category_id => fnd_api.g_miss_num
, p_multi_booked_flag => fnd_api.g_miss_char
, p_milestone_flag => fnd_api.g_miss_char
, p_holiday_flag => fnd_api.g_miss_char
, p_billable_flag => fnd_api.g_miss_char
, p_bound_mode_code => fnd_api.g_miss_char
, p_soft_bound_flag => fnd_api.g_miss_char
, p_workflow_process_id => fnd_api.g_miss_num
, p_notification_flag => fnd_api.g_miss_char
, p_notification_period => fnd_api.g_miss_num
, p_notification_period_uom => fnd_api.g_miss_char
, p_parent_task_id => fnd_api.g_miss_num
, p_alarm_start => fnd_api.g_miss_num
, p_alarm_start_uom => fnd_api.g_miss_char
, p_alarm_on => fnd_api.g_miss_char
, p_alarm_count => fnd_api.g_miss_num
, p_alarm_fired_count => fnd_api.g_miss_num
, p_alarm_interval => fnd_api.g_miss_num
, p_alarm_interval_uom => fnd_api.g_miss_char
, p_palm_flag => fnd_api.g_miss_char
, p_wince_flag => fnd_api.g_miss_char
, p_laptop_flag => fnd_api.g_miss_char
, p_device1_flag => fnd_api.g_miss_char
, p_device2_flag => fnd_api.g_miss_char
, p_device3_flag => fnd_api.g_miss_char
, p_costs => fnd_api.g_miss_num
, p_currency_code => fnd_api.g_miss_char
, p_escalation_level => fnd_api.g_miss_char
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_error
);
END UPDATE_SCH_DATE_TASK;