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

Line 22: -- p_api_name, standard parameter for writting messages

18: -- Description: Concatenates the select_Clause, from_clause, where_clause
19: -- and Other_clause to build an sql statement which will be stored in
20: -- the sql_statement column in cs_prof_blocks table.
21: -- Input Parameters
22: -- p_api_name, standard parameter for writting messages
23: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
24: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
25: -- p_sql_statement, concatented field using select_Clause, from_clause
26: -- where_clause and Other_Clause columns using the Build_Sql_Stmnt

Line 29: -- x_return_status, standard parameter for the return status

25: -- p_sql_statement, concatented field using select_Clause, from_clause
26: -- where_clause and Other_Clause columns using the Build_Sql_Stmnt
27: -- procedure
28: -- Out Parameters
29: -- x_return_status, standard parameter for the return status
30: --------------------------------------------------------------------------
31:
32: PROCEDURE Build_Sql_Stmnt
33: ( p_api_name IN VARCHAR2,

Line 515: -- Standard start of API savepoint

511: l_object_type_code VARCHAR2(80);
512: l_object_id number;
513: BEGIN
514:
515: -- Standard start of API savepoint
516: SAVEPOINT Create_Profile_Variable_PVT;
517:
518: -- Standard call to check for call compatibility
519: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 518: -- Standard call to check for call compatibility

514:
515: -- Standard start of API savepoint
516: SAVEPOINT Create_Profile_Variable_PVT;
517:
518: -- Standard call to check for call compatibility
519: IF NOT FND_API.Compatible_API_Call(l_api_version,
520: p_api_version_number,
521: l_api_name,
522: G_PKG_NAME )

Line 641: -- Standard check of p_commit

637: p_APPLICATION_ID => l_prof_var_rec.APPLICATION_ID
638: );
639:
640: --
641: -- Standard check of p_commit
642: IF FND_API.To_Boolean(p_commit) THEN
643: COMMIT WORK;
644: END IF;
645:

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

642: IF FND_API.To_Boolean(p_commit) THEN
643: COMMIT WORK;
644: END IF;
645:
646: -- Standard call to get message count and if count is 1, get message info
647:
648: FND_MSG_PUB.Count_And_Get(
649: p_encoded => FND_API.G_FALSE,
650: p_count => x_msg_count,

Line 769: -- Standard Start of API savepoint

765: l_api_version_number CONSTANT NUMBER := 1.0;
766: l_table_Column_rec Table_Column_Rec_Type := p_table_column_rec;
767: BEGIN
768:
769: -- Standard Start of API savepoint
770: SAVEPOINT CREATE_Table_Column_PVT;
771:
772:
773:

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

770: SAVEPOINT CREATE_Table_Column_PVT;
771:
772:
773:
774: -- Standard call to check for call compatibility.
775: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
776: p_api_version_number,
777: l_api_name,
778: G_PKG_NAME)

Line 848: -- Standard check for p_commit

844: -- End of API body
845: --
846:
847:
848: -- Standard check for p_commit
849: IF FND_API.to_Boolean( p_commit )
850: THEN
851: COMMIT WORK;
852: END IF;

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

851: COMMIT WORK;
852: END IF;
853:
854:
855: -- Standard call to get message count and if count is 1, get message info.
856: FND_MSG_PUB.Count_And_Get(
857: p_count => x_msg_count,
858: p_data => x_msg_data);
859:

Line 1015: -- standard start of API savepoint

1011:
1012: l_prof_var_rec ProfVar_Rec_Type := P_prof_Var_Rec;
1013:
1014: BEGIN
1015: -- standard start of API savepoint
1016: SAVEPOINT Update_Profile_Variable_Pvt ;
1017:
1018: -- Standard Call to check API compatibility
1019: IF NOT FND_API.Compatible_API_Call( l_api_version,

Line 1018: -- Standard Call to check API compatibility

1014: BEGIN
1015: -- standard start of API savepoint
1016: SAVEPOINT Update_Profile_Variable_Pvt ;
1017:
1018: -- Standard Call to check API compatibility
1019: IF NOT FND_API.Compatible_API_Call( l_api_version,
1020: p_api_version_number,
1021: l_api_name,
1022: G_PKG_NAME )

Line 1167: -- Standard check of p_commit

1163: px_OBJECT_VERSION_NUMBER => px_Object_Version_Number,
1164: p_APPLICATION_ID => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.APPLICATION_ID,l_old_prof_var_rec.application_id));
1165:
1166:
1167: -- Standard check of p_commit
1168: IF FND_API.To_Boolean(p_commit) THEN
1169: COMMIT WORK;
1170: END IF;
1171:

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

1168: IF FND_API.To_Boolean(p_commit) THEN
1169: COMMIT WORK;
1170: END IF;
1171:
1172: -- Standard call to get message count and if count is 1, get message info
1173: FND_MSG_PUB.Count_And_Get(
1174: p_count => x_msg_count,
1175: p_data => x_msg_data );
1176: EXCEPTION

Line 1225: -- Standard Start of API savepoint

1221: l_old_table_column_rec CSC_PROF_TABLE_COLUMNS_VL%ROWTYPE;
1222:
1223: l_table_column_Rec Table_Column_Rec_Type := p_Table_Column_REC;
1224: BEGIN
1225: -- Standard Start of API savepoint
1226: SAVEPOINT UPDATE_Table_Column_PVT;
1227:
1228: -- Standard call to check for call compatibility.
1229: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1224: BEGIN
1225: -- Standard Start of API savepoint
1226: SAVEPOINT UPDATE_Table_Column_PVT;
1227:
1228: -- Standard call to check for call compatibility.
1229: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1230: p_api_version_number,
1231: l_api_name,
1232: G_PKG_NAME)

Line 1297: -- Standard check for p_commit

1293: --
1294: -- End of API body.
1295: --
1296:
1297: -- Standard check for p_commit
1298: IF FND_API.to_Boolean( p_commit )
1299: THEN
1300: COMMIT WORK;
1301: END IF;

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

1300: COMMIT WORK;
1301: END IF;
1302:
1303:
1304: -- Standard call to get message count and if count is 1, get message info.
1305: FND_MSG_PUB.Count_And_Get
1306: ( p_count => x_msg_count,
1307: p_data => x_msg_data
1308: );

Line 1355: -- Standard Start of API savepoint

1351: IS
1352: l_api_name CONSTANT VARCHAR2(30) := 'Delete_profile_variables';
1353: l_api_version_number CONSTANT NUMBER := 1.0;
1354: BEGIN
1355: -- Standard Start of API savepoint
1356: SAVEPOINT DELETE_Profile_Variables_PVT;
1357:
1358: -- Standard call to check for call compatibility.
1359: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1354: BEGIN
1355: -- Standard Start of API savepoint
1356: SAVEPOINT DELETE_Profile_Variables_PVT;
1357:
1358: -- Standard call to check for call compatibility.
1359: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1360: p_api_version_number,
1361: l_api_name,
1362: G_PKG_NAME)

Line 1390: -- Standard check for p_commit

1386: --
1387: -- End of API body
1388: --
1389:
1390: -- Standard check for p_commit
1391: IF FND_API.to_Boolean( p_commit )
1392: THEN
1393: COMMIT WORK;
1394: END IF;

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

1393: COMMIT WORK;
1394: END IF;
1395:
1396:
1397: -- Standard call to get message count and if count is 1, get message info.
1398: FND_MSG_PUB.Count_And_Get
1399: ( p_count => x_msg_count,
1400: p_data => x_msg_data
1401: );

Line 1450: -- Standard Start of API savepoint

1446: Select table_column_id, Object_version_number
1447: From CSC_PROF_TABLE_COLUMNS_VL
1448: Where block_id = p_Block_id;
1449: BEGIN
1450: -- Standard Start of API savepoint
1451: SAVEPOINT DELETE_Table_Columns_PVT;
1452:
1453: -- Standard call to check for call compatibility.
1454: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1449: BEGIN
1450: -- Standard Start of API savepoint
1451: SAVEPOINT DELETE_Table_Columns_PVT;
1452:
1453: -- Standard call to check for call compatibility.
1454: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1455: p_api_version_number,
1456: l_api_name,
1457: G_PKG_NAME)

Line 1498: -- Standard check for p_commit

1494: --
1495: -- End of API body
1496: --
1497:
1498: -- Standard check for p_commit
1499: IF FND_API.to_Boolean( p_commit )
1500: THEN
1501: COMMIT WORK;
1502: END IF;

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

1500: THEN
1501: COMMIT WORK;
1502: END IF;
1503:
1504: -- Standard call to get message count and if count is 1, get message info.
1505: FND_MSG_PUB.Count_And_Get
1506: ( p_count => x_msg_count,
1507: p_data => x_msg_data
1508: );

Line 1554: -- p_api_name, standard parameter for writting messages

1550: -- Procedure Validate_Block_Name
1551: -- Description: Validates the block_name using the table
1552: -- cs_prof_blocks. Block_name should not be duplicated in the table.
1553: -- Input Parameters
1554: -- p_api_name, standard parameter for writting messages
1555: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1556: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1557: -- p_block_name, block_name to be validated
1558: -- Out Parameters

Line 1559: -- x_return_status, standard parameter for the return status

1555: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1556: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1557: -- p_block_name, block_name to be validated
1558: -- Out Parameters
1559: -- x_return_status, standard parameter for the return status
1560: --------------------------------------------------------------------------
1561:
1562: PROCEDURE Validate_Block_Name
1563: ( p_api_name IN VARCHAR2,

Line 1651: -- p_api_name, standard parameter for writting messages

1647: -- Procedure Validate_Seeded_Flag
1648: -- Description: Validates the seeded_flag from the fnd_lookups table
1649: -- using CSC_CORE_UTILS_PVT.lookup_code_not_exists function.
1650: -- Input Parameters
1651: -- p_api_name, standard parameter for writting messages
1652: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1653: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1654: -- p_seeded_flag, seeded_flag to be validated should be an YES or a NO
1655: -- Out Parameters

Line 1656: -- x_return_status, standard parameter for the return status

1652: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1653: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1654: -- p_seeded_flag, seeded_flag to be validated should be an YES or a NO
1655: -- Out Parameters
1656: -- x_return_status, standard parameter for the return status
1657: --------------------------------------------------------------------------
1658:
1659: PROCEDURE Validate_Seeded_Flag
1660: ( p_api_name IN VARCHAR2,

Line 1721: -- p_api_name, standard parameter for writting messages

1717: -- Procedure Validate_Currecny_Code
1718: -- Description: Validates the currency_Code from the fnd_currencies table
1719: -- using CSC_CORE_UTILS_PVT.currency_code_not_exists function.
1720: -- Input Parameters
1721: -- p_api_name, standard parameter for writting messages
1722: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1723: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1724: -- p_currrency_code, currency_code to be validated
1725: -- Out Parameters

Line 1726: -- x_return_status, standard parameter for the return status

1722: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1723: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1724: -- p_currrency_code, currency_code to be validated
1725: -- Out Parameters
1726: -- x_return_status, standard parameter for the return status
1727: --------------------------------------------------------------------------
1728:
1729: PROCEDURE Validate_Currency_Code
1730: ( p_api_name IN VARCHAR2,

Line 1764: -- p_api_name, standard parameter for writting messages

1760: --------------------------------------------------------------------------
1761: -- Procedure Validate_Sql_Stmnt
1762: -- Description: Validates the sql_statement using the dynamic sql
1763: -- Input Parameters
1764: -- p_api_name, standard parameter for writting messages
1765: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1766: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1767: -- p_sql_statement, concatented field using select_Clause, from_clause
1768: -- where_clause and Other_Clause columns using the Build_Sql_Stmnt

Line 1771: -- x_return_status, standard parameter for the return status

1767: -- p_sql_statement, concatented field using select_Clause, from_clause
1768: -- where_clause and Other_Clause columns using the Build_Sql_Stmnt
1769: -- procedure
1770: -- Out Parameters
1771: -- x_return_status, standard parameter for the return status
1772: --------------------------------------------------------------------------
1773: PROCEDURE Validate_Sql_Stmnt(
1774: p_api_name IN VARCHAR2,
1775: p_parameter_Name IN VARCHAR2,

Line 2168: -- p_api_name, standard parameter for writting messages

2164: -- Procedure Validate_Block_Id
2165: -- Description: Validates the block_id using the table
2166: -- cs_prof_blocks.
2167: -- Input Parameters
2168: -- p_api_name, standard parameter for writting messages
2169: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
2170: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
2171: -- p_block_id, block_id to be validated while updating
2172: -- Out Parameters

Line 2173: -- x_return_status, standard parameter for the return status

2169: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
2170: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
2171: -- p_block_id, block_id to be validated while updating
2172: -- Out Parameters
2173: -- x_return_status, standard parameter for the return status
2174: --------------------------------------------------------------------------
2175:
2176: PROCEDURE Validate_Block_Id (
2177: p_api_name IN VARCHAR2,