DBA Data[Home] [Help]

APPS.HR_SUMMARY_UTIL dependencies on DBMS_SQL

Line 406: source_cursor := dbms_sql.open_cursor;

402: ' and cgr.cagr_grade_structure_id = cgs.cagr_grade_structure_id'||
403: ' and cgs.collective_agreement_id = cag.collective_agreement_id'||
404: ' and cag.business_group_id = '||to_char(g_business_group_id);
405: --
406: source_cursor := dbms_sql.open_cursor;
407: dbms_sql.parse(source_cursor,l_stmt,dbms_sql.v7);
408: dbms_sql.define_column(source_cursor,1,l_key_value,80);
409: ignore := dbms_sql.execute(source_cursor);
410: --

Line 407: dbms_sql.parse(source_cursor,l_stmt,dbms_sql.v7);

403: ' and cgs.collective_agreement_id = cag.collective_agreement_id'||
404: ' and cag.business_group_id = '||to_char(g_business_group_id);
405: --
406: source_cursor := dbms_sql.open_cursor;
407: dbms_sql.parse(source_cursor,l_stmt,dbms_sql.v7);
408: dbms_sql.define_column(source_cursor,1,l_key_value,80);
409: ignore := dbms_sql.execute(source_cursor);
410: --
411: loop

Line 408: dbms_sql.define_column(source_cursor,1,l_key_value,80);

404: ' and cag.business_group_id = '||to_char(g_business_group_id);
405: --
406: source_cursor := dbms_sql.open_cursor;
407: dbms_sql.parse(source_cursor,l_stmt,dbms_sql.v7);
408: dbms_sql.define_column(source_cursor,1,l_key_value,80);
409: ignore := dbms_sql.execute(source_cursor);
410: --
411: loop
412: if dbms_sql.fetch_rows(source_cursor) > 0 then

Line 409: ignore := dbms_sql.execute(source_cursor);

405: --
406: source_cursor := dbms_sql.open_cursor;
407: dbms_sql.parse(source_cursor,l_stmt,dbms_sql.v7);
408: dbms_sql.define_column(source_cursor,1,l_key_value,80);
409: ignore := dbms_sql.execute(source_cursor);
410: --
411: loop
412: if dbms_sql.fetch_rows(source_cursor) > 0 then
413: dbms_sql.column_value(source_cursor,1,l_key_value);

Line 412: if dbms_sql.fetch_rows(source_cursor) > 0 then

408: dbms_sql.define_column(source_cursor,1,l_key_value,80);
409: ignore := dbms_sql.execute(source_cursor);
410: --
411: loop
412: if dbms_sql.fetch_rows(source_cursor) > 0 then
413: dbms_sql.column_value(source_cursor,1,l_key_value);
414: if store_data then
415: hr_summary_api.create_key_value(p_key_value_id => l_key_value_id
416: ,p_business_group_id => g_business_group_id

Line 413: dbms_sql.column_value(source_cursor,1,l_key_value);

409: ignore := dbms_sql.execute(source_cursor);
410: --
411: loop
412: if dbms_sql.fetch_rows(source_cursor) > 0 then
413: dbms_sql.column_value(source_cursor,1,l_key_value);
414: if store_data then
415: hr_summary_api.create_key_value(p_key_value_id => l_key_value_id
416: ,p_business_group_id => g_business_group_id
417: ,p_object_version_number => l_object_version_number

Line 426: dbms_sql.close_cursor(source_cursor);

422: else
423: exit;
424: end if;
425: end loop;
426: dbms_sql.close_cursor(source_cursor);
427: --
428: end loop;
429: --
430: if l_clause is null then

Line 460: source_cursor := dbms_sql.open_cursor;

456: --
457: for i in 1..12 loop
458: l_stmt := 'select to_char(to_date('||''''||'1999'||lpad(to_char(i),2,'0')||'01'||''''||',''YYYYMMDD''),''MON'') from dual';
459: --
460: source_cursor := dbms_sql.open_cursor;
461: dbms_sql.parse(source_cursor,l_stmt,dbms_sql.v7);
462: dbms_sql.define_column(source_cursor,1,l_key_value,80);
463: ignore := dbms_sql.execute(source_cursor);
464: --

Line 461: dbms_sql.parse(source_cursor,l_stmt,dbms_sql.v7);

457: for i in 1..12 loop
458: l_stmt := 'select to_char(to_date('||''''||'1999'||lpad(to_char(i),2,'0')||'01'||''''||',''YYYYMMDD''),''MON'') from dual';
459: --
460: source_cursor := dbms_sql.open_cursor;
461: dbms_sql.parse(source_cursor,l_stmt,dbms_sql.v7);
462: dbms_sql.define_column(source_cursor,1,l_key_value,80);
463: ignore := dbms_sql.execute(source_cursor);
464: --
465: if dbms_sql.fetch_rows(source_cursor) > 0 then

Line 462: dbms_sql.define_column(source_cursor,1,l_key_value,80);

458: l_stmt := 'select to_char(to_date('||''''||'1999'||lpad(to_char(i),2,'0')||'01'||''''||',''YYYYMMDD''),''MON'') from dual';
459: --
460: source_cursor := dbms_sql.open_cursor;
461: dbms_sql.parse(source_cursor,l_stmt,dbms_sql.v7);
462: dbms_sql.define_column(source_cursor,1,l_key_value,80);
463: ignore := dbms_sql.execute(source_cursor);
464: --
465: if dbms_sql.fetch_rows(source_cursor) > 0 then
466: dbms_sql.column_value(source_cursor,1,l_key_value);

Line 463: ignore := dbms_sql.execute(source_cursor);

459: --
460: source_cursor := dbms_sql.open_cursor;
461: dbms_sql.parse(source_cursor,l_stmt,dbms_sql.v7);
462: dbms_sql.define_column(source_cursor,1,l_key_value,80);
463: ignore := dbms_sql.execute(source_cursor);
464: --
465: if dbms_sql.fetch_rows(source_cursor) > 0 then
466: dbms_sql.column_value(source_cursor,1,l_key_value);
467: end if;

Line 465: if dbms_sql.fetch_rows(source_cursor) > 0 then

461: dbms_sql.parse(source_cursor,l_stmt,dbms_sql.v7);
462: dbms_sql.define_column(source_cursor,1,l_key_value,80);
463: ignore := dbms_sql.execute(source_cursor);
464: --
465: if dbms_sql.fetch_rows(source_cursor) > 0 then
466: dbms_sql.column_value(source_cursor,1,l_key_value);
467: end if;
468: if store_data then
469: hr_summary_api.create_key_value(p_key_value_id => l_key_value_id

Line 466: dbms_sql.column_value(source_cursor,1,l_key_value);

462: dbms_sql.define_column(source_cursor,1,l_key_value,80);
463: ignore := dbms_sql.execute(source_cursor);
464: --
465: if dbms_sql.fetch_rows(source_cursor) > 0 then
466: dbms_sql.column_value(source_cursor,1,l_key_value);
467: end if;
468: if store_data then
469: hr_summary_api.create_key_value(p_key_value_id => l_key_value_id
470: ,p_business_group_id => g_business_group_id

Line 477: dbms_sql.close_cursor(source_cursor);

473: ,p_item_value_id => zero_item_value_id
474: ,p_name => l_key_value);
475: end if;
476: end loop;
477: dbms_sql.close_cursor(source_cursor);
478: --
479: hr_utility.set_location('Leaving: hr_summary_util.get_month', 20);
480: --
481: return l_month;