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 OKC_RULES_B

Line 6: -- The following cursor changed by MSENGUPT on 12/08/2001 to change okc_rules_v to okc_rules_b

2: /* $Header: OKCPALTB.pls 120.0 2005/05/25 19:30:37 appldev noship $ */
3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4:
5: --Select escalation_owner_ID's
6: -- The following cursor changed by MSENGUPT on 12/08/2001 to change okc_rules_v to okc_rules_b
7: Cursor escal_owner_id(p_tve_id IN NUMBER) is
8: select rul.rule_information6 escalate_owner1_id
9: ,rul.rule_information7 escalate_owner2_id
10: ,rul.dnz_chr_id

Line 11: from okc_rules_b rul

7: Cursor escal_owner_id(p_tve_id IN NUMBER) is
8: select rul.rule_information6 escalate_owner1_id
9: ,rul.rule_information7 escalate_owner2_id
10: ,rul.dnz_chr_id
11: from okc_rules_b rul
12: where to_char(p_tve_id) = rul.rule_information2
13: and rul.rule_information_category = 'NTN';
14:
15: --Select Owner_names

Line 89: l_contract_id okc_rules_b.dnz_chr_id%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);
93: l_dummy VARCHAR2(100);

Line 90: l_escalation_owner1_id okc_rules_b.rule_information6%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);
93: l_dummy VARCHAR2(100);
94: l_escalate_owner1 fnd_user.user_name%TYPE;

Line 91: l_escalation_owner2_id okc_rules_b.rule_information7%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);
93: l_dummy VARCHAR2(100);
94: l_escalate_owner1 fnd_user.user_name%TYPE;
95: l_escalate_owner2 fnd_user.user_name%TYPE;

Line 509: l_contract_id okc_rules_b.dnz_chr_id%TYPE;

505:
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;

Line 518: l_escalation_owner1_id okc_rules_b.rule_information6%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;
522: l_escalate_name VARCHAR2(100);

Line 519: l_escalation_owner2_id okc_rules_b.rule_information7%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;
522: l_escalate_name VARCHAR2(100);
523: l_dummy VARCHAR2(100);

Line 951: l_contract_id okc_rules_b.dnz_chr_id%TYPE;

947: --and jtsl.name = 'Open';
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;

Line 960: l_escalation_owner1_id okc_rules_b.rule_information6%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);
964: l_escalate_owner1 fnd_user.user_name%TYPE;

Line 961: l_escalation_owner2_id okc_rules_b.rule_information7%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);
964: l_escalate_owner1 fnd_user.user_name%TYPE;
965: l_escalate_owner2 fnd_user.user_name%TYPE;