APPS.JTF_EC_PVT dependencies on JTF_TASKS_B

Line 61: l_escalation_id jtf_tasks_b.task_id%TYPE;

57: )
58: AS
59: l_api_version CONSTANT NUMBER := 1.0;
60: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ESCALATION';
61: l_escalation_id jtf_tasks_b.task_id%TYPE;
62: l_escalation_number jtf_tasks_b.task_number%TYPE;
63: --Created for BES enh 2660883
64: l_esc_rec_type jtf_ec_pvt.Esc_Rec_type;
65: BEGIN

Line 62: l_escalation_number jtf_tasks_b.task_number%TYPE;

58: AS
59: l_api_version CONSTANT NUMBER := 1.0;
60: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ESCALATION';
61: l_escalation_id jtf_tasks_b.task_id%TYPE;
62: l_escalation_number jtf_tasks_b.task_number%TYPE;
63: --Created for BES enh 2660883
64: l_esc_rec_type jtf_ec_pvt.Esc_Rec_type;
65: BEGIN
66:

Line 207: UPDATE jtf_tasks_b

203: x_return_status := fnd_api.g_ret_sts_unexp_error;
204: RAISE fnd_api.g_exc_unexpected_error;
205: END;
206:
207: UPDATE jtf_tasks_b
208: SET source_object_type_code = jtf_ec_pub.g_escalation_code,
209: source_object_id = l_escalation_id,
210: source_object_name = l_escalation_number
211: WHERE task_id = l_escalation_id;

Line 319: l_escalation_id jtf_tasks_b.task_id%TYPE := p_escalation_id ;

315: IS
316: l_api_version CONSTANT NUMBER := 1.0;
317: l_api_name CONSTANT VARCHAR2(30)
318: := 'UPDATE_ESCALATION';
319: l_escalation_id jtf_tasks_b.task_id%TYPE := p_escalation_id ;
320: l_escalation_number jtf_tasks_b.task_number%TYPE := p_escalation_number ;
321: l_description jtf_tasks_tl.description%TYPE := p_description;
322: l_escalation_name jtf_tasks_tl.task_name%TYPE
323: := p_escalation_name;

Line 320: l_escalation_number jtf_tasks_b.task_number%TYPE := p_escalation_number ;

316: l_api_version CONSTANT NUMBER := 1.0;
317: l_api_name CONSTANT VARCHAR2(30)
318: := 'UPDATE_ESCALATION';
319: l_escalation_id jtf_tasks_b.task_id%TYPE := p_escalation_id ;
320: l_escalation_number jtf_tasks_b.task_number%TYPE := p_escalation_number ;
321: l_description jtf_tasks_tl.description%TYPE := p_description;
322: l_escalation_name jtf_tasks_tl.task_name%TYPE
323: := p_escalation_name;
324: l_escalation_status_name jtf_task_statuses_tl.name%TYPE

Line 342: l_owner_id jtf_tasks_b.owner_id%TYPE;

338: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
339: l_cust_account_number hz_cust_accounts.account_number%TYPE;
340: l_address_id hz_party_sites.party_site_id%TYPE;
341: l_address_number hz_party_sites.party_site_number%TYPE;
342: l_owner_id jtf_tasks_b.owner_id%TYPE;
343: l_reason_code jtf_tasks_b.reason_code%TYPE;
344: l_private_flag jtf_tasks_b.private_flag%TYPE;
345: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
346: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;

Line 343: l_reason_code jtf_tasks_b.reason_code%TYPE;

339: l_cust_account_number hz_cust_accounts.account_number%TYPE;
340: l_address_id hz_party_sites.party_site_id%TYPE;
341: l_address_number hz_party_sites.party_site_number%TYPE;
342: l_owner_id jtf_tasks_b.owner_id%TYPE;
343: l_reason_code jtf_tasks_b.reason_code%TYPE;
344: l_private_flag jtf_tasks_b.private_flag%TYPE;
345: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
346: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
347: l_owner_type_code jtf_tasks_b.source_object_type_code%TYPE;

Line 344: l_private_flag jtf_tasks_b.private_flag%TYPE;

340: l_address_id hz_party_sites.party_site_id%TYPE;
341: l_address_number hz_party_sites.party_site_number%TYPE;
342: l_owner_id jtf_tasks_b.owner_id%TYPE;
343: l_reason_code jtf_tasks_b.reason_code%TYPE;
344: l_private_flag jtf_tasks_b.private_flag%TYPE;
345: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
346: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
347: l_owner_type_code jtf_tasks_b.source_object_type_code%TYPE;
348:

Line 345: l_publish_flag jtf_tasks_b.publish_flag%TYPE;

341: l_address_number hz_party_sites.party_site_number%TYPE;
342: l_owner_id jtf_tasks_b.owner_id%TYPE;
343: l_reason_code jtf_tasks_b.reason_code%TYPE;
344: l_private_flag jtf_tasks_b.private_flag%TYPE;
345: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
346: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
347: l_owner_type_code jtf_tasks_b.source_object_type_code%TYPE;
348:
349: CURSOR c_escalation_update (l_escalation_id IN NUMBER)

Line 346: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;

342: l_owner_id jtf_tasks_b.owner_id%TYPE;
343: l_reason_code jtf_tasks_b.reason_code%TYPE;
344: l_private_flag jtf_tasks_b.private_flag%TYPE;
345: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
346: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
347: l_owner_type_code jtf_tasks_b.source_object_type_code%TYPE;
348:
349: CURSOR c_escalation_update (l_escalation_id IN NUMBER)
350: IS

Line 347: l_owner_type_code jtf_tasks_b.source_object_type_code%TYPE;

343: l_reason_code jtf_tasks_b.reason_code%TYPE;
344: l_private_flag jtf_tasks_b.private_flag%TYPE;
345: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
346: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
347: l_owner_type_code jtf_tasks_b.source_object_type_code%TYPE;
348:
349: CURSOR c_escalation_update (l_escalation_id IN NUMBER)
350: IS
351: SELECT DECODE (

Line 755: l_escalation_id jtf_tasks_b.task_id%type := p_escalation_id ;

751: ) is
752: l_api_version CONSTANT NUMBER := 1.0;
753: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TASK';
754:
755: l_escalation_id jtf_tasks_b.task_id%type := p_escalation_id ;
756: l_escalation_number jtf_tasks_b.task_number%type := p_escalation_number ;
757: --Created for BES enh 2660883
758: l_esc_rec_type jtf_ec_pvt.Esc_Rec_type;
759:

Line 756: l_escalation_number jtf_tasks_b.task_number%type := p_escalation_number ;

752: l_api_version CONSTANT NUMBER := 1.0;
753: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TASK';
754:
755: l_escalation_id jtf_tasks_b.task_id%type := p_escalation_id ;
756: l_escalation_number jtf_tasks_b.task_number%type := p_escalation_number ;
757: --Created for BES enh 2660883
758: l_esc_rec_type jtf_ec_pvt.Esc_Rec_type;
759:
760: /* Bug # 3568448 */