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 867: -- Standard check of p_commit.

863: END;
864:
865:
866: --******************* Real Logic End *********************
867: -- Standard check of p_commit.
868: IF (Fnd_Api.To_Boolean(p_commit)) THEN
869: COMMIT WORK;
870: END IF;
871: -- Standard call to get message count and if count=1, get the message

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

867: -- Standard check of p_commit.
868: IF (Fnd_Api.To_Boolean(p_commit)) THEN
869: COMMIT WORK;
870: END IF;
871: -- Standard call to get message count and if count=1, get the message
872: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
873: p_data => x_msg_data);
874: EXCEPTION
875: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 949: -- local variable for standards **

945: x_return_status OUT NOCOPY VARCHAR2,
946: x_msg_count OUT NOCOPY NUMBER,
947: x_msg_data OUT NOCOPY VARCHAR2
948: ) AS
949: --******** local variable for standards **********
950: l_api_name CONSTANT VARCHAR2(30) := 'Create_Associations';
951: l_api_version CONSTANT NUMBER := 1.0;
952: l_row_id VARCHAR2(250);
953: --

Line 979: -- * Standard Begins *

975: l_citem_version_ids JTF_NUMBER_TABLE;
976: --Start:Added for Bug#10409046 Fix
977:
978: BEGIN
979: -- ******************* Standard Begins *******************
980: -- Standard Start of API savepoint
981: SAVEPOINT CREATE_ASSOCIATIONS_PT;
982:
983: -- Standard call to check for call compatibility.

Line 980: -- Standard Start of API savepoint

976: --Start:Added for Bug#10409046 Fix
977:
978: BEGIN
979: -- ******************* Standard Begins *******************
980: -- Standard Start of API savepoint
981: SAVEPOINT CREATE_ASSOCIATIONS_PT;
982:
983: -- Standard call to check for call compatibility.
984: IF NOT Fnd_Api.Compatible_API_Call (

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

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

Line 1129: -- Standard check of p_commit.

1125: l_count := l_count + 1;
1126: END LOOP;
1127:
1128: --******************* Real Logic End *********************
1129: -- Standard check of p_commit.
1130: IF (Fnd_Api.To_Boolean(p_commit)) THEN
1131: COMMIT WORK;
1132: END IF;
1133: -- Standard call to get message count and if count=1, get the message

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

1129: -- Standard check of p_commit.
1130: IF (Fnd_Api.To_Boolean(p_commit)) THEN
1131: COMMIT WORK;
1132: END IF;
1133: -- Standard call to get message count and if count=1, get the message
1134: Fnd_Msg_Pub.Count_And_Get ( p_count => x_msg_count,
1135: p_data => x_msg_data);
1136: EXCEPTION
1137: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1215: -- local variable for standards **

1211: x_return_status OUT NOCOPY VARCHAR2,
1212: x_msg_count OUT NOCOPY NUMBER,
1213: x_msg_data OUT NOCOPY VARCHAR2
1214: ) AS
1215: --******** local variable for standards **********
1216: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Associations';
1217: l_api_version CONSTANT NUMBER := 1.0;
1218: --
1219: l_temp_array_length NUMBER;

Line 1245: -- * Standard Begins *

1241: AND NVL(associated_object_val4, '0') = NVL(l_assoc_object4, '0')
1242: AND NVL(associated_object_val5, '0') = NVL(l_assoc_object5, '0');
1243:
1244: BEGIN
1245: -- ******************* Standard Begins *******************
1246: -- Standard Start of API savepoint
1247: SAVEPOINT DELETE_ASSOCIATIONS_PT;
1248:
1249: -- Standard call to check for call compatibility.

Line 1246: -- Standard Start of API savepoint

1242: AND NVL(associated_object_val5, '0') = NVL(l_assoc_object5, '0');
1243:
1244: BEGIN
1245: -- ******************* Standard Begins *******************
1246: -- Standard Start of API savepoint
1247: SAVEPOINT DELETE_ASSOCIATIONS_PT;
1248:
1249: -- Standard call to check for call compatibility.
1250: IF NOT Fnd_Api.Compatible_API_Call (

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

1245: -- ******************* Standard Begins *******************
1246: -- Standard Start of API savepoint
1247: SAVEPOINT DELETE_ASSOCIATIONS_PT;
1248:
1249: -- Standard call to check for call compatibility.
1250: IF NOT Fnd_Api.Compatible_API_Call (
1251: l_api_version,
1252: p_api_version,
1253: l_api_name,

Line 1342: -- Standard check of p_commit.

1338: l_count := l_count + 1;
1339: END LOOP;
1340:
1341: --******************* Real Logic End *********************
1342: -- Standard check of p_commit.
1343: IF (Fnd_Api.To_Boolean(p_commit)) THEN
1344: COMMIT WORK;
1345: END IF;
1346: -- Standard call to get message count and if count=1, get the message

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

1342: -- Standard check of p_commit.
1343: IF (Fnd_Api.To_Boolean(p_commit)) THEN
1344: COMMIT WORK;
1345: END IF;
1346: -- Standard call to get message count and if count=1, get the message
1347: Fnd_Msg_Pub.Count_And_Get ( p_count => x_msg_count,
1348: p_data => x_msg_data);
1349: EXCEPTION
1350: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1446: -- local variable for standards **

1442: x_return_status OUT NOCOPY VARCHAR2,
1443: x_msg_count OUT NOCOPY NUMBER,
1444: x_msg_data OUT NOCOPY VARCHAR2
1445: ) AS
1446: --******** local variable for standards **********
1447: l_api_name CONSTANT VARCHAR2(30) := 'Get_Associations';
1448: l_api_version CONSTANT NUMBER := 1.0;
1449: --
1450: pre_plsql_block VARCHAR2(10) := 'BEGIN ';

Line 1478: -- * Standard Begins *

1474: FROM IBC_ASSOCIATION_TYPES_B
1475: WHERE ASSOCIATION_TYPE_CODE = l_assoc_type_code;
1476:
1477: BEGIN
1478: -- ******************* Standard Begins *******************
1479: -- Standard call to check for call compatibility.
1480: IF NOT Fnd_Api.Compatible_API_Call (
1481: l_api_version,
1482: p_api_version,

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

1475: WHERE ASSOCIATION_TYPE_CODE = l_assoc_type_code;
1476:
1477: BEGIN
1478: -- ******************* Standard Begins *******************
1479: -- Standard call to check for call compatibility.
1480: IF NOT Fnd_Api.Compatible_API_Call (
1481: l_api_version,
1482: p_api_version,
1483: l_api_name,

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

1665: END IF;
1666:
1667: --******************* Real Logic End *********************
1668:
1669: -- Standard call to get message count and if count=1, get the message
1670: Fnd_Msg_Pub.Count_And_Get ( p_count => x_msg_count,
1671: p_data => x_msg_data);
1672: EXCEPTION
1673: WHEN Fnd_Api.G_EXC_ERROR THEN