eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBC_ASSOCIATIONS_GRP dependencies on STANDARD

Line 31: -- local variable for standards **

27: x_return_status OUT NOCOPY VARCHAR2,
28: x_msg_count OUT NOCOPY NUMBER,
29: x_msg_data OUT NOCOPY VARCHAR2
30: ) AS
31: --******** local variable for standards **********
32: l_api_name CONSTANT VARCHAR2(30) := 'Create_Association';
33: l_api_version CONSTANT NUMBER := 1.0;
34: l_row_id VARCHAR2(250);
35: --

Line 51: -- * Standard Begins *

47: AND content_item_id = p_content_item_id
48: AND NVL(citem_version_id, '0') = NVL(p_citem_version_id, '0');
49:
50: BEGIN
51: -- ******************* Standard Begins *******************
52: -- Standard Start of API savepoint
53: SAVEPOINT CREATE_ASSOCIATIONS_PT;
54:
55: -- Standard call to check for call compatibility.

Line 52: -- Standard Start of API savepoint

48: AND NVL(citem_version_id, '0') = NVL(p_citem_version_id, '0');
49:
50: BEGIN
51: -- ******************* Standard Begins *******************
52: -- Standard Start of API savepoint
53: SAVEPOINT CREATE_ASSOCIATIONS_PT;
54:
55: -- Standard call to check for call compatibility.
56: IF NOT Fnd_Api.Compatible_API_Call (

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

51: -- ******************* Standard Begins *******************
52: -- Standard Start of API savepoint
53: SAVEPOINT CREATE_ASSOCIATIONS_PT;
54:
55: -- Standard call to check for call compatibility.
56: IF NOT Fnd_Api.Compatible_API_Call (
57: l_api_version,
58: p_api_version,
59: l_api_name,

Line 153: -- Standard check of p_commit.

149: ' citem version id: ' || p_citem_version_id
150: );
151:
152: --******************* Real Logic End *********************
153: -- Standard check of p_commit.
154: IF (Fnd_Api.To_Boolean(p_commit)) THEN
155: COMMIT WORK;
156: END IF;
157: -- Standard call to get message count and if count=1, get the message

Line 157: -- Standard call to get message count and if count=1, get the message

153: -- Standard check of p_commit.
154: IF (Fnd_Api.To_Boolean(p_commit)) THEN
155: COMMIT WORK;
156: END IF;
157: -- Standard call to get message count and if count=1, get the message
158: Fnd_Msg_Pub.Count_And_Get ( p_count => x_msg_count,
159: p_data => x_msg_data);
160: EXCEPTION
161: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 207: -- local variable for standards **

203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2
206: ) AS
207: --******** local variable for standards **********
208: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Association';
209: l_api_version CONSTANT NUMBER := 1.0;
210: l_row_id VARCHAR2(250);
211: --

Line 226: -- * Standard Begins *

222: AND NVL(associated_object_val5, '0') = NVL(p_assoc_object5, '0')
223: AND content_item_id = p_content_item_id;
224:
225: BEGIN
226: -- ******************* Standard Begins *******************
227: -- Standard Start of API savepoint
228: SAVEPOINT CREATE_ASSOCIATIONS_PT;
229:
230: -- Standard call to check for call compatibility.

Line 227: -- Standard Start of API savepoint

223: AND content_item_id = p_content_item_id;
224:
225: BEGIN
226: -- ******************* Standard Begins *******************
227: -- Standard Start of API savepoint
228: SAVEPOINT CREATE_ASSOCIATIONS_PT;
229:
230: -- Standard call to check for call compatibility.
231: IF NOT Fnd_Api.Compatible_API_Call (

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

226: -- ******************* Standard Begins *******************
227: -- Standard Start of API savepoint
228: SAVEPOINT CREATE_ASSOCIATIONS_PT;
229:
230: -- Standard call to check for call compatibility.
231: IF NOT Fnd_Api.Compatible_API_Call (
232: l_api_version,
233: p_api_version,
234: l_api_name,

Line 281: -- Standard check of p_commit.

277: ,p_description => 'Deleted association of type '|| p_assoc_type_code || ' and content item id ' || p_content_item_id
278: );
279:
280: --******************* Real Logic End *********************
281: -- Standard check of p_commit.
282: IF (Fnd_Api.To_Boolean(p_commit)) THEN
283: COMMIT WORK;
284: END IF;
285: -- Standard call to get message count and if count=1, get the message

Line 285: -- Standard call to get message count and if count=1, get the message

281: -- Standard check of p_commit.
282: IF (Fnd_Api.To_Boolean(p_commit)) THEN
283: COMMIT WORK;
284: END IF;
285: -- Standard call to get message count and if count=1, get the message
286: Fnd_Msg_Pub.Count_And_Get ( p_count => x_msg_count,
287: p_data => x_msg_data);
288: EXCEPTION
289: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 336: -- local variable for standards **

332: x_return_status OUT NOCOPY VARCHAR2,
333: x_msg_count OUT NOCOPY NUMBER,
334: x_msg_data OUT NOCOPY VARCHAR2
335: ) AS
336: --******** local variable for standards **********
337: l_api_name CONSTANT VARCHAR2(30) := 'Update_Association';
338: l_api_version CONSTANT NUMBER := 1.0;
339: l_row_id VARCHAR2(250);
340: --

Line 357: -- * Standard Begins *

353: AND NVL(associated_object_val5, '0') = NVL(p_assoc_object5, '0')
354: AND content_item_id = l_content_item_id;
355:
356: BEGIN
357: -- ******************* Standard Begins *******************
358: -- Standard Start of API savepoint
359: SAVEPOINT CREATE_ASSOCIATIONS_PT;
360:
361: -- Standard call to check for call compatibility.

Line 358: -- Standard Start of API savepoint

354: AND content_item_id = l_content_item_id;
355:
356: BEGIN
357: -- ******************* Standard Begins *******************
358: -- Standard Start of API savepoint
359: SAVEPOINT CREATE_ASSOCIATIONS_PT;
360:
361: -- Standard call to check for call compatibility.
362: IF NOT Fnd_Api.Compatible_API_Call (

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

357: -- ******************* Standard Begins *******************
358: -- Standard Start of API savepoint
359: SAVEPOINT CREATE_ASSOCIATIONS_PT;
360:
361: -- Standard call to check for call compatibility.
362: IF NOT Fnd_Api.Compatible_API_Call (
363: l_api_version,
364: p_api_version,
365: l_api_name,

Line 456: -- Standard check of p_commit.

452: ' new version id: ' || p_new_citem_ver_id
453: );
454:
455: --******************* Real Logic End *********************
456: -- Standard check of p_commit.
457: IF (Fnd_Api.To_Boolean(p_commit)) THEN
458: COMMIT WORK;
459: END IF;
460: -- Standard call to get message count and if count=1, get the message

Line 460: -- Standard call to get message count and if count=1, get the message

456: -- Standard check of p_commit.
457: IF (Fnd_Api.To_Boolean(p_commit)) THEN
458: COMMIT WORK;
459: END IF;
460: -- Standard call to get message count and if count=1, get the message
461: Fnd_Msg_Pub.Count_And_Get ( p_count => x_msg_count,
462: p_data => x_msg_data);
463: EXCEPTION
464: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 555: -- local variable for standards **

551: x_return_status OUT NOCOPY VARCHAR2,
552: x_msg_count OUT NOCOPY NUMBER,
553: x_msg_data OUT NOCOPY VARCHAR2
554: ) AS
555: --******** local variable for standards **********
556: l_api_name CONSTANT VARCHAR2(30) := 'Move_Associations';
557: l_api_version CONSTANT NUMBER := 1.0;
558:
559: l_temp_array_length NUMBER;

Line 609: -- * Standard Begins *

605: MINUS
606: SELECT association_type_code FROM IBC_ASSOCIATION_TYPES_B C;
607:
608: BEGIN
609: -- ******************* Standard Begins *******************
610: -- Standard Start of API savepoint
611: SAVEPOINT MOVE_ASSOCIATIONS_PT;
612:
613: -- Standard call to check for call compatibility.

Line 610: -- Standard Start of API savepoint

606: SELECT association_type_code FROM IBC_ASSOCIATION_TYPES_B C;
607:
608: BEGIN
609: -- ******************* Standard Begins *******************
610: -- Standard Start of API savepoint
611: SAVEPOINT MOVE_ASSOCIATIONS_PT;
612:
613: -- Standard call to check for call compatibility.
614: IF NOT Fnd_Api.Compatible_API_Call (

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

609: -- ******************* Standard Begins *******************
610: -- Standard Start of API savepoint
611: SAVEPOINT MOVE_ASSOCIATIONS_PT;
612:
613: -- Standard call to check for call compatibility.
614: IF NOT Fnd_Api.Compatible_API_Call (
615: l_api_version,
616: p_api_version,
617: l_api_name,

Line 876: -- Standard check of p_commit.

872: END;
873:
874:
875: --******************* Real Logic End *********************
876: -- Standard check of p_commit.
877: IF (Fnd_Api.To_Boolean(p_commit)) THEN
878: COMMIT WORK;
879: END IF;
880: -- Standard call to get message count and if count=1, get the message

Line 880: -- Standard call to get message count and if count=1, get the message

876: -- Standard check of p_commit.
877: IF (Fnd_Api.To_Boolean(p_commit)) THEN
878: COMMIT WORK;
879: END IF;
880: -- Standard call to get message count and if count=1, get the message
881: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
882: p_data => x_msg_data);
883: EXCEPTION
884: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 958: -- local variable for standards **

954: x_return_status OUT NOCOPY VARCHAR2,
955: x_msg_count OUT NOCOPY NUMBER,
956: x_msg_data OUT NOCOPY VARCHAR2
957: ) AS
958: --******** local variable for standards **********
959: l_api_name CONSTANT VARCHAR2(30) := 'Create_Associations';
960: l_api_version CONSTANT NUMBER := 1.0;
961: l_row_id VARCHAR2(250);
962: --

Line 977: -- * Standard Begins *

973: l_assoc_object4 VARCHAR2(254);
974: l_assoc_object5 VARCHAR2(254);
975:
976: BEGIN
977: -- ******************* Standard Begins *******************
978: -- Standard Start of API savepoint
979: SAVEPOINT CREATE_ASSOCIATIONS_PT;
980:
981: -- Standard call to check for call compatibility.

Line 978: -- Standard Start of API savepoint

974: l_assoc_object5 VARCHAR2(254);
975:
976: BEGIN
977: -- ******************* Standard Begins *******************
978: -- Standard Start of API savepoint
979: SAVEPOINT CREATE_ASSOCIATIONS_PT;
980:
981: -- Standard call to check for call compatibility.
982: IF NOT Fnd_Api.Compatible_API_Call (

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

977: -- ******************* Standard Begins *******************
978: -- Standard Start of API savepoint
979: SAVEPOINT CREATE_ASSOCIATIONS_PT;
980:
981: -- Standard call to check for call compatibility.
982: IF NOT Fnd_Api.Compatible_API_Call (
983: l_api_version,
984: p_api_version,
985: l_api_name,

Line 1107: -- Standard check of p_commit.

1103: l_count := l_count + 1;
1104: END LOOP;
1105:
1106: --******************* Real Logic End *********************
1107: -- Standard check of p_commit.
1108: IF (Fnd_Api.To_Boolean(p_commit)) THEN
1109: COMMIT WORK;
1110: END IF;
1111: -- Standard call to get message count and if count=1, get the message

Line 1111: -- Standard call to get message count and if count=1, get the message

1107: -- Standard check of p_commit.
1108: IF (Fnd_Api.To_Boolean(p_commit)) THEN
1109: COMMIT WORK;
1110: END IF;
1111: -- Standard call to get message count and if count=1, get the message
1112: Fnd_Msg_Pub.Count_And_Get ( p_count => x_msg_count,
1113: p_data => x_msg_data);
1114: EXCEPTION
1115: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1193: -- local variable for standards **

1189: x_return_status OUT NOCOPY VARCHAR2,
1190: x_msg_count OUT NOCOPY NUMBER,
1191: x_msg_data OUT NOCOPY VARCHAR2
1192: ) AS
1193: --******** local variable for standards **********
1194: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Associations';
1195: l_api_version CONSTANT NUMBER := 1.0;
1196: --
1197: l_temp_array_length NUMBER;

Line 1225: -- * Standard Begins *

1221: AND NVL(associated_object_val4, '0') = NVL(l_assoc_object4, '0')
1222: AND NVL(associated_object_val5, '0') = NVL(l_assoc_object5, '0');
1223:
1224: BEGIN
1225: -- ******************* Standard Begins *******************
1226: -- Standard Start of API savepoint
1227: SAVEPOINT DELETE_ASSOCIATIONS_PT;
1228:
1229: -- Standard call to check for call compatibility.

Line 1226: -- Standard Start of API savepoint

1222: AND NVL(associated_object_val5, '0') = NVL(l_assoc_object5, '0');
1223:
1224: BEGIN
1225: -- ******************* Standard Begins *******************
1226: -- Standard Start of API savepoint
1227: SAVEPOINT DELETE_ASSOCIATIONS_PT;
1228:
1229: -- Standard call to check for call compatibility.
1230: IF NOT Fnd_Api.Compatible_API_Call (

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

1225: -- ******************* Standard Begins *******************
1226: -- Standard Start of API savepoint
1227: SAVEPOINT DELETE_ASSOCIATIONS_PT;
1228:
1229: -- Standard call to check for call compatibility.
1230: IF NOT Fnd_Api.Compatible_API_Call (
1231: l_api_version,
1232: p_api_version,
1233: l_api_name,

Line 1322: -- Standard check of p_commit.

1318: l_count := l_count + 1;
1319: END LOOP;
1320:
1321: --******************* Real Logic End *********************
1322: -- Standard check of p_commit.
1323: IF (Fnd_Api.To_Boolean(p_commit)) THEN
1324: COMMIT WORK;
1325: END IF;
1326: -- Standard call to get message count and if count=1, get the message

Line 1326: -- Standard call to get message count and if count=1, get the message

1322: -- Standard check of p_commit.
1323: IF (Fnd_Api.To_Boolean(p_commit)) THEN
1324: COMMIT WORK;
1325: END IF;
1326: -- Standard call to get message count and if count=1, get the message
1327: Fnd_Msg_Pub.Count_And_Get ( p_count => x_msg_count,
1328: p_data => x_msg_data);
1329: EXCEPTION
1330: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1426: -- local variable for standards **

1422: x_return_status OUT NOCOPY VARCHAR2,
1423: x_msg_count OUT NOCOPY NUMBER,
1424: x_msg_data OUT NOCOPY VARCHAR2
1425: ) AS
1426: --******** local variable for standards **********
1427: l_api_name CONSTANT VARCHAR2(30) := 'Get_Associations';
1428: l_api_version CONSTANT NUMBER := 1.0;
1429: --
1430: pre_plsql_block VARCHAR2(10) := 'BEGIN ';

Line 1460: -- * Standard Begins *

1456: FROM IBC_ASSOCIATION_TYPES_B
1457: WHERE ASSOCIATION_TYPE_CODE = l_assoc_type_code;
1458:
1459: BEGIN
1460: -- ******************* Standard Begins *******************
1461: -- Standard call to check for call compatibility.
1462: IF NOT Fnd_Api.Compatible_API_Call (
1463: l_api_version,
1464: p_api_version,

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

1457: WHERE ASSOCIATION_TYPE_CODE = l_assoc_type_code;
1458:
1459: BEGIN
1460: -- ******************* Standard Begins *******************
1461: -- Standard call to check for call compatibility.
1462: IF NOT Fnd_Api.Compatible_API_Call (
1463: l_api_version,
1464: p_api_version,
1465: l_api_name,

Line 1651: -- Standard call to get message count and if count=1, get the message

1647: END IF;
1648:
1649: --******************* Real Logic End *********************
1650:
1651: -- Standard call to get message count and if count=1, get the message
1652: Fnd_Msg_Pub.Count_And_Get ( p_count => x_msg_count,
1653: p_data => x_msg_data);
1654: EXCEPTION
1655: WHEN Fnd_Api.G_EXC_ERROR THEN