APPS.CSC_PROFILE_VARIABLE_PVT dependencies on CSC_PROF_BLOCKS_B

Line 99: from csc_prof_blocks_b

95: l_sql_stmnt VARCHAR2(2000);
96:
97: Cursor C2 is
98: select where_clause
99: from csc_prof_blocks_b
100: where block_id = p_block_id;
101:
102: BEGIN
103:

Line 179: from csc_prof_blocks_b

175: -- Changed cursor to include other_clause and from_clause
176: -- Bug 1395031
177: Cursor C2 is
178: select where_clause, other_clause,from_clause
179: from csc_prof_blocks_b
180: where block_id = p_block_id;
181:
182: Cursor C3 is
183: select count(distinct column_name)

Line 733: from csc_prof_blocks_b

729: /* --Need to work on this one...
730: -- If drilldown sql statement is not passed in or is null then
731: Select object_version_number
732: into l_object_version_number
733: from csc_prof_blocks_b
734: where block_id = p_table_column_rec.block_id;
735:
736: Update_Profile_Variable(
737: p_api_version_number => 1.0,

Line 1382: -- Invoke table handler(CSC_PROF_BLOCKS_B_PKG.Delete_Row)

1378: --
1379: -- Api body
1380: --
1381:
1382: -- Invoke table handler(CSC_PROF_BLOCKS_B_PKG.Delete_Row)
1383: CSC_PROF_BLOCKS_PKG.Delete_Row(
1384: p_BLOCK_ID => P_BLOCK_ID,
1385: p_OBJECT_VERSION_NUMBER => p_OBJECT_VERSION_NUMBER);
1386: --

Line 1477: -- Invoke table handler(CSC_PROF_BLOCKS_B_PKG.Delete_Row)

1473: --
1474: -- Api body
1475: --
1476: FOR C1_rec in C1 LOOP
1477: -- Invoke table handler(CSC_PROF_BLOCKS_B_PKG.Delete_Row)
1478: CSC_PROF_TABLE_COLUMNS_PKG.Delete_Row(
1479: p_TABLE_COLUMN_ID => C1_rec.TABLE_COLUMN_ID,
1480: p_OBJECT_VERSION_NUMBER => C1_rec.OBJECT_VERSION_NUMBER);
1481: END LOOP;

Line 1854: from csc_prof_blocks_b

1850: l_dummy VARCHAR2(1);
1851:
1852: cursor get_block_code is
1853: Select null
1854: from csc_prof_blocks_b
1855: where block_name_code = p_block_name_code;
1856:
1857: BEGIN
1858: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2187: From csc_prof_blocks_b

2183: Function chk_block_id (p_block_id IN NUMBER) RETURN VARCHAR2
2184: IS
2185: Cursor get_block_id is
2186: Select NULL
2187: From csc_prof_blocks_b
2188: Where block_id = p_block_id;
2189: l_dummy varchar2(10);
2190: l_return_status VARCHAR2(30);
2191: BEGIN