[Home] [Help]
36: l_flag VARCHAR2(1) :='N';
37: l_debug_level NUMBER;
38:
39: BEGIN
40: -- standard start of api savepoint
41: --SAVEPOINT get_systems_pub;
42:
43: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
44:
44:
45: csi_utility_grp.check_ib_active;
46:
47:
48: -- standard call to check for call compatibility.
49: IF NOT fnd_api.compatible_api_call ( l_api_version,
50: p_api_version,
51: l_api_name,
52: g_pkg_name)
128: dbms_session.set_sql_trace(false);
129: END IF;
130: ****/
131:
132: -- standard call to get message count and if count is 1, get message info.
133: fnd_msg_pub.count_and_get
134: ( p_count => x_msg_count,
135: p_data => x_msg_data
136: );
188: l_debug_level NUMBER;
189:
190:
191: BEGIN
192: -- standard start of api savepoint
193: SAVEPOINT create_system_pub;
194:
195: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
196:
196:
197: csi_utility_grp.check_ib_active;
198:
199:
200: -- standard call to check for call compatibility.
201: IF NOT fnd_api.compatible_api_call ( l_api_version,
202: p_api_version,
203: l_api_name,
204: g_pkg_name)
275: --
276: -- end of api body.
277: --
278:
279: -- standard check for p_commit
280: IF fnd_api.to_boolean( p_commit )
281: THEN
282: COMMIT WORK;
283: END IF;
287: dbms_session.set_sql_trace(false);
288: END IF;
289: ****/
290:
291: -- standard call to get message count and if count is 1, get message info.
292: fnd_msg_pub.count_and_get
293: ( p_count => x_msg_count,
294: p_data => x_msg_data
295: );
395: l_child_sys_details_rec CHILD_SYSTEMS_DETAILS_CUR%ROWTYPE;
396: l_child_sys_tl_rec SYS_TL_CSR%ROWTYPE;
397:
398: BEGIN
399: -- standard start of api savepoint
400: SAVEPOINT update_system_pub;
401:
402: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
403:
403:
404: csi_utility_grp.check_ib_active;
405:
406:
407: -- standard call to check for call compatibility.
408: IF NOT fnd_api.compatible_api_call ( l_api_version,
409: p_api_version,
410: l_api_name,
411: g_pkg_name)
653: --
654: -- end of api body
655: --
656:
657: -- standard check for p_commit
658: IF fnd_api.to_boolean( p_commit )
659: THEN
660: COMMIT WORK;
661: END IF;
665: dbms_session.set_sql_trace(false);
666: END IF;
667: ****/
668:
669: -- standard call to get message count and if count is 1, get message info.
670: fnd_msg_pub.count_and_get
671: ( p_count => x_msg_count,
672: p_data => x_msg_data
673: );
723: l_debug_level NUMBER;
724:
725:
726: BEGIN
727: -- standard start of api savepoint
728: SAVEPOINT expire_system_pub;
729:
730: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
731:
731:
732: csi_utility_grp.check_ib_active;
733:
734:
735: -- standard call to check for call compatibility.
736: IF NOT fnd_api.compatible_api_call ( l_api_version,
737: p_api_version,
738: l_api_name,
739: g_pkg_name)
810: --
811: -- end of api body
812: --
813:
814: -- standard check for p_commit
815: IF fnd_api.to_boolean( p_commit )
816: THEN
817: COMMIT WORK;
818: END IF;
822: dbms_session.set_sql_trace(false);
823: END IF;
824: ****/
825:
826: -- standard call to get message count and if count is 1, get message info.
827: fnd_msg_pub.count_and_get
828: ( p_count => x_msg_count,
829: p_data => x_msg_data
830: );