APPS.CSC_PROFILE_VARIABLE_PVT dependencies on CSC_PROF_TABLE_COLUMNS_VL

Line 293: from csc_prof_table_columns_vl

289: x_table_column_tbl OUT NOCOPY Table_Column_Tbl_Type )
290: IS
291: Cursor C1 is
292: Select table_name,column_name,label,alias_name
293: from csc_prof_table_columns_vl
294: where block_id = p_block_id
295: order by decode(drilldown_column_flag,'Y',1,2),column_sequence;
296: l_count Number := 0;
297: BEGIN

Line 1221: l_old_table_column_rec CSC_PROF_TABLE_COLUMNS_VL%ROWTYPE;

1217: l_api_name CONSTANT VARCHAR2(30) := 'Update_table_column';
1218: l_api_version_number CONSTANT NUMBER := 1.0;
1219:
1220: -- Local Variables
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

Line 1447: From CSC_PROF_TABLE_COLUMNS_VL

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

Line 2121: X_Table_Column_Rec OUT NOCOPY CSC_PROF_TABLE_COLUMNS_VL%ROWTYPE,

2117: Procedure GET_TABLE_COLUMN(
2118: p_Api_Name in VARCHAR2,
2119: p_Table_Column_Id IN NUMBER,
2120: p_object_version_number IN NUMBER,
2121: X_Table_Column_Rec OUT NOCOPY CSC_PROF_TABLE_COLUMNS_VL%ROWTYPE,
2122: X_Return_status OUT NOCOPY VARCHAR2 )
2123: IS
2124: Cursor C_Get_table_column_rec IS
2125: Select *

Line 2137: From CSC_PROF_TABLE_COLUMNS_VL

2133: CREATION_DATE,
2134: CREATED_BY,
2135: LAST_UPDATE_LOGIN
2136: */
2137: From CSC_PROF_TABLE_COLUMNS_VL
2138: Where Table_Column_ID = p_Table_Column_ID
2139: And object_version_number = p_object_version_number
2140: For Update NOWAIT;
2141: BEGIN