DBA Data[Home] [Help]

APPS.AMV_USER_PVT dependencies on FND_GLOBAL

Line 836: 'Select count(*) ' ||fnd_global.local_chr(10)||

832: 'r.first_name, ' ||
833: 'r.last_name ' ||
834: 'From amv_rs_all_res_extns_vl r ';
835: l_sql_statement2 :=
836: 'Select count(*) ' ||fnd_global.local_chr(10)||
837: 'From amv_rs_all_res_extns_vl r ';
838: --l_where_clause := 'Where r.start_date_active < sysdate ' ||
839: -- 'And nvl(r.end_date_active, sysdate+1) > sysdate ';
840: IF ( p_resource_id = FND_API.G_MISS_NUM ) THEN

Line 850: l_sql_statement := l_sql_statement ||fnd_global.local_chr(10)||

846: ELSE
847: l_where_clause := 'Where resource_id = ' || p_resource_id || ' ';
848:
849: END IF;
850: l_sql_statement := l_sql_statement ||fnd_global.local_chr(10)||
851: l_where_clause ||fnd_global.local_chr(10)|| 'ORDER BY r.last_name, r.first_name ';
852:
853: l_sql_statement2 := l_sql_statement2 ||fnd_global.local_chr(10)||l_where_clause;
854: IF (G_DEBUG = TRUE) THEN

Line 851: l_where_clause ||fnd_global.local_chr(10)|| 'ORDER BY r.last_name, r.first_name ';

847: l_where_clause := 'Where resource_id = ' || p_resource_id || ' ';
848:
849: END IF;
850: l_sql_statement := l_sql_statement ||fnd_global.local_chr(10)||
851: l_where_clause ||fnd_global.local_chr(10)|| 'ORDER BY r.last_name, r.first_name ';
852:
853: l_sql_statement2 := l_sql_statement2 ||fnd_global.local_chr(10)||l_where_clause;
854: IF (G_DEBUG = TRUE) THEN
855: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(l_sql_statement);

Line 853: l_sql_statement2 := l_sql_statement2 ||fnd_global.local_chr(10)||l_where_clause;

849: END IF;
850: l_sql_statement := l_sql_statement ||fnd_global.local_chr(10)||
851: l_where_clause ||fnd_global.local_chr(10)|| 'ORDER BY r.last_name, r.first_name ';
852:
853: l_sql_statement2 := l_sql_statement2 ||fnd_global.local_chr(10)||l_where_clause;
854: IF (G_DEBUG = TRUE) THEN
855: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(l_sql_statement);
856: END IF;
857: --Execute the SQL statements to get the total count: