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.CN_DIM_HIERARCHIES_PVT dependencies on STANDARD

Line 32: -- Standard Start of API savepoint

28: l_count NUMBER;
29: l_count_tl NUMBER;
30:
31: BEGIN
32: -- Standard Start of API savepoint
33: SAVEPOINT Create_Hierarchy_Type;
34: -- Standard call to check for call compatibility.
35: IF NOT FND_API.Compatible_API_Call
36: (l_api_version ,

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

30:
31: BEGIN
32: -- Standard Start of API savepoint
33: SAVEPOINT Create_Hierarchy_Type;
34: -- Standard call to check for call compatibility.
35: IF NOT FND_API.Compatible_API_Call
36: (l_api_version ,
37: p_api_version ,
38: l_api_name ,

Line 103: -- Standard check of p_commit.

99: --R12 MOAC Changes--End
100:
101: -- End of API body.
102:
103: -- Standard check of p_commit.
104: IF FND_API.To_Boolean( p_commit ) THEN
105: COMMIT WORK;
106: END IF;
107: -- Standard call to get message count and if count is 1, get message info.

Line 107: -- Standard call to get message count and if count is 1, get message info.

103: -- Standard check of p_commit.
104: IF FND_API.To_Boolean( p_commit ) THEN
105: COMMIT WORK;
106: END IF;
107: -- Standard call to get message count and if count is 1, get message info.
108: FND_MSG_PUB.Count_And_Get
109: (p_count => x_msg_count ,
110: p_data => x_msg_data ,
111: p_encoded => FND_API.G_FALSE );

Line 171: -- Standard Start of API savepoint

167: and org_id = p_org_id; --R12 MOAC changes
168:
169: tlinfo c%rowtype ;
170: BEGIN
171: -- Standard Start of API savepoint
172: SAVEPOINT Update_Hierarchy_Type;
173: -- Standard call to check for call compatibility.
174: IF NOT FND_API.Compatible_API_Call
175: (l_api_version ,

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

169: tlinfo c%rowtype ;
170: BEGIN
171: -- Standard Start of API savepoint
172: SAVEPOINT Update_Hierarchy_Type;
173: -- Standard call to check for call compatibility.
174: IF NOT FND_API.Compatible_API_Call
175: (l_api_version ,
176: p_api_version ,
177: l_api_name ,

Line 240: -- Standard check of p_commit.

236:
237:
238: -- End of API body.
239:
240: -- Standard check of p_commit.
241: IF FND_API.To_Boolean( p_commit ) THEN
242: COMMIT WORK;
243: END IF;
244: -- Standard call to get message count and if count is 1, get message info.

Line 244: -- Standard call to get message count and if count is 1, get message info.

240: -- Standard check of p_commit.
241: IF FND_API.To_Boolean( p_commit ) THEN
242: COMMIT WORK;
243: END IF;
244: -- Standard call to get message count and if count is 1, get message info.
245: FND_MSG_PUB.Count_And_Get
246: (p_count => x_msg_count ,
247: p_data => x_msg_data ,
248: p_encoded => FND_API.G_FALSE );

Line 298: -- Standard Start of API savepoint

294: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Hierarchy_Type';
295: l_api_version CONSTANT NUMBER := 1.0;
296:
297: BEGIN
298: -- Standard Start of API savepoint
299: SAVEPOINT Delete_Hierarchy_Type;
300: -- Standard call to check for call compatibility.
301: IF NOT FND_API.Compatible_API_Call
302: (l_api_version ,

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

296:
297: BEGIN
298: -- Standard Start of API savepoint
299: SAVEPOINT Delete_Hierarchy_Type;
300: -- Standard call to check for call compatibility.
301: IF NOT FND_API.Compatible_API_Call
302: (l_api_version ,
303: p_api_version ,
304: l_api_name ,

Line 326: -- Standard check of p_commit.

322: --R12 MOAC Changes--End
323:
324: -- End of API body.
325:
326: -- Standard check of p_commit.
327: IF FND_API.To_Boolean( p_commit ) THEN
328: COMMIT WORK;
329: END IF;
330: -- Standard call to get message count and if count is 1, get message info.

Line 330: -- Standard call to get message count and if count is 1, get message info.

326: -- Standard check of p_commit.
327: IF FND_API.To_Boolean( p_commit ) THEN
328: COMMIT WORK;
329: END IF;
330: -- Standard call to get message count and if count is 1, get message info.
331: FND_MSG_PUB.Count_And_Get
332: (p_count => x_msg_count ,
333: p_data => x_msg_data ,
334: p_encoded => FND_API.G_FALSE );

Line 388: -- Standard Start of API savepoint

384: l_rowid ROWID;
385: l_count NUMBER;
386:
387: BEGIN
388: -- Standard Start of API savepoint
389: SAVEPOINT Create_Head_Hierarchy;
390: -- Standard call to check for call compatibility.
391: IF NOT FND_API.Compatible_API_Call
392: (l_api_version ,

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

386:
387: BEGIN
388: -- Standard Start of API savepoint
389: SAVEPOINT Create_Head_Hierarchy;
390: -- Standard call to check for call compatibility.
391: IF NOT FND_API.Compatible_API_Call
392: (l_api_version ,
393: p_api_version ,
394: l_api_name ,

Line 440: -- Standard check of p_commit.

436: --R12 MOAC Changes--End
437:
438: -- End of API body.
439:
440: -- Standard check of p_commit.
441: IF FND_API.To_Boolean( p_commit ) THEN
442: COMMIT WORK;
443: END IF;
444: -- Standard call to get message count and if count is 1, get message info.

Line 444: -- Standard call to get message count and if count is 1, get message info.

440: -- Standard check of p_commit.
441: IF FND_API.To_Boolean( p_commit ) THEN
442: COMMIT WORK;
443: END IF;
444: -- Standard call to get message count and if count is 1, get message info.
445: FND_MSG_PUB.Count_And_Get
446: (p_count => x_msg_count ,
447: p_data => x_msg_data ,
448: p_encoded => FND_API.G_FALSE );

Line 510: -- Standard Start of API savepoint

506: --R12 MOAC Changes--End
507:
508: tlinfo c%rowtype ;
509: BEGIN
510: -- Standard Start of API savepoint
511: SAVEPOINT Update_Head_Hierarchy;
512: -- Standard call to check for call compatibility.
513: IF NOT FND_API.Compatible_API_Call
514: (l_api_version ,

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

508: tlinfo c%rowtype ;
509: BEGIN
510: -- Standard Start of API savepoint
511: SAVEPOINT Update_Head_Hierarchy;
512: -- Standard call to check for call compatibility.
513: IF NOT FND_API.Compatible_API_Call
514: (l_api_version ,
515: p_api_version ,
516: l_api_name ,

Line 578: -- Standard check of p_commit.

574: --R12 MOAC Changes--End
575:
576: -- End of API body.
577:
578: -- Standard check of p_commit.
579:
580: IF FND_API.To_Boolean( p_commit ) THEN
581: COMMIT WORK;
582: END IF;

Line 583: -- Standard call to get message count and if count is 1, get message info.

579:
580: IF FND_API.To_Boolean( p_commit ) THEN
581: COMMIT WORK;
582: END IF;
583: -- Standard call to get message count and if count is 1, get message info.
584: FND_MSG_PUB.Count_And_Get
585: (p_count => x_msg_count ,
586: p_data => x_msg_data ,
587: p_encoded => FND_API.G_FALSE );

Line 637: -- Standard Start of API savepoint

633: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Head_Hierarchy';
634: l_api_version CONSTANT NUMBER := 1.0;
635:
636: BEGIN
637: -- Standard Start of API savepoint
638: SAVEPOINT Delete_Head_Hierarchy;
639: -- Standard call to check for call compatibility.
640: IF NOT FND_API.Compatible_API_Call
641: (l_api_version ,

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

635:
636: BEGIN
637: -- Standard Start of API savepoint
638: SAVEPOINT Delete_Head_Hierarchy;
639: -- Standard call to check for call compatibility.
640: IF NOT FND_API.Compatible_API_Call
641: (l_api_version ,
642: p_api_version ,
643: l_api_name ,

Line 663: -- Standard check of p_commit.

659: p_org_id);
660: --R12 MOAC Changes--End
661: -- End of API body.
662:
663: -- Standard check of p_commit.
664: IF FND_API.To_Boolean( p_commit ) THEN
665: COMMIT WORK;
666: END IF;
667: -- Standard call to get message count and if count is 1, get message info.

Line 667: -- Standard call to get message count and if count is 1, get message info.

663: -- Standard check of p_commit.
664: IF FND_API.To_Boolean( p_commit ) THEN
665: COMMIT WORK;
666: END IF;
667: -- Standard call to get message count and if count is 1, get message info.
668: FND_MSG_PUB.Count_And_Get
669: (p_count => x_msg_count ,
670: p_data => x_msg_data ,
671: p_encoded => FND_API.G_FALSE );

Line 746: -- Standard Start of API savepoint

742: l_name CN_HIERARCHY_NODES.NAME%TYPE;
743: x_root_node CN_DIM_HIERARCHIES.ROOT_NODE%TYPE;
744:
745: BEGIN
746: -- Standard Start of API savepoint
747: SAVEPOINT Create_Dim_Hierarchy;
748: -- Standard call to check for call compatibility.
749: IF NOT FND_API.Compatible_API_Call
750: (l_api_version ,

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

744:
745: BEGIN
746: -- Standard Start of API savepoint
747: SAVEPOINT Create_Dim_Hierarchy;
748: -- Standard call to check for call compatibility.
749: IF NOT FND_API.Compatible_API_Call
750: (l_api_version ,
751: p_api_version ,
752: l_api_name ,

Line 819: -- Standard check of p_commit.

815: END IF;
816:
817: -- End of API body.
818:
819: -- Standard check of p_commit.
820: IF FND_API.To_Boolean( p_commit ) THEN
821: COMMIT WORK;
822: END IF;
823: -- Standard call to get message count and if count is 1, get message info.

Line 823: -- Standard call to get message count and if count is 1, get message info.

819: -- Standard check of p_commit.
820: IF FND_API.To_Boolean( p_commit ) THEN
821: COMMIT WORK;
822: END IF;
823: -- Standard call to get message count and if count is 1, get message info.
824: FND_MSG_PUB.Count_And_Get
825: (p_count => x_msg_count ,
826: p_data => x_msg_data ,
827: p_encoded => FND_API.G_FALSE );

Line 884: -- Standard Start of API savepoint

880: l_root_node CN_DIM_HIERARCHIES.ROOT_NODE%TYPE;
881: l_old_start_date CN_DIM_HIERARCHIES.START_DATE%TYPE;
882: l_old_end_date CN_DIM_HIERARCHIES.END_DATE%TYPE;
883: BEGIN
884: -- Standard Start of API savepoint
885: SAVEPOINT Update_Dim_Hierarchy;
886: -- Standard call to check for call compatibility.
887: IF NOT FND_API.Compatible_API_Call
888: (l_api_version ,

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

882: l_old_end_date CN_DIM_HIERARCHIES.END_DATE%TYPE;
883: BEGIN
884: -- Standard Start of API savepoint
885: SAVEPOINT Update_Dim_Hierarchy;
886: -- Standard call to check for call compatibility.
887: IF NOT FND_API.Compatible_API_Call
888: (l_api_version ,
889: p_api_version ,
890: l_api_name ,

Line 980: -- Standard check of p_commit.

976:
977: --Increase version
978: p_object_version_number := p_object_version_number + 1;
979:
980: -- Standard check of p_commit.
981: IF FND_API.To_Boolean( p_commit ) THEN
982: COMMIT WORK;
983: END IF;
984: -- Standard call to get message count and if count is 1, get message info.

Line 984: -- Standard call to get message count and if count is 1, get message info.

980: -- Standard check of p_commit.
981: IF FND_API.To_Boolean( p_commit ) THEN
982: COMMIT WORK;
983: END IF;
984: -- Standard call to get message count and if count is 1, get message info.
985: FND_MSG_PUB.Count_And_Get
986: (p_count => x_msg_count ,
987: p_data => x_msg_data ,
988: p_encoded => FND_API.G_FALSE );

Line 1041: -- Standard Start of API savepoint

1037: l_start_date CN_DIM_HIERARCHIES.START_DATE%TYPE;
1038: l_end_date CN_DIM_HIERARCHIES.END_DATE%TYPE;
1039:
1040: BEGIN
1041: -- Standard Start of API savepoint
1042: SAVEPOINT Delete_Dim_Hierarchy;
1043: -- Standard call to check for call compatibility.
1044: IF NOT FND_API.Compatible_API_Call
1045: (l_api_version ,

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

1039:
1040: BEGIN
1041: -- Standard Start of API savepoint
1042: SAVEPOINT Delete_Dim_Hierarchy;
1043: -- Standard call to check for call compatibility.
1044: IF NOT FND_API.Compatible_API_Call
1045: (l_api_version ,
1046: p_api_version ,
1047: l_api_name ,

Line 1090: -- Standard check of p_commit.

1086: cn_dim_hierarchies_pkg.delete_row (p_dim_hierarchy_id);--,p_org_id);
1087:
1088: -- End of API body.
1089:
1090: -- Standard check of p_commit.
1091: IF FND_API.To_Boolean( p_commit ) THEN
1092: COMMIT WORK;
1093: END IF;
1094: -- Standard call to get message count and if count is 1, get message info.

Line 1094: -- Standard call to get message count and if count is 1, get message info.

1090: -- Standard check of p_commit.
1091: IF FND_API.To_Boolean( p_commit ) THEN
1092: COMMIT WORK;
1093: END IF;
1094: -- Standard call to get message count and if count is 1, get message info.
1095: FND_MSG_PUB.Count_And_Get
1096: (p_count => x_msg_count ,
1097: p_data => x_msg_data ,
1098: p_encoded => FND_API.G_FALSE );

Line 1181: -- Standard Start of API savepoint

1177: and greatest(q.start_date, h.start_date) <=
1178: least(nvl(q.end_date,l_max_date), nvl(h.end_date,l_max_date));
1179:
1180: BEGIN
1181: -- Standard Start of API savepoint
1182: SAVEPOINT Create_Edge;
1183: -- Standard call to check for call compatibility.
1184: IF NOT FND_API.Compatible_API_Call
1185: (l_api_version ,

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

1179:
1180: BEGIN
1181: -- Standard Start of API savepoint
1182: SAVEPOINT Create_Edge;
1183: -- Standard call to check for call compatibility.
1184: IF NOT FND_API.Compatible_API_Call
1185: (l_api_version ,
1186: p_api_version ,
1187: l_api_name ,

Line 1245: -- Standard check of p_commit.

1241: END;
1242:
1243: -- End of API body.
1244:
1245: -- Standard check of p_commit.
1246: IF FND_API.To_Boolean( p_commit ) THEN
1247: COMMIT WORK;
1248: END IF;
1249: -- Standard call to get message count and if count is 1, get message info.

Line 1249: -- Standard call to get message count and if count is 1, get message info.

1245: -- Standard check of p_commit.
1246: IF FND_API.To_Boolean( p_commit ) THEN
1247: COMMIT WORK;
1248: END IF;
1249: -- Standard call to get message count and if count is 1, get message info.
1250: FND_MSG_PUB.Count_And_Get
1251: (p_count => x_msg_count ,
1252: p_data => x_msg_data ,
1253: p_encoded => FND_API.G_FALSE );

Line 1307: -- Standard Start of API savepoint

1303: l_ext_id CN_HIERARCHY_NODES.EXTERNAL_ID%TYPE;
1304: l_count NUMBER;
1305:
1306: BEGIN
1307: -- Standard Start of API savepoint
1308: SAVEPOINT Delete_Edge;
1309: -- Standard call to check for call compatibility.
1310: IF NOT FND_API.Compatible_API_Call
1311: (l_api_version ,

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

1305:
1306: BEGIN
1307: -- Standard Start of API savepoint
1308: SAVEPOINT Delete_Edge;
1309: -- Standard call to check for call compatibility.
1310: IF NOT FND_API.Compatible_API_Call
1311: (l_api_version ,
1312: p_api_version ,
1313: l_api_name ,

Line 1368: -- Standard check of p_commit.

1364: X_org_id => p_org_id);
1365:
1366: -- End of API body.
1367:
1368: -- Standard check of p_commit.
1369: IF FND_API.To_Boolean( p_commit ) THEN
1370: COMMIT WORK;
1371: END IF;
1372: -- Standard call to get message count and if count is 1, get message info.

Line 1372: -- Standard call to get message count and if count is 1, get message info.

1368: -- Standard check of p_commit.
1369: IF FND_API.To_Boolean( p_commit ) THEN
1370: COMMIT WORK;
1371: END IF;
1372: -- Standard call to get message count and if count is 1, get message info.
1373: FND_MSG_PUB.Count_And_Get
1374: (p_count => x_msg_count ,
1375: p_data => x_msg_data ,
1376: p_encoded => FND_API.G_FALSE );