APPS.CSC_PROFILE_VARIABLE_PVT dependencies on CSC_PROF_BLOCKS_B

Line 95: from csc_prof_blocks_b

91: l_sql_stmnt VARCHAR2(2000);
92:
93: Cursor C2 is
94: select where_clause
95: from csc_prof_blocks_b
96: where block_id = p_block_id;
97:
98: BEGIN
99:

Line 176: from csc_prof_blocks_b

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

Line 376: from csc_prof_blocks_b

372: and column_name = x_column_name;
373: Cursor C2 is
374: select where_clause,
375: other_clause,from_clause
376: from csc_prof_blocks_b
377: where block_id = p_block_id;
378:
379: Cursor C3 is
380: select count(distinct column_name)

Line 922: from csc_prof_blocks_b

918: /* --Need to work on this one...
919: -- If drilldown sql statement is not passed in or is null then
920: Select object_version_number
921: into l_object_version_number
922: from csc_prof_blocks_b
923: where block_id = p_table_column_rec.block_id;
924:
925: Update_Profile_Variable(
926: p_api_version_number => 1.0,

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

1571: --
1572: -- Api body
1573: --
1574:
1575: -- Invoke table handler(CSC_PROF_BLOCKS_B_PKG.Delete_Row)
1576: CSC_PROF_BLOCKS_PKG.Delete_Row(
1577: p_BLOCK_ID => P_BLOCK_ID,
1578: p_OBJECT_VERSION_NUMBER => p_OBJECT_VERSION_NUMBER);
1579: --

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

1666: --
1667: -- Api body
1668: --
1669: FOR C1_rec in C1 LOOP
1670: -- Invoke table handler(CSC_PROF_BLOCKS_B_PKG.Delete_Row)
1671: CSC_PROF_TABLE_COLUMNS_PKG.Delete_Row(
1672: p_TABLE_COLUMN_ID => C1_rec.TABLE_COLUMN_ID,
1673: p_OBJECT_VERSION_NUMBER => C1_rec.OBJECT_VERSION_NUMBER);
1674: END LOOP;

Line 2047: from csc_prof_blocks_b

2043: l_dummy VARCHAR2(1);
2044:
2045: cursor get_block_code is
2046: Select null
2047: from csc_prof_blocks_b
2048: where block_name_code = p_block_name_code;
2049:
2050: BEGIN
2051: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2369: From csc_prof_blocks_b

2365: Function chk_block_id (p_block_id IN NUMBER) RETURN VARCHAR2
2366: IS
2367: Cursor get_block_id is
2368: Select NULL
2369: From csc_prof_blocks_b
2370: Where block_id = p_block_id;
2371: l_dummy varchar2(10);
2372: l_return_status VARCHAR2(30);
2373: BEGIN