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.ZPB_SC_REASSIGN dependencies on ZPB_ANALYSIS_CYCLES

Line 20: p_owner_id IN zpb_analysis_cycles.owner_id%TYPE,

16: -- IN: p_business_area_id - Business Area Id
17: -------------------------------------------------------------------------------
18:
19: PROCEDURE reassign_all_objects (
20: p_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
21: p_new_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
22: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)
23:
24: IS

Line 21: p_new_owner_id IN zpb_analysis_cycles.owner_id%TYPE,

17: -------------------------------------------------------------------------------
18:
19: PROCEDURE reassign_all_objects (
20: p_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
21: p_new_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
22: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)
23:
24: IS
25: BEGIN

Line 22: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)

18:
19: PROCEDURE reassign_all_objects (
20: p_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
21: p_new_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
22: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)
23:
24: IS
25: BEGIN
26: reassign_bus_proc_objs(p_owner_id, p_new_owner_id, p_business_area_id);

Line 41: p_owner_id IN zpb_analysis_cycles.owner_id%TYPE,

37: -- IN: p_business_area_id - Business Area Id
38: -------------------------------------------------------------------------------
39:
40: PROCEDURE reassign_bus_proc_objs (
41: p_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
42: p_new_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
43: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)
44:
45: IS

Line 42: p_new_owner_id IN zpb_analysis_cycles.owner_id%TYPE,

38: -------------------------------------------------------------------------------
39:
40: PROCEDURE reassign_bus_proc_objs (
41: p_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
42: p_new_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
43: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)
44:
45: IS
46:

Line 43: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)

39:
40: PROCEDURE reassign_bus_proc_objs (
41: p_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
42: p_new_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
43: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)
44:
45: IS
46:
47: BEGIN

Line 54: zpb_analysis_cycles

50: 'Reassigning BP objects from user id: ' || p_owner_id ||
51: ' to user id: ' || p_new_owner_id);
52:
53: UPDATE
54: zpb_analysis_cycles
55: SET
56: owner_id = p_new_owner_id,
57: last_updated_by = fnd_global.USER_ID,
58: last_update_date = SYSDATE,

Line 77: p_owner_id IN zpb_analysis_cycles.owner_id%TYPE,

73: -- IN: p_business_area_id - Business Area Id
74: -------------------------------------------------------------------------------
75:
76: FUNCTION get_active_business_procs (
77: p_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
78: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)
79: return varchar2
80:
81: IS

Line 78: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)

74: -------------------------------------------------------------------------------
75:
76: FUNCTION get_active_business_procs (
77: p_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
78: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)
79: return varchar2
80:
81: IS
82:

Line 87: zpb_analysis_cycles

83: CURSOR active_bus_procs_cur is
84: SELECT
85: name
86: FROM
87: zpb_analysis_cycles
88: WHERE
89: owner_id = p_owner_id AND
90: business_area_id = p_business_area_id AND
91: status_code in ('DISABLE_ASAP', 'ENABLE_TASK', 'ERROR',

Line 122: p_owner_id IN zpb_analysis_cycles.owner_id%TYPE,

118: -- IN: p_business_area_id - Business Area Id
119: -------------------------------------------------------------------------------
120:
121: FUNCTION get_worksheets (
122: p_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
123: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)
124: return varchar2
125:
126: IS

Line 123: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)

119: -------------------------------------------------------------------------------
120:
121: FUNCTION get_worksheets (
122: p_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
123: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)
124: return varchar2
125:
126: IS
127:

Line 166: p_owner_id IN zpb_analysis_cycles.owner_id%TYPE,

162: -- IN: p_business_area_id - Business Area Id
163: -------------------------------------------------------------------------------
164:
165: PROCEDURE reassign_exception_objs (
166: p_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
167: p_new_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
168: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)
169: IS
170:

Line 167: p_new_owner_id IN zpb_analysis_cycles.owner_id%TYPE,

163: -------------------------------------------------------------------------------
164:
165: PROCEDURE reassign_exception_objs (
166: p_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
167: p_new_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
168: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)
169: IS
170:
171: l_new_owner_user_name fnd_user.user_name%TYPE;

Line 168: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)

164:
165: PROCEDURE reassign_exception_objs (
166: p_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
167: p_new_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
168: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)
169: IS
170:
171: l_new_owner_user_name fnd_user.user_name%TYPE;
172: l_owner_user_name fnd_user.user_name%TYPE;

Line 198: zpb_analysis_cycles ZAC

194: analysis_cycle_id in (SELECT
195: distinct(ZACT.analysis_cycle_id)
196: FROM
197: zpb_analysis_cycle_tasks ZACT,
198: zpb_analysis_cycles ZAC
199: WHERE
200: ZACT.analysis_cycle_id =
201: ZAC.analysis_cycle_id and
202: ZAC.business_area_id = p_business_area_id);

Line 221: zpb_analysis_cycles ZAC

217: ZTP.task_id
218: FROM
219: zpb_task_parameters ZTP,
220: zpb_analysis_cycle_tasks ZACT,
221: zpb_analysis_cycles ZAC
222: WHERE
223: ZTP.task_id = ZACT.task_id and
224: ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and
225: ZAC.business_area_id = p_business_area_id);

Line 243: zpb_analysis_cycles ZAC

239: ZTP.task_id
240: FROM
241: zpb_task_parameters ZTP,
242: zpb_analysis_cycle_tasks ZACT,
243: zpb_analysis_cycles ZAC
244: WHERE
245: ZTP.task_id = ZACT.task_id and
246: ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and
247: ZAC.business_area_id = p_business_area_id);

Line 265: zpb_analysis_cycles ZAC

261: ZTP.task_id
262: FROM
263: zpb_task_parameters ZTP,
264: zpb_analysis_cycle_tasks ZACT,
265: zpb_analysis_cycles ZAC
266: WHERE
267: ZTP.task_id = ZACT.task_id and
268: ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and
269: ZAC.business_area_id = p_business_area_id);

Line 287: zpb_analysis_cycles ZAC

283: ZTP.task_id
284: FROM
285: zpb_task_parameters ZTP,
286: zpb_analysis_cycle_tasks ZACT,
287: zpb_analysis_cycles ZAC
288: WHERE
289: ZTP.task_id = ZACT.task_id and
290: ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and
291: ZAC.business_area_id = p_business_area_id);

Line 309: zpb_analysis_cycles ZAC

305: ZTP.task_id
306: FROM
307: zpb_task_parameters ZTP,
308: zpb_analysis_cycle_tasks ZACT,
309: zpb_analysis_cycles ZAC
310: WHERE
311: ZTP.task_id = ZACT.task_id and
312: ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and
313: ZAC.business_area_id = p_business_area_id);

Line 332: zpb_analysis_cycles ZAC

328: ZTP.task_id
329: FROM
330: zpb_task_parameters ZTP,
331: zpb_analysis_cycle_tasks ZACT,
332: zpb_analysis_cycles ZAC
333: WHERE
334: ZTP.task_id = ZACT.task_id and
335: ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and
336: ZAC.business_area_id = p_business_area_id);