DBA Data[Home] [Help]

APPS.CN_TABLE_MAPS_PVT dependencies on STANDARD

Line 55: -- Standard Start of API savepoint

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,

Line 57: -- Standard call to check for call compatibility.

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)

Line 66: -- Standard Check For Create Operations to validate the

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);

Line 297: -- Standard check of p_commit.

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.

Line 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);

Line 471: -- Standard Start of API savepoint

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,

Line 473: -- Standard call to check for call compatibility.

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)

Line 587: -- Standard check of p_commit.

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.

Line 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);

Line 669: -- Standard Start of API savepoint

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 ,

Line 671: -- Standard call to check for call compatibility.

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

Line 804: -- Standard Start of API savepoint

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 ,

Line 806: -- Standard call to check for call compatibility.

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

Line 877: -- Standard check of p_commit.

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.

Line 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 );

Line 948: -- Standard Start of API savepoint

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,

Line 950: -- Standard call to check for call compatibility.

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)

Line 1013: -- Standard check of p_commit.

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.

Line 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);

Line 1083: -- Standard Start of API savepoint

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,

Line 1085: -- Standard call to check for call compatibility.

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)

Line 1118: -- Standard check of p_commit.

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.

Line 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);

Line 1196: -- Standard Start of API savepoint

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,

Line 1198: -- Standard call to check for call compatibility.

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)

Line 1285: -- Standard check of p_commit.

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.

Line 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);