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.OKC_TASK_PVT dependencies on JTF_TASKS_B

Line 24: l_task_id jtf_tasks_b.task_id%TYPE;

20: ,x_msg_count OUT NOCOPY NUMBER
21: ,x_msg_data OUT NOCOPY VARCHAR2
22: ,x_task_id OUT NOCOPY NUMBER) IS
23: l_api_name CONSTANT VARCHAR2(30) := 'create_task';
24: l_task_id jtf_tasks_b.task_id%TYPE;
25: l_task_name jtf_tasks_tl.task_name%TYPE;
26: l_task_type_id jtf_task_types_b.task_type_id%TYPE;
27: l_task_type_name jtf_task_types_tl.name%TYPE;
28: l_status_id jtf_task_statuses_b.task_status_id%type;

Line 32: l_source_object_name jtf_tasks_b.source_object_name%TYPE;

28: l_status_id jtf_task_statuses_b.task_status_id%type;
29: l_status_name jtf_task_statuses_tl.name%type;
30: l_owner_type_code jtf_objects_b.object_code%TYPE;
31: l_source_object_code jtf_objects_b.object_code%TYPE;
32: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
33: l_private_flag jtf_tasks_b.private_flag%TYPE;
34: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
35: l_notification_period jtf_tasks_b.notification_period%TYPE;
36: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;

Line 33: l_private_flag jtf_tasks_b.private_flag%TYPE;

29: l_status_name jtf_task_statuses_tl.name%type;
30: l_owner_type_code jtf_objects_b.object_code%TYPE;
31: l_source_object_code jtf_objects_b.object_code%TYPE;
32: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
33: l_private_flag jtf_tasks_b.private_flag%TYPE;
34: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
35: l_notification_period jtf_tasks_b.notification_period%TYPE;
36: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
37: l_escalate_days jtf_tasks_b.alarm_start%TYPE;

Line 34: l_notification_flag jtf_tasks_b.notification_flag%TYPE;

30: l_owner_type_code jtf_objects_b.object_code%TYPE;
31: l_source_object_code jtf_objects_b.object_code%TYPE;
32: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
33: l_private_flag jtf_tasks_b.private_flag%TYPE;
34: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
35: l_notification_period jtf_tasks_b.notification_period%TYPE;
36: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
37: l_escalate_days jtf_tasks_b.alarm_start%TYPE;
38: l_alarm_start jtf_tasks_b.alarm_start%TYPE;

Line 35: l_notification_period jtf_tasks_b.notification_period%TYPE;

31: l_source_object_code jtf_objects_b.object_code%TYPE;
32: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
33: l_private_flag jtf_tasks_b.private_flag%TYPE;
34: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
35: l_notification_period jtf_tasks_b.notification_period%TYPE;
36: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
37: l_escalate_days jtf_tasks_b.alarm_start%TYPE;
38: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
39: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;

Line 36: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;

32: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
33: l_private_flag jtf_tasks_b.private_flag%TYPE;
34: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
35: l_notification_period jtf_tasks_b.notification_period%TYPE;
36: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
37: l_escalate_days jtf_tasks_b.alarm_start%TYPE;
38: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
39: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
40: l_alarm_count jtf_tasks_b.alarm_count%TYPE;

Line 37: l_escalate_days jtf_tasks_b.alarm_start%TYPE;

33: l_private_flag jtf_tasks_b.private_flag%TYPE;
34: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
35: l_notification_period jtf_tasks_b.notification_period%TYPE;
36: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
37: l_escalate_days jtf_tasks_b.alarm_start%TYPE;
38: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
39: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
40: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
41: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;

Line 38: l_alarm_start jtf_tasks_b.alarm_start%TYPE;

34: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
35: l_notification_period jtf_tasks_b.notification_period%TYPE;
36: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
37: l_escalate_days jtf_tasks_b.alarm_start%TYPE;
38: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
39: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
40: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
41: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
42: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;

Line 39: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;

35: l_notification_period jtf_tasks_b.notification_period%TYPE;
36: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
37: l_escalate_days jtf_tasks_b.alarm_start%TYPE;
38: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
39: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
40: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
41: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
42: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;
43: l_deleted_flag jtf_tasks_b.deleted_flag%TYPE;

Line 40: l_alarm_count jtf_tasks_b.alarm_count%TYPE;

36: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
37: l_escalate_days jtf_tasks_b.alarm_start%TYPE;
38: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
39: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
40: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
41: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
42: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;
43: l_deleted_flag jtf_tasks_b.deleted_flag%TYPE;
44: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;

Line 41: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;

37: l_escalate_days jtf_tasks_b.alarm_start%TYPE;
38: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
39: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
40: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
41: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
42: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;
43: l_deleted_flag jtf_tasks_b.deleted_flag%TYPE;
44: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
45: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;

Line 42: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;

38: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
39: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
40: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
41: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
42: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;
43: l_deleted_flag jtf_tasks_b.deleted_flag%TYPE;
44: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
45: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
46: l_resolved_time_id VARCHAR2(300);

Line 43: l_deleted_flag jtf_tasks_b.deleted_flag%TYPE;

39: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
40: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
41: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
42: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;
43: l_deleted_flag jtf_tasks_b.deleted_flag%TYPE;
44: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
45: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
46: l_resolved_time_id VARCHAR2(300);
47: l_day_uom VARCHAR2(30);

Line 337: l_task_id jtf_tasks_b.task_id%TYPE;

333: ,x_msg_count OUT NOCOPY NUMBER
334: ,x_msg_data OUT NOCOPY VARCHAR2
335: ,x_task_id OUT NOCOPY NUMBER) IS
336: l_api_name CONSTANT VARCHAR2(30) := 'create_condition_task';
337: l_task_id jtf_tasks_b.task_id%TYPE;
338: l_task_type_id jtf_task_types_b.task_type_id%TYPE;
339: l_task_type_name jtf_task_types_tl.name%TYPE;
340: l_status_id jtf_task_statuses_b.task_status_id%type;
341: l_status_name jtf_task_statuses_tl.name%type;

Line 343: l_private_flag jtf_tasks_b.private_flag%TYPE;

339: l_task_type_name jtf_task_types_tl.name%TYPE;
340: l_status_id jtf_task_statuses_b.task_status_id%type;
341: l_status_name jtf_task_statuses_tl.name%type;
342: l_source_object_code jtf_objects_b.object_code%TYPE;
343: l_private_flag jtf_tasks_b.private_flag%TYPE;
344: l_deleted_flag jtf_tasks_b.deleted_flag%TYPE;
345: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
346: l_owner_type_code jtf_objects_b.object_code%TYPE;
347: l_owner_id jtf_tasks_b.owner_id%TYPE;

Line 344: l_deleted_flag jtf_tasks_b.deleted_flag%TYPE;

340: l_status_id jtf_task_statuses_b.task_status_id%type;
341: l_status_name jtf_task_statuses_tl.name%type;
342: l_source_object_code jtf_objects_b.object_code%TYPE;
343: l_private_flag jtf_tasks_b.private_flag%TYPE;
344: l_deleted_flag jtf_tasks_b.deleted_flag%TYPE;
345: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
346: l_owner_type_code jtf_objects_b.object_code%TYPE;
347: l_owner_id jtf_tasks_b.owner_id%TYPE;
348:

Line 345: l_source_object_name jtf_tasks_b.source_object_name%TYPE;

341: l_status_name jtf_task_statuses_tl.name%type;
342: l_source_object_code jtf_objects_b.object_code%TYPE;
343: l_private_flag jtf_tasks_b.private_flag%TYPE;
344: l_deleted_flag jtf_tasks_b.deleted_flag%TYPE;
345: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
346: l_owner_type_code jtf_objects_b.object_code%TYPE;
347: l_owner_id jtf_tasks_b.owner_id%TYPE;
348:
349: l_source_doc_number VARCHAR2(200);

Line 347: l_owner_id jtf_tasks_b.owner_id%TYPE;

343: l_private_flag jtf_tasks_b.private_flag%TYPE;
344: l_deleted_flag jtf_tasks_b.deleted_flag%TYPE;
345: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
346: l_owner_type_code jtf_objects_b.object_code%TYPE;
347: l_owner_id jtf_tasks_b.owner_id%TYPE;
348:
349: l_source_doc_number VARCHAR2(200);
350:
351: -- Replaced name with seeded ids to avoid translation issues - Bug 1683539

Line 496: l_task_id jtf_tasks_b.task_id%TYPE;

492: ,x_msg_count OUT NOCOPY NUMBER
493: ,x_msg_data OUT NOCOPY VARCHAR2
494: ,x_task_id OUT NOCOPY NUMBER) IS
495: l_api_name CONSTANT VARCHAR2(30) := 'create_contingent_task';
496: l_task_id jtf_tasks_b.task_id%TYPE;
497: l_task_type_id jtf_task_types_b.task_type_id%TYPE;
498: l_task_type_name jtf_task_types_tl.name%TYPE;
499: l_status_id jtf_task_statuses_b.task_status_id%type;
500: l_status_name jtf_task_statuses_tl.name%type;

Line 502: l_private_flag jtf_tasks_b.private_flag%TYPE;

498: l_task_type_name jtf_task_types_tl.name%TYPE;
499: l_status_id jtf_task_statuses_b.task_status_id%type;
500: l_status_name jtf_task_statuses_tl.name%type;
501: l_source_object_code jtf_objects_b.object_code%TYPE;
502: l_private_flag jtf_tasks_b.private_flag%TYPE;
503: l_deleted_flag jtf_tasks_b.deleted_flag%TYPE;
504: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
505: l_owner_type_code jtf_objects_b.object_code%TYPE;
506: l_owner_id jtf_tasks_b.owner_id%TYPE;

Line 503: l_deleted_flag jtf_tasks_b.deleted_flag%TYPE;

499: l_status_id jtf_task_statuses_b.task_status_id%type;
500: l_status_name jtf_task_statuses_tl.name%type;
501: l_source_object_code jtf_objects_b.object_code%TYPE;
502: l_private_flag jtf_tasks_b.private_flag%TYPE;
503: l_deleted_flag jtf_tasks_b.deleted_flag%TYPE;
504: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
505: l_owner_type_code jtf_objects_b.object_code%TYPE;
506: l_owner_id jtf_tasks_b.owner_id%TYPE;
507:

Line 504: l_source_object_name jtf_tasks_b.source_object_name%TYPE;

500: l_status_name jtf_task_statuses_tl.name%type;
501: l_source_object_code jtf_objects_b.object_code%TYPE;
502: l_private_flag jtf_tasks_b.private_flag%TYPE;
503: l_deleted_flag jtf_tasks_b.deleted_flag%TYPE;
504: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
505: l_owner_type_code jtf_objects_b.object_code%TYPE;
506: l_owner_id jtf_tasks_b.owner_id%TYPE;
507:
508: -- Replaced name with seeded ids to avoid translation issues - Bug 1683539

Line 506: l_owner_id jtf_tasks_b.owner_id%TYPE;

502: l_private_flag jtf_tasks_b.private_flag%TYPE;
503: l_deleted_flag jtf_tasks_b.deleted_flag%TYPE;
504: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
505: l_owner_type_code jtf_objects_b.object_code%TYPE;
506: l_owner_id jtf_tasks_b.owner_id%TYPE;
507:
508: -- Replaced name with seeded ids to avoid translation issues - Bug 1683539
509: -- Read OKCCONTINGENT - Contract Contingent Event
510: --Select task_type

Line 655: l_source_object_id jtf_tasks_b.source_object_id%TYPE;

651: l_close_status_id jtf_tasks_v.task_status_id%TYPE;
652: l_open_status_id jtf_tasks_v.task_status_id%TYPE;
653: l_close_status_name jtf_tasks_v.task_status%TYPE;
654: l_open_status_name jtf_tasks_v.task_status%TYPE;
655: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
656: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
657:
658: -- Replaced name with seeded ids to avoid translation issues - Bug 1683539
659: --Select task status

Line 656: l_source_object_name jtf_tasks_b.source_object_name%TYPE;

652: l_open_status_id jtf_tasks_v.task_status_id%TYPE;
653: l_close_status_name jtf_tasks_v.task_status%TYPE;
654: l_open_status_name jtf_tasks_v.task_status%TYPE;
655: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
656: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
657:
658: -- Replaced name with seeded ids to avoid translation issues - Bug 1683539
659: --Select task status
660: Cursor update_status_cur is

Line 678: From jtf_tasks_b

674: -- Get source Object Details
675: Cursor source_obj_details IS
676: Select SOURCE_OBJECT_ID
677: ,SOURCE_OBJECT_NAME
678: From jtf_tasks_b
679: Where task_id = p_task_id;
680:
681: l_notfound BOOLEAN;
682:

Line 780: from jtf_tasks_b jtf

776:
777: --Select task for a given resolved timevalue id
778: Cursor delete_tasks_cur(p_rtv_id IN NUMBER, p_status_id IN NUMBER) IS
779: select jtf.task_id, jtf.task_number, jtf.object_version_number
780: from jtf_tasks_b jtf
781: where jtf.source_object_id = p_rtv_id
782: and jtf.source_object_type_code = 'OKC_RESTIME'
783: and jtf.task_status_id = p_status_id;
784:

Line 800: task_id jtf_tasks_b.task_id%TYPE,

796: from okc_resolved_timevalues rtv
797: where rtv.tve_id = p_tve_id;
798:
799: TYPE delete_rec_type IS RECORD(
800: task_id jtf_tasks_b.task_id%TYPE,
801: task_number jtf_tasks_b.task_number%TYPE,
802: object_version_number jtf_tasks_b.object_version_number%TYPE);
803: TYPE delete_tasks_tbl_type IS TABLE OF delete_rec_type
804: INDEX BY BINARY_INTEGER;

Line 801: task_number jtf_tasks_b.task_number%TYPE,

797: where rtv.tve_id = p_tve_id;
798:
799: TYPE delete_rec_type IS RECORD(
800: task_id jtf_tasks_b.task_id%TYPE,
801: task_number jtf_tasks_b.task_number%TYPE,
802: object_version_number jtf_tasks_b.object_version_number%TYPE);
803: TYPE delete_tasks_tbl_type IS TABLE OF delete_rec_type
804: INDEX BY BINARY_INTEGER;
805: delete_tasks_tbl delete_tasks_tbl_type;

Line 802: object_version_number jtf_tasks_b.object_version_number%TYPE);

798:
799: TYPE delete_rec_type IS RECORD(
800: task_id jtf_tasks_b.task_id%TYPE,
801: task_number jtf_tasks_b.task_number%TYPE,
802: object_version_number jtf_tasks_b.object_version_number%TYPE);
803: TYPE delete_tasks_tbl_type IS TABLE OF delete_rec_type
804: INDEX BY BINARY_INTEGER;
805: delete_tasks_tbl delete_tasks_tbl_type;
806:

Line 809: l_status_id jtf_tasks_b.task_status_id%TYPE;

805: delete_tasks_tbl delete_tasks_tbl_type;
806:
807: delete_ctr NUMBER := 0;
808: i NUMBER := 0;
809: l_status_id jtf_tasks_b.task_status_id%TYPE;
810: l_task_id jtf_tasks_b.task_id%TYPE;
811: l_task_number jtf_tasks_b.task_number%TYPE;
812: l_object_version_number jtf_tasks_b.object_version_number%TYPE;
813: BEGIN

Line 810: l_task_id jtf_tasks_b.task_id%TYPE;

806:
807: delete_ctr NUMBER := 0;
808: i NUMBER := 0;
809: l_status_id jtf_tasks_b.task_status_id%TYPE;
810: l_task_id jtf_tasks_b.task_id%TYPE;
811: l_task_number jtf_tasks_b.task_number%TYPE;
812: l_object_version_number jtf_tasks_b.object_version_number%TYPE;
813: BEGIN
814: --If the timevalue ID is not null then delete all the tasks for a rule with status = 'Open'

Line 811: l_task_number jtf_tasks_b.task_number%TYPE;

807: delete_ctr NUMBER := 0;
808: i NUMBER := 0;
809: l_status_id jtf_tasks_b.task_status_id%TYPE;
810: l_task_id jtf_tasks_b.task_id%TYPE;
811: l_task_number jtf_tasks_b.task_number%TYPE;
812: l_object_version_number jtf_tasks_b.object_version_number%TYPE;
813: BEGIN
814: --If the timevalue ID is not null then delete all the tasks for a rule with status = 'Open'
815: IF p_tve_id IS NOT NULL THEN

Line 812: l_object_version_number jtf_tasks_b.object_version_number%TYPE;

808: i NUMBER := 0;
809: l_status_id jtf_tasks_b.task_status_id%TYPE;
810: l_task_id jtf_tasks_b.task_id%TYPE;
811: l_task_number jtf_tasks_b.task_number%TYPE;
812: l_object_version_number jtf_tasks_b.object_version_number%TYPE;
813: BEGIN
814: --If the timevalue ID is not null then delete all the tasks for a rule with status = 'Open'
815: IF p_tve_id IS NOT NULL THEN
816: OPEN delete_status_cur;

Line 849: -- where source_object_id(JTF_TASKS_B) = p_rtv_id(resolved timevalue ID)

845: END IF;
846: END IF;
847:
848: --If the resolved timevalue id is not null then delete a single task
849: -- where source_object_id(JTF_TASKS_B) = p_rtv_id(resolved timevalue ID)
850: -- and the status is OKCOPEN
851: IF p_rtv_id IS NOT NULL THEN
852: OPEN delete_status_cur;
853: FETCH delete_status_cur into l_status_id;