[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_relationships_pub;
42:
43: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
44:
43: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
44:
45: csi_utility_grp.check_ib_active;
46:
47: -- standard call TO check for call compatibility.
48: IF NOT fnd_api.compatible_api_call ( l_api_version,
49: p_api_version,
50: l_api_name,
51: g_pkg_name)
129: dbms_session.set_sql_trace(FALSE);
130: END IF;
131: ****/
132:
133: -- standard call TO get message count AND IF count is 1, get message info.
134: fnd_msg_pub.count_and_get
135: ( p_count => x_msg_count,
136: p_data => x_msg_data
137: );
200: l_relationship_exists VARCHAR2(1);
201: l_root_asset_id NUMBER;
202: -- End Add Code for Siebel Genesis Project
203: BEGIN
204: -- standard start of api savepoint
205: SAVEPOINT create_relationship_pub;
206:
207: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
208:
207: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
208:
209: csi_utility_grp.check_ib_active;
210:
211: -- standard call TO check for call compatibility.
212: IF NOT fnd_api.compatible_api_call ( l_api_version,
213: p_api_version,
214: l_api_name,
215: g_pkg_name)
470: --
471: -- END of api body.
472: --
473:
474: -- standard check for p_commit
475: IF fnd_api.to_boolean( p_commit )
476: THEN
477: COMMIT WORK;
478: END IF;
481: IF (l_flag = 'Y') THEN
482: dbms_session.set_sql_trace(FALSE);
483: END IF;
484: ****/
485: -- standard call TO get message count AND IF count is 1, get message info.
486: fnd_msg_pub.count_and_get
487: ( p_count => x_msg_count,
488: p_data => x_msg_data
489: );
545: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl:=p_relationship_tbl;
546: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl:=p_relationship_tbl;
547: l_replace_flag VARCHAR2(1);
548: BEGIN
549: -- standard start of api savepoint
550: SAVEPOINT update_relationship_pub;
551:
552: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
553:
552: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
553:
554: csi_utility_grp.check_ib_active;
555:
556: -- standard call TO check for call compatibility.
557: IF NOT fnd_api.compatible_api_call ( l_api_version,
558: p_api_version,
559: l_api_name,
560: g_pkg_name)
749: l_msg_count := l_msg_count - 1;
750: END LOOP;
751: RAISE FND_API.G_EXC_ERROR;
752: END IF;
753: -- standard check for p_commit
754: IF fnd_api.to_boolean( p_commit )
755: THEN
756: COMMIT WORK;
757: END IF;
760: IF (l_flag = 'Y') THEN
761: dbms_session.set_sql_trace(FALSE);
762: END IF;
763: ****/
764: -- standard call TO get message count AND IF count is 1, get message info.
765: fnd_msg_pub.count_and_get
766: ( p_count => x_msg_count,
767: p_data => x_msg_data
768: );
819: l_debug_level NUMBER;
820:
821:
822: BEGIN
823: -- standard start of api savepoint
824: SAVEPOINT expire_relationship_pub;
825:
826: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
827:
826: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
827:
828: csi_utility_grp.check_ib_active;
829:
830: -- standard call TO check for call compatibility.
831: IF NOT fnd_api.compatible_api_call ( l_api_version,
832: p_api_version,
833: l_api_name,
834: g_pkg_name)
901: END IF;
902:
903:
904:
905: -- standard check for p_commit
906: IF fnd_api.to_boolean( p_commit )
907: THEN
908: COMMIT WORK;
909: END IF;
912: IF (l_flag = 'Y') THEN
913: dbms_session.set_sql_trace(FALSE);
914: END IF;
915: *****/
916: -- standard call TO get message count AND IF count is 1, get message info.
917: fnd_msg_pub.count_and_get
918: ( p_count => x_msg_count,
919: p_data => x_msg_data
920: );