[Home] [Help]
69: WHERE Deliverable_id = P_Deliverable_ID;
70:
71: CURSOR o IS
72: SELECT user_name
73: FROM fnd_user
74: WHERE user_id = P_Updated_By;
75:
76: CURSOR new_action IS
77: SELECT wf_item_type
84: -- Add effective_start_date and effective_end_date.
85: -- Only one person can be active at one time.
86: --
87: -- Aut 08, 2003 : bug 3051397. Send notification to Action Owner
88: -- if action owner is a WF_ROLE (must be a FND_USER), otherwise send to
89: -- Requestor who log the communication.
90: -- Use wf_roiles instead of per_people_f
91: CURSOR p IS
92: SELECT name, display_name
99: l_wf_item_key VARCHAR2(240);
100: l_wf_user_key VARCHAR2(240);
101:
102: -- Aug 08, 2003 Bug 3051397. Change variable length from 30 to 100
103: -- according to the column length of FND_USER
104: l_user_name VARCHAR2(100);
105: l_requestor VARCHAR2(100);
106:
107: l_contract_num VARCHAR2(240);
348: WHERE Deliverable_id = P_Deliverable_ID;
349:
350: CURSOR o IS
351: SELECT user_name
352: FROM fnd_user
353: WHERE user_id = P_Updated_By;
354:
355: CURSOR comm_type IS
356: SELECT meaning
377: -- Add effective_start_date and effective_end_date.
378: -- Only one person can be active at one time.
379: --
380: -- Aut 08, 2003 : bug 3051397. Send notification to Action Owner
381: -- if action owner is a WF_ROLE (must be a FND_USER), otherwise send to
382: -- Requestor who log the communication.
383: -- Use wf_roiles instead of per_people_f
384: CURSOR p IS
385: SELECT name, display_name
400: l_wf_user_key VARCHAR2(240);
401: l_wf_threshold NUMBER;
402:
403: -- Aug 08, 2003 Bug 3051397. Change variable length from 30 to 100
404: -- according to the column length of FND_USER
405: l_user_name VARCHAR2(100);
406: l_requestor VARCHAR2(100);
407:
408: l_contract_num VARCHAR2(240);