APPS.CSC_PROFILE_VARIABLE_PVT dependencies on CSC_PROF_TABLE_COLUMNS_VL

Line 335: from csc_prof_table_columns_vl

331: x_table_column_tbl OUT NOCOPY Table_Column_Tbl_Type )
332: IS
333: Cursor C1 is
334: Select table_name,column_name,label,alias_name
335: from csc_prof_table_columns_vl
336: where block_id = p_block_id
337: order by decode(drilldown_column_flag,'Y',1,2),column_sequence;
338: l_count Number := 0;
339: BEGIN

Line 1414: l_old_table_column_rec CSC_PROF_TABLE_COLUMNS_VL%ROWTYPE;

1410: l_api_name CONSTANT VARCHAR2(30) := 'Update_table_column';
1411: l_api_version_number CONSTANT NUMBER := 1.0;
1412:
1413: -- Local Variables
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

Line 1640: From CSC_PROF_TABLE_COLUMNS_VL

1636: l_api_name CONSTANT VARCHAR2(30) := 'Delete_table_columns';
1637: l_api_version_number CONSTANT NUMBER := 1.0;
1638: Cursor C1 IS
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;

Line 2303: X_Table_Column_Rec OUT NOCOPY CSC_PROF_TABLE_COLUMNS_VL%ROWTYPE,

2299: Procedure GET_TABLE_COLUMN(
2300: p_Api_Name in VARCHAR2,
2301: p_Table_Column_Id IN NUMBER,
2302: p_object_version_number IN NUMBER,
2303: X_Table_Column_Rec OUT NOCOPY CSC_PROF_TABLE_COLUMNS_VL%ROWTYPE,
2304: X_Return_status OUT NOCOPY VARCHAR2 )
2305: IS
2306: Cursor C_Get_table_column_rec IS
2307: Select *

Line 2319: From CSC_PROF_TABLE_COLUMNS_VL

2315: CREATION_DATE,
2316: CREATED_BY,
2317: LAST_UPDATE_LOGIN
2318: */
2319: From CSC_PROF_TABLE_COLUMNS_VL
2320: Where Table_Column_ID = p_Table_Column_ID
2321: And object_version_number = p_object_version_number
2322: For Update NOWAIT;
2323: BEGIN