51: AND org_id = x_org_id;
52:
53:
54: BEGIN
55: -- Standard Start of API savepoint
56: SAVEPOINT Create_Map;
57: -- Standard call to check for call compatibility.
58: IF NOT FND_API.Compatible_API_Call (l_api_version,
59: p_api_version,
53:
54: BEGIN
55: -- Standard Start of API savepoint
56: SAVEPOINT Create_Map;
57: -- Standard call to check for call compatibility.
58: IF NOT FND_API.Compatible_API_Call (l_api_version,
59: p_api_version,
60: l_api_name,
61: G_PKG_NAME)
62: THEN
63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
64: END IF;
65:
66: -- Standard Check For Create Operations to validate the
67: -- ORG_ID by calling the common validation utility.
68:
69:
70: l_org_id := MO_GLOBAL.get_valid_org(p_table_map_rec.org_id);
293:
294: ------------------+
295: -- End of API body.
296: ------------------+
297: -- Standard check of p_commit.
298: --IF FND_API.To_Boolean( p_commit ) THEN
299: -- COMMIT WORK;
300: --END IF;
301: -- Standard call to get message count and if count is 1, get message info.
297: -- Standard check of p_commit.
298: --IF FND_API.To_Boolean( p_commit ) THEN
299: -- COMMIT WORK;
300: --END IF;
301: -- Standard call to get message count and if count is 1, get message info.
302: FND_MSG_PUB.Count_And_Get
303: (p_count => x_msg_count ,
304: p_data => x_msg_data ,
305: p_encoded => FND_API.G_FALSE);
467: AND name = 'cn_collect_'||LOWER(p_mapping_type)||p_org_append
468: AND org_id = p_org_id; -- Added For MOAC
469:
470: BEGIN
471: -- Standard Start of API savepoint
472: SAVEPOINT Delete_Map;
473: -- Standard call to check for call compatibility.
474: IF NOT FND_API.Compatible_API_Call (l_api_version,
475: p_api_version,
469:
470: BEGIN
471: -- Standard Start of API savepoint
472: SAVEPOINT Delete_Map;
473: -- Standard call to check for call compatibility.
474: IF NOT FND_API.Compatible_API_Call (l_api_version,
475: p_api_version,
476: l_api_name,
477: G_PKG_NAME)
583: END LOOP;
584: -------------------+
585: -- End of API body.
586: -------------------+
587: -- Standard check of p_commit.
588: --IF FND_API.To_Boolean( p_commit ) THEN
589: -- COMMIT WORK;
590: --END IF;
591: -- Standard call to get message count and if count is 1, get message info.
587: -- Standard check of p_commit.
588: --IF FND_API.To_Boolean( p_commit ) THEN
589: -- COMMIT WORK;
590: --END IF;
591: -- Standard call to get message count and if count is 1, get message info.
592: FND_MSG_PUB.Count_And_Get
593: (p_count => x_msg_count ,
594: p_data => x_msg_data ,
595: p_encoded => FND_API.G_FALSE);
665: WHERE table_map_id = p_table_map_id
666: AND org_id = x_org_id; -- Added For R12 MOAC
667:
668: BEGIN
669: -- Standard Start of API savepoint
670: SAVEPOINT update_trx_source_sv;
671: -- Standard call to check for call compatibility.
672: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
673: p_api_version ,
667:
668: BEGIN
669: -- Standard Start of API savepoint
670: SAVEPOINT update_trx_source_sv;
671: -- Standard call to check for call compatibility.
672: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
673: p_api_version ,
674: l_api_name,
675: G_PKG_NAME ) THEN
800: AND org_id = x_org_id; -- Added For R12 MOAC
801:
802:
803: BEGIN
804: -- Standard Start of API savepoint
805: SAVEPOINT update_trx_source_sv;
806: -- Standard call to check for call compatibility.
807: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
808: p_api_version ,
802:
803: BEGIN
804: -- Standard Start of API savepoint
805: SAVEPOINT update_trx_source_sv;
806: -- Standard call to check for call compatibility.
807: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
808: p_api_version ,
809: l_api_name,
810: G_PKG_NAME ) THEN
873:
874: p_object_version_number := l_object_version_number + 1;
875:
876: -- End of API body.
877: -- Standard check of p_commit.
878: --IF FND_API.To_Boolean( p_commit ) THEN
879: -- COMMIT WORK;
880: --END IF;
881: -- Standard call to get message count and if count is 1, get message info.
877: -- Standard check of p_commit.
878: --IF FND_API.To_Boolean( p_commit ) THEN
879: -- COMMIT WORK;
880: --END IF;
881: -- Standard call to get message count and if count is 1, get message info.
882: FND_MSG_PUB.Count_And_Get
883: (p_count => x_msg_count ,
884: p_data => x_msg_data ,
885: p_encoded => FND_API.G_FALSE );
944: l_rowid ROWID;
945: l_application_repository_id cn_events.application_repository_id%TYPE;
946: l_org_id NUMBER;
947: BEGIN
948: -- Standard Start of API savepoint
949: SAVEPOINT Create_Table_Map_Object;
950: -- Standard call to check for call compatibility.
951: IF NOT FND_API.Compatible_API_Call (l_api_version,
952: p_api_version,
946: l_org_id NUMBER;
947: BEGIN
948: -- Standard Start of API savepoint
949: SAVEPOINT Create_Table_Map_Object;
950: -- Standard call to check for call compatibility.
951: IF NOT FND_API.Compatible_API_Call (l_api_version,
952: p_api_version,
953: l_api_name,
954: G_PKG_NAME)
1009: X_org_id => l_org_id);
1010: -------------------+
1011: -- End of API body.
1012: -------------------+
1013: -- Standard check of p_commit.
1014: --IF FND_API.To_Boolean( p_commit ) THEN
1015: -- COMMIT WORK;
1016: --END IF;
1017: -- Standard call to get message count and if count is 1, get message info.
1013: -- Standard check of p_commit.
1014: --IF FND_API.To_Boolean( p_commit ) THEN
1015: -- COMMIT WORK;
1016: --END IF;
1017: -- Standard call to get message count and if count is 1, get message info.
1018: FND_MSG_PUB.Count_And_Get
1019: (p_count => x_msg_count ,
1020: p_data => x_msg_data ,
1021: p_encoded => FND_API.G_FALSE);
1079: WHERE table_map_object_id = p_table_map_object_id
1080: AND org_id = x_org_id;
1081:
1082: BEGIN
1083: -- Standard Start of API savepoint
1084: SAVEPOINT Delete_Table_Map_Object;
1085: -- Standard call to check for call compatibility.
1086: IF NOT FND_API.Compatible_API_Call (l_api_version,
1087: p_api_version,
1081:
1082: BEGIN
1083: -- Standard Start of API savepoint
1084: SAVEPOINT Delete_Table_Map_Object;
1085: -- Standard call to check for call compatibility.
1086: IF NOT FND_API.Compatible_API_Call (l_api_version,
1087: p_api_version,
1088: l_api_name,
1089: G_PKG_NAME)
1114: x_org_id => x_org_id); -- Added For R12 MOAC
1115: -------------------+
1116: -- End of API body.
1117: -------------------+
1118: -- Standard check of p_commit.
1119: --IF FND_API.To_Boolean( p_commit ) THEN
1120: -- COMMIT WORK;
1121: --END IF;
1122: -- Standard call to get message count and if count is 1, get message info.
1118: -- Standard check of p_commit.
1119: --IF FND_API.To_Boolean( p_commit ) THEN
1120: -- COMMIT WORK;
1121: --END IF;
1122: -- Standard call to get message count and if count is 1, get message info.
1123: FND_MSG_PUB.Count_And_Get
1124: (p_count => x_msg_count ,
1125: p_data => x_msg_data ,
1126: p_encoded => FND_API.G_FALSE);
1192: AND tmv.org_id = p_org_id;
1193: l_c1_rec c1%ROWTYPE;
1194:
1195: BEGIN
1196: -- Standard Start of API savepoint
1197: SAVEPOINT Get_SQL_Clauses;
1198: -- Standard call to check for call compatibility.
1199: IF NOT FND_API.Compatible_API_Call (l_api_version,
1200: p_api_version,
1194:
1195: BEGIN
1196: -- Standard Start of API savepoint
1197: SAVEPOINT Get_SQL_Clauses;
1198: -- Standard call to check for call compatibility.
1199: IF NOT FND_API.Compatible_API_Call (l_api_version,
1200: p_api_version,
1201: l_api_name,
1202: G_PKG_NAME)
1281: END IF;
1282: -------------------+
1283: -- End of API body.
1284: -------------------+
1285: -- Standard check of p_commit.
1286: IF FND_API.To_Boolean( p_commit ) THEN
1287: COMMIT WORK;
1288: END IF;
1289: -- Standard call to get message count and if count is 1, get message info.
1285: -- Standard check of p_commit.
1286: IF FND_API.To_Boolean( p_commit ) THEN
1287: COMMIT WORK;
1288: END IF;
1289: -- Standard call to get message count and if count is 1, get message info.
1290: FND_MSG_PUB.Count_And_Get
1291: (p_count => x_msg_count ,
1292: p_data => x_msg_data ,
1293: p_encoded => FND_API.G_FALSE);