DBA Data[Home] [Help]

APPS.OKC_TASK_ALERT_ESCL_PVT dependencies on FND_USER

Line 17: Select fnd.user_name escalate_owner, okx.name full_name

13: and rul.rule_information_category = 'NTN';
14:
15: --Select Owner_names
16: Cursor escal_owner_cur(p_escal_owner_id IN NUMBER) is
17: Select fnd.user_name escalate_owner, okx.name full_name
18: from okx_resources_v okx, fnd_user fnd
19: where okx.user_id = fnd.user_id
20: and okx.id1 = p_escal_owner_id;
21:

Line 18: from okx_resources_v okx, fnd_user fnd

14:
15: --Select Owner_names
16: Cursor escal_owner_cur(p_escal_owner_id IN NUMBER) is
17: Select fnd.user_name escalate_owner, okx.name full_name
18: from okx_resources_v okx, fnd_user fnd
19: where okx.user_id = fnd.user_id
20: and okx.id1 = p_escal_owner_id;
21:
22: -- Following Local Procedure added for Bug 2477032

Line 19: where okx.user_id = fnd.user_id

15: --Select Owner_names
16: Cursor escal_owner_cur(p_escal_owner_id IN NUMBER) is
17: Select fnd.user_name escalate_owner, okx.name full_name
18: from okx_resources_v okx, fnd_user fnd
19: where okx.user_id = fnd.user_id
20: and okx.id1 = p_escal_owner_id;
21:
22: -- Following Local Procedure added for Bug 2477032
23:

Line 87: l_owner_name fnd_user.user_name%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;
91: l_escalation_owner2_id okc_rules_b.rule_information7%TYPE;

Line 94: l_escalate_owner1 fnd_user.user_name%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;
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;

Line 95: l_escalate_owner2 fnd_user.user_name%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;
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);

Line 516: l_owner_name fnd_user.user_name%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;
520: l_escalate_owner1 fnd_user.user_name%TYPE;

Line 520: l_escalate_owner1 fnd_user.user_name%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);
524: l_alarm_interval jtf_tasks_v.alarm_interval%TYPE;

Line 521: l_escalate_owner2 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);
524: l_alarm_interval jtf_tasks_v.alarm_interval%TYPE;
525: l_return_status VARCHAR2(3);

Line 958: l_owner_name fnd_user.user_name%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;
962: l_escalate_name VARCHAR2(100);

Line 964: l_escalate_owner1 fnd_user.user_name%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;
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;

Line 965: l_escalate_owner2 fnd_user.user_name%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;
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;