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 123: -- Standard Start of API savepoint

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

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

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

Line 195: -- Standard check of p_commit.

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

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

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

Line 297: -- Standard Start of API savepoint

293: WHERE repository_id > 0
294: and org_id=p_table_rec.ORG_ID
295: AND application_type = 'CN';
296: BEGIN
297: -- Standard Start of API savepoint
298: SAVEPOINT update_table_pvt;
299: -- Standard call to check for call compatibility.
300: IF NOT FND_API.Compatible_API_Call
301: (l_api_version ,

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

295: AND application_type = 'CN';
296: BEGIN
297: -- Standard Start of API savepoint
298: SAVEPOINT update_table_pvt;
299: -- Standard call to check for call compatibility.
300: IF NOT FND_API.Compatible_API_Call
301: (l_api_version ,
302: p_api_version ,
303: l_api_name ,

Line 369: -- Standard check of p_commit.

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

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

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

Line 463: -- Standard Start of API savepoint

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

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

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

Line 525: -- Standard check of p_commit.

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

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

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

Line 661: -- Standard Start of API savepoint

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

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

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

Line 762: -- Standard check of p_commit.

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

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

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

Line 902: -- Standard Start of API savepoint

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

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

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

Line 999: -- Standard check of p_commit.

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

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

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

Line 1100: -- Standard Start of API savepoint

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

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

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

Line 1133: -- Standard check of p_commit.

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

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

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