APPS.BIS_PMV_ACTUAL_PVT dependencies on BIS_PMV_QUERY_PVT

Line 303: BIS_PMV_QUERY_PVT.getQuerySql(

299: end if; -- end of setting up calculation measure infos
300:
301: x_return_Status := FND_API.G_RET_STS_SUCCESS;
302: -- get main query
303: BIS_PMV_QUERY_PVT.getQuerySql(
304: p_Region_Code => p_region_code,
305: p_function_name => p_function_name,
306: p_user_id => p_user_id ,
307: p_session_id => p_session_id,

Line 330: l_debug_msg := l_debug_msg ||'BIS_PMV_QUERY_PVT.getQuerySql: '||x_return_status||'*'||x_msg_data

326:
327: l_query_String := replace(l_query_String, ':', ':x');
328:
329: if g_debug_on then
330: l_debug_msg := l_debug_msg ||'BIS_PMV_QUERY_PVT.getQuerySql: '||x_return_status||'*'||x_msg_data
331: ||' sql:'||l_query_string||' bind variables:'||l_plsql_bind_variables
332: ||' bind indexes:'||l_bind_indexes;
333: /*
334: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => 'BIS_PMV_QUERY_PVT',

Line 334: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => 'BIS_PMV_QUERY_PVT',

330: l_debug_msg := l_debug_msg ||'BIS_PMV_QUERY_PVT.getQuerySql: '||x_return_status||'*'||x_msg_data
331: ||' sql:'||l_query_string||' bind variables:'||l_plsql_bind_variables
332: ||' bind indexes:'||l_bind_indexes;
333: /*
334: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => 'BIS_PMV_QUERY_PVT',
335: p_procedure_name => 'getQuerySql',
336: p_error_text => 'status and msg: '||x_return_status||'*'|| x_msg_data
337: ||' sql:'||l_query_string||' bind variables:'||l_plsql_bind_variables
338: );

Line 886: BIS_PMV_QUERY_PVT.getQuerySql(

882:
883: --Now execute the query and get the values back.
884: x_return_Status := FND_API.G_RET_STS_SUCCESS;
885: --dbms_output.put_line ('About to execute the query');
886: BIS_PMV_QUERY_PVT.getQuerySql(
887: p_Region_Code => p_region_code,
888: p_function_name => l_function_name,
889: p_user_id => l_user_id ,
890: p_session_id => l_session_id,

Line 924: l_debug_msg := l_debug_msg || 'BIS_PMV_QUERY_PVT.getQuerySql: '||x_return_status||'*'||x_msg_data

920:
921: l_query_String := replace(l_query_String, ':', ':x');
922:
923: if g_debug_on then
924: l_debug_msg := l_debug_msg || 'BIS_PMV_QUERY_PVT.getQuerySql: '||x_return_status||'*'||x_msg_data
925: ||' sql:'||l_query_string||' bind variables:'||l_plsql_bind_variables
926: ||' bind indexes:'||l_bind_indexes;
927: /*
928: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => 'BIS_PMV_QUERY_PVT',

Line 928: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => 'BIS_PMV_QUERY_PVT',

924: l_debug_msg := l_debug_msg || 'BIS_PMV_QUERY_PVT.getQuerySql: '||x_return_status||'*'||x_msg_data
925: ||' sql:'||l_query_string||' bind variables:'||l_plsql_bind_variables
926: ||' bind indexes:'||l_bind_indexes;
927: /*
928: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => 'BIS_PMV_QUERY_PVT',
929: p_procedure_name => 'getQuerySql',
930: p_error_text => 'status and msg: '||x_return_status||'*'|| x_msg_data
931: ||' sql:'||l_query_string||' bind variables:'||l_plsql_bind_variables
932: );

Line 1894: BIS_PMV_QUERY_PVT.getQuerySql(

1890:
1891: --Now execute the query and get the values back.
1892: x_return_Status := FND_API.G_RET_STS_SUCCESS;
1893: --dbms_output.put_line ('About to execute the query');
1894: BIS_PMV_QUERY_PVT.getQuerySql(
1895: p_Region_Code => p_region_code,
1896: p_function_name => l_function_name,
1897: p_user_id => l_user_id ,
1898: p_session_id => l_session_id,

Line 1932: l_debug_msg := l_debug_msg || 'BIS_PMV_QUERY_PVT.getQuerySql: '||x_return_status||'*'||x_msg_data

1928:
1929: l_query_String := replace(l_query_String, ':', ':x');
1930:
1931: if g_debug_on then
1932: l_debug_msg := l_debug_msg || 'BIS_PMV_QUERY_PVT.getQuerySql: '||x_return_status||'*'||x_msg_data
1933: ||' sql:'||l_query_string||' bind variables:'||l_plsql_bind_variables
1934: ||' bind indexes:'||l_bind_indexes;
1935: end if;
1936: