APPS.ZPB_SC_REASSIGN dependencies on ZPB_SC_REASSIGN

Line 1: PACKAGE BODY ZPB_SC_REASSIGN AS

1: PACKAGE BODY ZPB_SC_REASSIGN AS
2: /* $Header: zpbscreassign.plb 120.0.12010.2 2005/12/23 08:57:23 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(15) := 'zpb_sc_reassign';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(15) := 'zpb_sc_reassign';

1: PACKAGE BODY ZPB_SC_REASSIGN AS
2: /* $Header: zpbscreassign.plb 120.0.12010.2 2005/12/23 08:57:23 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(15) := 'zpb_sc_reassign';
5:
6:
7: /*
8: * Public */

Line 49: zpb_log.write('zpb_sc_reassign.reassign_bus_proc_objs',

45: IS
46:
47: BEGIN
48:
49: zpb_log.write('zpb_sc_reassign.reassign_bus_proc_objs',
50: 'Reassigning BP objects from user id: ' || p_owner_id ||
51: ' to user id: ' || p_new_owner_id);
52:
53: UPDATE

Line 64: zpb_log.write('zpb_sc_reassign.reassign_bus_proc_objs', 'End');

60: WHERE
61: owner_id = p_owner_id AND
62: business_area_id = p_business_area_id;
63:
64: zpb_log.write('zpb_sc_reassign.reassign_bus_proc_objs', 'End');
65:
66: END;
67:
68: -------------------------------------------------------------------------------

Line 99: zpb_log.write('zpb_sc_reassign.get_active_business_procs', 'Getting list of active Business Processes');

95: l_business_proc_names varchar2(1000); -- name is varchar2(300).
96: -- s/b MAX_LENGTH
97:
98: BEGIN
99: zpb_log.write('zpb_sc_reassign.get_active_business_procs', 'Getting list of active Business Processes');
100:
101: for each in active_bus_procs_cur loop
102: if nvl(length(l_business_proc_names),0) + nvl(length(each.name),0) + 2 < MAX_LENGTH then
103: l_business_proc_names := l_business_proc_names || each.name || ', ';

Line 107: zpb_log.write('zpb_sc_reassign.get_active_business_procs', 'End');

103: l_business_proc_names := l_business_proc_names || each.name || ', ';
104: end if;
105: end loop;
106:
107: zpb_log.write('zpb_sc_reassign.get_active_business_procs', 'End');
108:
109: return l_business_proc_names;
110:
111: END;

Line 143: zpb_log.write('zpb_sc_reassign.get_worksheets', 'Getting list of Worksheets');

139: l_worksheet_names varchar2(1000); -- name is varchar2(300).
140: -- s/b MAX_LENGTH
141:
142: BEGIN
143: zpb_log.write('zpb_sc_reassign.get_worksheets', 'Getting list of Worksheets');
144:
145: for each in worksheets_cur loop
146: if nvl(length(l_worksheet_names),0) + nvl(length(each.template_name),0) + 2 < MAX_LENGTH then
147: l_worksheet_names := l_worksheet_names || each.template_name || ', ';

Line 151: zpb_log.write('zpb_sc_reassign.zpb_sc_reassign.get_worksheets', 'End');

147: l_worksheet_names := l_worksheet_names || each.template_name || ', ';
148: end if;
149: end loop;
150:
151: zpb_log.write('zpb_sc_reassign.zpb_sc_reassign.get_worksheets', 'End');
152:
153: return l_worksheet_names;
154:
155: END;

Line 176: zpb_log.write('zpb_sc_reassign. reassign_exception_objs',

172: l_owner_user_name fnd_user.user_name%TYPE;
173:
174: BEGIN
175:
176: zpb_log.write('zpb_sc_reassign. reassign_exception_objs',
177: 'Reassigning Exception objects from user id: ' || p_owner_id ||
178: ' to user id: ' || p_new_owner_id);
179:
180: -- Some columns use text name.

Line 338: zpb_log.write('zpb_sc_reassign. reassign_exception_objs', 'End');

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);
337:
338: zpb_log.write('zpb_sc_reassign. reassign_exception_objs', 'End');
339:
340: END;
341:
342: END ZPB_SC_REASSIGN;

Line 342: END ZPB_SC_REASSIGN;

338: zpb_log.write('zpb_sc_reassign. reassign_exception_objs', 'End');
339:
340: END;
341:
342: END ZPB_SC_REASSIGN;