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 710: -- Standard start of API savepoint

706:
707: l_object_type_code VARCHAR2(80);
708: l_object_id number;
709: BEGIN
710: -- Standard start of API savepoint
711: SAVEPOINT Create_Profile_Variable_PVT;
712: -- Standard call to check for call compatibility
713: IF NOT FND_API.Compatible_API_Call(l_api_version,
714: p_api_version_number,

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

708: l_object_id number;
709: BEGIN
710: -- Standard start of API savepoint
711: SAVEPOINT Create_Profile_Variable_PVT;
712: -- Standard call to check for call compatibility
713: IF NOT FND_API.Compatible_API_Call(l_api_version,
714: p_api_version_number,
715: l_api_name,
716: G_PKG_NAME )

Line 830: -- Standard check of p_commit

826: p_APPLICATION_ID => l_prof_var_rec.APPLICATION_ID
827: );
828:
829: --
830: -- Standard check of p_commit
831: IF FND_API.To_Boolean(p_commit) THEN
832: COMMIT WORK;
833: END IF;
834:

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

831: IF FND_API.To_Boolean(p_commit) THEN
832: COMMIT WORK;
833: END IF;
834:
835: -- Standard call to get message count and if count is 1, get message info
836:
837: FND_MSG_PUB.Count_And_Get(
838: p_encoded => FND_API.G_FALSE,
839: p_count => x_msg_count,

Line 958: -- Standard Start of API savepoint

954: l_api_version_number CONSTANT NUMBER := 1.0;
955: l_table_Column_rec Table_Column_Rec_Type := p_table_column_rec;
956: BEGIN
957:
958: -- Standard Start of API savepoint
959: SAVEPOINT CREATE_Table_Column_PVT;
960:
961:
962:

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

959: SAVEPOINT CREATE_Table_Column_PVT;
960:
961:
962:
963: -- Standard call to check for call compatibility.
964: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
965: p_api_version_number,
966: l_api_name,
967: G_PKG_NAME)

Line 1037: -- Standard check for p_commit

1033: -- End of API body
1034: --
1035:
1036:
1037: -- Standard check for p_commit
1038: IF FND_API.to_Boolean( p_commit )
1039: THEN
1040: COMMIT WORK;
1041: END IF;

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

1040: COMMIT WORK;
1041: END IF;
1042:
1043:
1044: -- Standard call to get message count and if count is 1, get message info.
1045: FND_MSG_PUB.Count_And_Get(
1046: p_count => x_msg_count,
1047: p_data => x_msg_data);
1048:

Line 1204: -- standard start of API savepoint

1200:
1201: l_prof_var_rec ProfVar_Rec_Type := P_prof_Var_Rec;
1202:
1203: BEGIN
1204: -- standard start of API savepoint
1205: SAVEPOINT Update_Profile_Variable_Pvt ;
1206:
1207: -- Standard Call to check API compatibility
1208: IF NOT FND_API.Compatible_API_Call( l_api_version,

Line 1207: -- Standard Call to check API compatibility

1203: BEGIN
1204: -- standard start of API savepoint
1205: SAVEPOINT Update_Profile_Variable_Pvt ;
1206:
1207: -- Standard Call to check API compatibility
1208: IF NOT FND_API.Compatible_API_Call( l_api_version,
1209: p_api_version_number,
1210: l_api_name,
1211: G_PKG_NAME )

Line 1360: -- Standard check of p_commit

1356: px_OBJECT_VERSION_NUMBER => px_Object_Version_Number,
1357: p_APPLICATION_ID => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.APPLICATION_ID,l_old_prof_var_rec.application_id));
1358:
1359:
1360: -- Standard check of p_commit
1361: IF FND_API.To_Boolean(p_commit) THEN
1362: COMMIT WORK;
1363: END IF;
1364:

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

1361: IF FND_API.To_Boolean(p_commit) THEN
1362: COMMIT WORK;
1363: END IF;
1364:
1365: -- Standard call to get message count and if count is 1, get message info
1366: FND_MSG_PUB.Count_And_Get(
1367: p_count => x_msg_count,
1368: p_data => x_msg_data );
1369: EXCEPTION

Line 1418: -- Standard Start of API savepoint

1414: l_old_table_column_rec CSC_PROF_TABLE_COLUMNS_VL%ROWTYPE;
1415:
1416: l_table_column_Rec Table_Column_Rec_Type := p_Table_Column_REC;
1417: BEGIN
1418: -- Standard Start of API savepoint
1419: SAVEPOINT UPDATE_Table_Column_PVT;
1420:
1421: -- Standard call to check for call compatibility.
1422: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1417: BEGIN
1418: -- Standard Start of API savepoint
1419: SAVEPOINT UPDATE_Table_Column_PVT;
1420:
1421: -- Standard call to check for call compatibility.
1422: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1423: p_api_version_number,
1424: l_api_name,
1425: G_PKG_NAME)

Line 1490: -- Standard check for p_commit

1486: --
1487: -- End of API body.
1488: --
1489:
1490: -- Standard check for p_commit
1491: IF FND_API.to_Boolean( p_commit )
1492: THEN
1493: COMMIT WORK;
1494: END IF;

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

1493: COMMIT WORK;
1494: END IF;
1495:
1496:
1497: -- Standard call to get message count and if count is 1, get message info.
1498: FND_MSG_PUB.Count_And_Get
1499: ( p_count => x_msg_count,
1500: p_data => x_msg_data
1501: );

Line 1548: -- Standard Start of API savepoint

1544: IS
1545: l_api_name CONSTANT VARCHAR2(30) := 'Delete_profile_variables';
1546: l_api_version_number CONSTANT NUMBER := 1.0;
1547: BEGIN
1548: -- Standard Start of API savepoint
1549: SAVEPOINT DELETE_Profile_Variables_PVT;
1550:
1551: -- Standard call to check for call compatibility.
1552: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1547: BEGIN
1548: -- Standard Start of API savepoint
1549: SAVEPOINT DELETE_Profile_Variables_PVT;
1550:
1551: -- Standard call to check for call compatibility.
1552: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1553: p_api_version_number,
1554: l_api_name,
1555: G_PKG_NAME)

Line 1583: -- Standard check for p_commit

1579: --
1580: -- End of API body
1581: --
1582:
1583: -- Standard check for p_commit
1584: IF FND_API.to_Boolean( p_commit )
1585: THEN
1586: COMMIT WORK;
1587: END IF;

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

1586: COMMIT WORK;
1587: END IF;
1588:
1589:
1590: -- Standard call to get message count and if count is 1, get message info.
1591: FND_MSG_PUB.Count_And_Get
1592: ( p_count => x_msg_count,
1593: p_data => x_msg_data
1594: );

Line 1643: -- Standard Start of API savepoint

1639: Select table_column_id, Object_version_number
1640: From CSC_PROF_TABLE_COLUMNS_VL
1641: Where block_id = p_Block_id;
1642: BEGIN
1643: -- Standard Start of API savepoint
1644: SAVEPOINT DELETE_Table_Columns_PVT;
1645:
1646: -- Standard call to check for call compatibility.
1647: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1642: BEGIN
1643: -- Standard Start of API savepoint
1644: SAVEPOINT DELETE_Table_Columns_PVT;
1645:
1646: -- Standard call to check for call compatibility.
1647: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1648: p_api_version_number,
1649: l_api_name,
1650: G_PKG_NAME)

Line 1691: -- Standard check for p_commit

1687: --
1688: -- End of API body
1689: --
1690:
1691: -- Standard check for p_commit
1692: IF FND_API.to_Boolean( p_commit )
1693: THEN
1694: COMMIT WORK;
1695: END IF;

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

1693: THEN
1694: COMMIT WORK;
1695: END IF;
1696:
1697: -- Standard call to get message count and if count is 1, get message info.
1698: FND_MSG_PUB.Count_And_Get
1699: ( p_count => x_msg_count,
1700: p_data => x_msg_data
1701: );

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

1743: -- Procedure Validate_Block_Name
1744: -- Description: Validates the block_name using the table
1745: -- cs_prof_blocks. Block_name should not be duplicated in the table.
1746: -- Input Parameters
1747: -- p_api_name, standard parameter for writting messages
1748: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1749: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1750: -- p_block_name, block_name to be validated
1751: -- Out Parameters

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

1748: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1749: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1750: -- p_block_name, block_name to be validated
1751: -- Out Parameters
1752: -- x_return_status, standard parameter for the return status
1753: --------------------------------------------------------------------------
1754:
1755: PROCEDURE Validate_Block_Name
1756: ( p_api_name IN VARCHAR2,

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

1838: -- Procedure Validate_Seeded_Flag
1839: -- Description: Validates the seeded_flag from the fnd_lookups table
1840: -- using CSC_CORE_UTILS_PVT.lookup_code_not_exists function.
1841: -- Input Parameters
1842: -- p_api_name, standard parameter for writting messages
1843: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1844: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1845: -- p_seeded_flag, seeded_flag to be validated should be an YES or a NO
1846: -- Out Parameters

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

1843: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1844: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1845: -- p_seeded_flag, seeded_flag to be validated should be an YES or a NO
1846: -- Out Parameters
1847: -- x_return_status, standard parameter for the return status
1848: --------------------------------------------------------------------------
1849:
1850: PROCEDURE Validate_Seeded_Flag
1851: ( p_api_name IN VARCHAR2,

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

1910: -- Procedure Validate_Currecny_Code
1911: -- Description: Validates the currency_Code from the fnd_currencies table
1912: -- using CSC_CORE_UTILS_PVT.currency_code_not_exists function.
1913: -- Input Parameters
1914: -- p_api_name, standard parameter for writting messages
1915: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1916: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1917: -- p_currrency_code, currency_code to be validated
1918: -- Out Parameters

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

1915: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1916: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1917: -- p_currrency_code, currency_code to be validated
1918: -- Out Parameters
1919: -- x_return_status, standard parameter for the return status
1920: --------------------------------------------------------------------------
1921:
1922: PROCEDURE Validate_Currency_Code
1923: ( p_api_name IN VARCHAR2,

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

1953: --------------------------------------------------------------------------
1954: -- Procedure Validate_Sql_Stmnt
1955: -- Description: Validates the sql_statement using the dynamic sql
1956: -- Input Parameters
1957: -- p_api_name, standard parameter for writting messages
1958: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1959: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1960: -- p_sql_statement, concatented field using select_Clause, from_clause
1961: -- where_clause and Other_Clause columns using the Build_Sql_Stmnt

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

1960: -- p_sql_statement, concatented field using select_Clause, from_clause
1961: -- where_clause and Other_Clause columns using the Build_Sql_Stmnt
1962: -- procedure
1963: -- Out Parameters
1964: -- x_return_status, standard parameter for the return status
1965: --------------------------------------------------------------------------
1966: PROCEDURE Validate_Sql_Stmnt(
1967: p_api_name IN VARCHAR2,
1968: p_parameter_Name IN VARCHAR2,

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

2346: -- Procedure Validate_Block_Id
2347: -- Description: Validates the block_id using the table
2348: -- cs_prof_blocks.
2349: -- Input Parameters
2350: -- p_api_name, standard parameter for writting messages
2351: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
2352: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
2353: -- p_block_id, block_id to be validated while updating
2354: -- Out Parameters

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

2351: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
2352: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
2353: -- p_block_id, block_id to be validated while updating
2354: -- Out Parameters
2355: -- x_return_status, standard parameter for the return status
2356: --------------------------------------------------------------------------
2357:
2358: PROCEDURE Validate_Block_Id (
2359: p_api_name IN VARCHAR2,