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_SYS_TABLES_PVT dependencies on STANDARD

Line 124: -- Standard Start of API savepoint

120:
121: l_loading_status varchar2(80);
122: l_table_rec cn_cnsytc_tables_pvt.table_rec_type;
123: BEGIN
124: -- Standard Start of API savepoint
125: SAVEPOINT create_table_pvt;
126: -- Standard call to check for call compatibility.
127: IF NOT FND_API.Compatible_API_Call
128: (l_api_version ,

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

122: l_table_rec cn_cnsytc_tables_pvt.table_rec_type;
123: BEGIN
124: -- Standard Start of API savepoint
125: SAVEPOINT create_table_pvt;
126: -- Standard call to check for call compatibility.
127: IF NOT FND_API.Compatible_API_Call
128: (l_api_version ,
129: p_api_version ,
130: l_api_name ,

Line 196: -- Standard check of p_commit.

192: , p_validation_level => p_validation_level
193: , p_table_rec => l_table_rec);
194:
195: -- End of API body.
196: -- Standard check of p_commit.
197: IF FND_API.To_Boolean( p_commit ) THEN
198: COMMIT WORK;
199: END IF;
200: -- Standard call to get message count and if count is 1, get message info.

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

196: -- Standard check of p_commit.
197: IF FND_API.To_Boolean( p_commit ) THEN
198: COMMIT WORK;
199: END IF;
200: -- Standard call to get message count and if count is 1, get message info.
201: FND_MSG_PUB.Count_And_Get
202: (p_count => x_msg_count ,
203: p_data => x_msg_data ,
204: p_encoded => FND_API.G_FALSE );

Line 298: -- Standard Start of API savepoint

294: WHERE repository_id > 0
295: and org_id=p_table_rec.ORG_ID
296: AND application_type = 'CN';
297: BEGIN
298: -- Standard Start of API savepoint
299: SAVEPOINT update_table_pvt;
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: AND application_type = 'CN';
297: BEGIN
298: -- Standard Start of API savepoint
299: SAVEPOINT update_table_pvt;
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 370: -- Standard check of p_commit.

366: );
367:
368:
369: -- End of API body.
370: -- Standard check of p_commit.
371: IF FND_API.To_Boolean( p_commit ) THEN
372: COMMIT WORK;
373: END IF;
374: -- Standard call to get message count and if count is 1, get message info.

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

370: -- Standard check of p_commit.
371: IF FND_API.To_Boolean( p_commit ) THEN
372: COMMIT WORK;
373: END IF;
374: -- Standard call to get message count and if count is 1, get message info.
375: FND_MSG_PUB.Count_And_Get
376: (p_count => x_msg_count ,
377: p_data => x_msg_data ,
378: p_encoded => FND_API.G_FALSE );

Line 464: -- Standard Start of API savepoint

460: l_sorc_count NUMBER := 0;
461: -------
462:
463: BEGIN
464: -- Standard Start of API savepoint
465: SAVEPOINT delete_table_pvt;
466: -- Standard call to check for call compatibility.
467: IF NOT FND_API.Compatible_API_Call
468: (l_api_version ,

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

462:
463: BEGIN
464: -- Standard Start of API savepoint
465: SAVEPOINT delete_table_pvt;
466: -- Standard call to check for call compatibility.
467: IF NOT FND_API.Compatible_API_Call
468: (l_api_version ,
469: p_api_version ,
470: l_api_name ,

Line 526: -- Standard check of p_commit.

522: DELETE FROM cn_obj_tables_v
523: WHERE table_id = p_table_rec.object_id;
524:
525: -- End of API body.
526: -- Standard check of p_commit.
527: IF FND_API.To_Boolean( p_commit ) THEN
528: COMMIT WORK;
529: END IF;
530: -- Standard call to get message count and if count is 1, get message info.

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

526: -- Standard check of p_commit.
527: IF FND_API.To_Boolean( p_commit ) THEN
528: COMMIT WORK;
529: END IF;
530: -- Standard call to get message count and if count is 1, get message info.
531: FND_MSG_PUB.Count_And_Get
532: (p_count => x_msg_count ,
533: p_data => x_msg_data ,
534: p_encoded => FND_API.G_FALSE );

Line 662: -- Standard Start of API savepoint

658:
659: l_col_rec l_col_csr%ROWTYPE;
660:
661: BEGIN
662: -- Standard Start of API savepoint
663: SAVEPOINT update_column_pvt;
664: -- Standard call to check for call compatibility.
665: IF NOT FND_API.Compatible_API_Call
666: (l_api_version ,

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

660:
661: BEGIN
662: -- Standard Start of API savepoint
663: SAVEPOINT update_column_pvt;
664: -- Standard call to check for call compatibility.
665: IF NOT FND_API.Compatible_API_Call
666: (l_api_version ,
667: p_api_version ,
668: l_api_name ,

Line 763: -- Standard check of p_commit.

759: WHERE column_id = p_column_rec.object_id
760: AND org_id=p_column_rec.org_id;
761:
762: -- End of API body.
763: -- Standard check of p_commit.
764: IF FND_API.To_Boolean( p_commit ) THEN
765: COMMIT WORK;
766: END IF;
767: -- Standard call to get message count and if count is 1, get message info.

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

763: -- Standard check of p_commit.
764: IF FND_API.To_Boolean( p_commit ) THEN
765: COMMIT WORK;
766: END IF;
767: -- Standard call to get message count and if count is 1, get message info.
768: FND_MSG_PUB.Count_And_Get
769: (p_count => x_msg_count ,
770: p_data => x_msg_data ,
771: p_encoded => FND_API.G_FALSE );

Line 905: -- Standard Start of API savepoint

901: AND data_type IN
902: ('CHAR','NCHAR','VARCHAR2','VARCHAR','NVARCHAR2','LONG','NUMBER','DATE');
903:
904: BEGIN
905: -- Standard Start of API savepoint
906: l_object_version_number:=1;
907: SAVEPOINT insert_column_pvt;
908: -- Standard call to check for call compatibility.
909: IF NOT FND_API.Compatible_API_Call

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

904: BEGIN
905: -- Standard Start of API savepoint
906: l_object_version_number:=1;
907: SAVEPOINT insert_column_pvt;
908: -- Standard call to check for call compatibility.
909: IF NOT FND_API.Compatible_API_Call
910: (l_api_version ,
911: p_api_version ,
912: l_api_name ,

Line 1002: -- Standard check of p_commit.

998:
999: CLOSE l_col_data_csr;
1000:
1001: -- End of API body.
1002: -- Standard check of p_commit.
1003: IF FND_API.To_Boolean( p_commit ) THEN
1004: COMMIT WORK;
1005: END IF;
1006: -- Standard call to get message count and if count is 1, get message info.

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

1002: -- Standard check of p_commit.
1003: IF FND_API.To_Boolean( p_commit ) THEN
1004: COMMIT WORK;
1005: END IF;
1006: -- Standard call to get message count and if count is 1, get message info.
1007: FND_MSG_PUB.Count_And_Get
1008: (p_count => x_msg_count ,
1009: p_data => x_msg_data ,
1010: p_encoded => FND_API.G_FALSE );

Line 1103: -- Standard Start of API savepoint

1099: WHERE column_id = p_column_id
1100: AND object_type = 'COL';
1101:
1102: BEGIN
1103: -- Standard Start of API savepoint
1104: SAVEPOINT delete_column_pvt;
1105: -- Standard call to check for call compatibility.
1106: IF NOT FND_API.Compatible_API_Call
1107: (l_api_version ,

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

1101:
1102: BEGIN
1103: -- Standard Start of API savepoint
1104: SAVEPOINT delete_column_pvt;
1105: -- Standard call to check for call compatibility.
1106: IF NOT FND_API.Compatible_API_Call
1107: (l_api_version ,
1108: p_api_version ,
1109: l_api_name ,

Line 1136: -- Standard check of p_commit.

1132: WHERE column_id = p_column_id
1133: AND object_type = 'COL';
1134:
1135: -- End of API body.
1136: -- Standard check of p_commit.
1137: IF FND_API.To_Boolean( p_commit ) THEN
1138: COMMIT WORK;
1139: END IF;
1140: -- Standard call to get message count and if count is 1, get message info.

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

1136: -- Standard check of p_commit.
1137: IF FND_API.To_Boolean( p_commit ) THEN
1138: COMMIT WORK;
1139: END IF;
1140: -- Standard call to get message count and if count is 1, get message info.
1141: FND_MSG_PUB.Count_And_Get
1142: (p_count => x_msg_count ,
1143: p_data => x_msg_data ,
1144: p_encoded => FND_API.G_FALSE );