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_ALERT_ESCL_PVT dependencies on JTF_TASKS_B

Line 81: l_task_id jtf_tasks_b.task_id%TYPE;

77: --and jtsl.name = 'Open';
78:
79: l_workflow_process_id jtf_tasks_v.workflow_process_id%TYPE;
80: l_object_version_number NUMBER;
81: l_task_id jtf_tasks_b.task_id%TYPE;
82: l_task_number jtf_tasks_b.task_number%TYPE;
83: l_task_name jtf_tasks_tl.task_name%TYPE;
84: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
85: l_notification_period jtf_tasks_b.notification_period%TYPE;

Line 82: l_task_number jtf_tasks_b.task_number%TYPE;

78:
79: l_workflow_process_id jtf_tasks_v.workflow_process_id%TYPE;
80: l_object_version_number NUMBER;
81: l_task_id jtf_tasks_b.task_id%TYPE;
82: l_task_number jtf_tasks_b.task_number%TYPE;
83: l_task_name jtf_tasks_tl.task_name%TYPE;
84: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
85: l_notification_period jtf_tasks_b.notification_period%TYPE;
86: l_owner_id jtf_tasks_b.owner_id%TYPE;

Line 84: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;

80: l_object_version_number NUMBER;
81: l_task_id jtf_tasks_b.task_id%TYPE;
82: l_task_number jtf_tasks_b.task_number%TYPE;
83: l_task_name jtf_tasks_tl.task_name%TYPE;
84: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
85: l_notification_period jtf_tasks_b.notification_period%TYPE;
86: l_owner_id jtf_tasks_b.owner_id%TYPE;
87: l_owner_name fnd_user.user_name%TYPE;
88: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;

Line 85: l_notification_period jtf_tasks_b.notification_period%TYPE;

81: l_task_id jtf_tasks_b.task_id%TYPE;
82: l_task_number jtf_tasks_b.task_number%TYPE;
83: l_task_name jtf_tasks_tl.task_name%TYPE;
84: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
85: l_notification_period jtf_tasks_b.notification_period%TYPE;
86: l_owner_id jtf_tasks_b.owner_id%TYPE;
87: l_owner_name fnd_user.user_name%TYPE;
88: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;
89: l_contract_id okc_rules_b.dnz_chr_id%TYPE;

Line 86: l_owner_id jtf_tasks_b.owner_id%TYPE;

82: l_task_number jtf_tasks_b.task_number%TYPE;
83: l_task_name jtf_tasks_tl.task_name%TYPE;
84: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
85: l_notification_period jtf_tasks_b.notification_period%TYPE;
86: l_owner_id jtf_tasks_b.owner_id%TYPE;
87: l_owner_name fnd_user.user_name%TYPE;
88: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;
89: l_contract_id okc_rules_b.dnz_chr_id%TYPE;
90: l_escalation_owner1_id okc_rules_b.rule_information6%TYPE;

Line 88: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;

84: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
85: l_notification_period jtf_tasks_b.notification_period%TYPE;
86: l_owner_id jtf_tasks_b.owner_id%TYPE;
87: l_owner_name fnd_user.user_name%TYPE;
88: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;
89: l_contract_id okc_rules_b.dnz_chr_id%TYPE;
90: l_escalation_owner1_id okc_rules_b.rule_information6%TYPE;
91: l_escalation_owner2_id okc_rules_b.rule_information7%TYPE;
92: l_escalate_name VARCHAR2(100);

Line 96: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;

92: l_escalate_name VARCHAR2(100);
93: l_dummy VARCHAR2(100);
94: l_escalate_owner1 fnd_user.user_name%TYPE;
95: l_escalate_owner2 fnd_user.user_name%TYPE;
96: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
97: l_planned_date jtf_tasks_b.planned_end_date%TYPE;
98: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
99: l_item_type VARCHAR2(30);
100: l_item_key NUMBER;

Line 97: l_planned_date jtf_tasks_b.planned_end_date%TYPE;

93: l_dummy VARCHAR2(100);
94: l_escalate_owner1 fnd_user.user_name%TYPE;
95: l_escalate_owner2 fnd_user.user_name%TYPE;
96: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
97: l_planned_date jtf_tasks_b.planned_end_date%TYPE;
98: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
99: l_item_type VARCHAR2(30);
100: l_item_key NUMBER;
101: l_tve_id NUMBER;

Line 98: l_source_object_id jtf_tasks_b.source_object_id%TYPE;

94: l_escalate_owner1 fnd_user.user_name%TYPE;
95: l_escalate_owner2 fnd_user.user_name%TYPE;
96: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
97: l_planned_date jtf_tasks_b.planned_end_date%TYPE;
98: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
99: l_item_type VARCHAR2(30);
100: l_item_key NUMBER;
101: l_tve_id NUMBER;
102: l_process VARCHAR2(30);

Line 510: l_task_id jtf_tasks_b.task_id%TYPE;

506: l_workflow_process_id jtf_tasks_v.workflow_process_id%TYPE;
507: l_object_version_number NUMBER;
508: l_tve_id NUMBER;
509: l_contract_id okc_rules_b.dnz_chr_id%TYPE;
510: l_task_id jtf_tasks_b.task_id%TYPE;
511: l_task_number jtf_tasks_b.task_number%TYPE;
512: l_task_name jtf_tasks_tl.task_name%TYPE;
513: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
514: l_notification_period jtf_tasks_b.notification_period%TYPE;

Line 511: l_task_number jtf_tasks_b.task_number%TYPE;

507: l_object_version_number NUMBER;
508: l_tve_id NUMBER;
509: l_contract_id okc_rules_b.dnz_chr_id%TYPE;
510: l_task_id jtf_tasks_b.task_id%TYPE;
511: l_task_number jtf_tasks_b.task_number%TYPE;
512: l_task_name jtf_tasks_tl.task_name%TYPE;
513: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
514: l_notification_period jtf_tasks_b.notification_period%TYPE;
515: l_owner_id jtf_tasks_b.owner_id%TYPE;

Line 513: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;

509: l_contract_id okc_rules_b.dnz_chr_id%TYPE;
510: l_task_id jtf_tasks_b.task_id%TYPE;
511: l_task_number jtf_tasks_b.task_number%TYPE;
512: l_task_name jtf_tasks_tl.task_name%TYPE;
513: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
514: l_notification_period jtf_tasks_b.notification_period%TYPE;
515: l_owner_id jtf_tasks_b.owner_id%TYPE;
516: l_owner_name fnd_user.user_name%TYPE;
517: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;

Line 514: l_notification_period jtf_tasks_b.notification_period%TYPE;

510: l_task_id jtf_tasks_b.task_id%TYPE;
511: l_task_number jtf_tasks_b.task_number%TYPE;
512: l_task_name jtf_tasks_tl.task_name%TYPE;
513: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
514: l_notification_period jtf_tasks_b.notification_period%TYPE;
515: l_owner_id jtf_tasks_b.owner_id%TYPE;
516: l_owner_name fnd_user.user_name%TYPE;
517: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;
518: l_escalation_owner1_id okc_rules_b.rule_information6%TYPE;

Line 515: l_owner_id jtf_tasks_b.owner_id%TYPE;

511: l_task_number jtf_tasks_b.task_number%TYPE;
512: l_task_name jtf_tasks_tl.task_name%TYPE;
513: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
514: l_notification_period jtf_tasks_b.notification_period%TYPE;
515: l_owner_id jtf_tasks_b.owner_id%TYPE;
516: l_owner_name fnd_user.user_name%TYPE;
517: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;
518: l_escalation_owner1_id okc_rules_b.rule_information6%TYPE;
519: l_escalation_owner2_id okc_rules_b.rule_information7%TYPE;

Line 517: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;

513: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
514: l_notification_period jtf_tasks_b.notification_period%TYPE;
515: l_owner_id jtf_tasks_b.owner_id%TYPE;
516: l_owner_name fnd_user.user_name%TYPE;
517: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;
518: l_escalation_owner1_id okc_rules_b.rule_information6%TYPE;
519: l_escalation_owner2_id okc_rules_b.rule_information7%TYPE;
520: l_escalate_owner1 fnd_user.user_name%TYPE;
521: l_escalate_owner2 fnd_user.user_name%TYPE;

Line 526: l_planned_date jtf_tasks_b.planned_end_date%TYPE;

522: l_escalate_name VARCHAR2(100);
523: l_dummy VARCHAR2(100);
524: l_alarm_interval jtf_tasks_v.alarm_interval%TYPE;
525: l_return_status VARCHAR2(3);
526: l_planned_date jtf_tasks_b.planned_end_date%TYPE;
527: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
528: l_item_type VARCHAR2(30);
529: l_item_key NUMBER;
530: l_process VARCHAR2(30);

Line 527: l_source_object_id jtf_tasks_b.source_object_id%TYPE;

523: l_dummy VARCHAR2(100);
524: l_alarm_interval jtf_tasks_v.alarm_interval%TYPE;
525: l_return_status VARCHAR2(3);
526: l_planned_date jtf_tasks_b.planned_end_date%TYPE;
527: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
528: l_item_type VARCHAR2(30);
529: l_item_key NUMBER;
530: l_process VARCHAR2(30);
531: l_api_name CONSTANT VARCHAR2(30) := 'task_escalation1';

Line 952: l_task_id jtf_tasks_b.task_id%TYPE;

948:
949: l_workflow_process_id jtf_tasks_v.workflow_process_id%TYPE;
950: l_object_version_number NUMBER;
951: l_contract_id okc_rules_b.dnz_chr_id%TYPE;
952: l_task_id jtf_tasks_b.task_id%TYPE;
953: l_task_number jtf_tasks_b.task_number%TYPE;
954: l_task_name jtf_tasks_tl.task_name%TYPE;
955: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
956: l_notification_period jtf_tasks_b.notification_period%TYPE;

Line 953: l_task_number jtf_tasks_b.task_number%TYPE;

949: l_workflow_process_id jtf_tasks_v.workflow_process_id%TYPE;
950: l_object_version_number NUMBER;
951: l_contract_id okc_rules_b.dnz_chr_id%TYPE;
952: l_task_id jtf_tasks_b.task_id%TYPE;
953: l_task_number jtf_tasks_b.task_number%TYPE;
954: l_task_name jtf_tasks_tl.task_name%TYPE;
955: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
956: l_notification_period jtf_tasks_b.notification_period%TYPE;
957: l_owner_id jtf_tasks_b.owner_id%TYPE;

Line 955: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;

951: l_contract_id okc_rules_b.dnz_chr_id%TYPE;
952: l_task_id jtf_tasks_b.task_id%TYPE;
953: l_task_number jtf_tasks_b.task_number%TYPE;
954: l_task_name jtf_tasks_tl.task_name%TYPE;
955: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
956: l_notification_period jtf_tasks_b.notification_period%TYPE;
957: l_owner_id jtf_tasks_b.owner_id%TYPE;
958: l_owner_name fnd_user.user_name%TYPE;
959: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;

Line 956: l_notification_period jtf_tasks_b.notification_period%TYPE;

952: l_task_id jtf_tasks_b.task_id%TYPE;
953: l_task_number jtf_tasks_b.task_number%TYPE;
954: l_task_name jtf_tasks_tl.task_name%TYPE;
955: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
956: l_notification_period jtf_tasks_b.notification_period%TYPE;
957: l_owner_id jtf_tasks_b.owner_id%TYPE;
958: l_owner_name fnd_user.user_name%TYPE;
959: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;
960: l_escalation_owner1_id okc_rules_b.rule_information6%TYPE;

Line 957: l_owner_id jtf_tasks_b.owner_id%TYPE;

953: l_task_number jtf_tasks_b.task_number%TYPE;
954: l_task_name jtf_tasks_tl.task_name%TYPE;
955: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
956: l_notification_period jtf_tasks_b.notification_period%TYPE;
957: l_owner_id jtf_tasks_b.owner_id%TYPE;
958: l_owner_name fnd_user.user_name%TYPE;
959: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;
960: l_escalation_owner1_id okc_rules_b.rule_information6%TYPE;
961: l_escalation_owner2_id okc_rules_b.rule_information7%TYPE;

Line 959: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;

955: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
956: l_notification_period jtf_tasks_b.notification_period%TYPE;
957: l_owner_id jtf_tasks_b.owner_id%TYPE;
958: l_owner_name fnd_user.user_name%TYPE;
959: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;
960: l_escalation_owner1_id okc_rules_b.rule_information6%TYPE;
961: l_escalation_owner2_id okc_rules_b.rule_information7%TYPE;
962: l_escalate_name VARCHAR2(100);
963: l_dummy VARCHAR2(100);

Line 966: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;

962: l_escalate_name VARCHAR2(100);
963: l_dummy VARCHAR2(100);
964: l_escalate_owner1 fnd_user.user_name%TYPE;
965: l_escalate_owner2 fnd_user.user_name%TYPE;
966: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
967: l_return_status VARCHAR2(3);
968: l_planned_date jtf_tasks_b.planned_end_date%TYPE;
969: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
970: l_item_type VARCHAR2(30);

Line 968: l_planned_date jtf_tasks_b.planned_end_date%TYPE;

964: l_escalate_owner1 fnd_user.user_name%TYPE;
965: l_escalate_owner2 fnd_user.user_name%TYPE;
966: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
967: l_return_status VARCHAR2(3);
968: l_planned_date jtf_tasks_b.planned_end_date%TYPE;
969: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
970: l_item_type VARCHAR2(30);
971: l_item_key NUMBER;
972: l_tve_id NUMBER;

Line 969: l_source_object_id jtf_tasks_b.source_object_id%TYPE;

965: l_escalate_owner2 fnd_user.user_name%TYPE;
966: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
967: l_return_status VARCHAR2(3);
968: l_planned_date jtf_tasks_b.planned_end_date%TYPE;
969: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
970: l_item_type VARCHAR2(30);
971: l_item_key NUMBER;
972: l_tve_id NUMBER;
973: l_process VARCHAR2(30);

Line 1347: from jtf_tasks_b

1343: p_init_msg_list IN VARCHAR2) IS
1344:
1345: CURSOR planned_date_cur IS
1346: SELECT planned_end_date, source_object_id
1347: from jtf_tasks_b
1348: where source_object_type_code = 'OKC_RESTIME';
1349:
1350: l_return_status VARCHAR2(3);
1351: l_planned_date jtf_tasks_b.planned_end_date%TYPE;

Line 1351: l_planned_date jtf_tasks_b.planned_end_date%TYPE;

1347: from jtf_tasks_b
1348: where source_object_type_code = 'OKC_RESTIME';
1349:
1350: l_return_status VARCHAR2(3);
1351: l_planned_date jtf_tasks_b.planned_end_date%TYPE;
1352: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
1353: l_api_name CONSTANT VARCHAR2(30) := 'okc_pdate_reach_pvt';
1354:
1355: BEGIN

Line 1352: l_source_object_id jtf_tasks_b.source_object_id%TYPE;

1348: where source_object_type_code = 'OKC_RESTIME';
1349:
1350: l_return_status VARCHAR2(3);
1351: l_planned_date jtf_tasks_b.planned_end_date%TYPE;
1352: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
1353: l_api_name CONSTANT VARCHAR2(30) := 'okc_pdate_reach_pvt';
1354:
1355: BEGIN
1356: