APPS.HR_ENTRY dependencies on DBMS_SQL

Line 5352: sql_curs := dbms_sql.open_cursor;

5348: if g_debug then
5349: hr_utility.set_location('hr_entry.maintain_cost_keyflex', 2);
5350: end if;
5351: --
5352: sql_curs := dbms_sql.open_cursor;
5353: --
5354: dbms_sql.parse(sql_curs,
5355: statem,
5356: dbms_sql.v7);

Line 5354: dbms_sql.parse(sql_curs,

5350: end if;
5351: --
5352: sql_curs := dbms_sql.open_cursor;
5353: --
5354: dbms_sql.parse(sql_curs,
5355: statem,
5356: dbms_sql.v7);
5357: --
5358: dbms_sql.bind_variable(sql_curs, 'p_cost_keyflex_structure', p_cost_keyflex_structure);

Line 5356: dbms_sql.v7);

5352: sql_curs := dbms_sql.open_cursor;
5353: --
5354: dbms_sql.parse(sql_curs,
5355: statem,
5356: dbms_sql.v7);
5357: --
5358: dbms_sql.bind_variable(sql_curs, 'p_cost_keyflex_structure', p_cost_keyflex_structure);
5359: --
5360: for i in 1..30 loop

Line 5358: dbms_sql.bind_variable(sql_curs, 'p_cost_keyflex_structure', p_cost_keyflex_structure);

5354: dbms_sql.parse(sql_curs,
5355: statem,
5356: dbms_sql.v7);
5357: --
5358: dbms_sql.bind_variable(sql_curs, 'p_cost_keyflex_structure', p_cost_keyflex_structure);
5359: --
5360: for i in 1..30 loop
5361: if segment(i) is not null then
5362: dbms_sql.bind_variable(sql_curs, 'p_segment'||i, segment(i));

Line 5362: dbms_sql.bind_variable(sql_curs, 'p_segment'||i, segment(i));

5358: dbms_sql.bind_variable(sql_curs, 'p_cost_keyflex_structure', p_cost_keyflex_structure);
5359: --
5360: for i in 1..30 loop
5361: if segment(i) is not null then
5362: dbms_sql.bind_variable(sql_curs, 'p_segment'||i, segment(i));
5363: end if;
5364: end loop;
5365: dbms_sql.define_column(sql_curs, 1, l_cost_allocation_keyflex_id);
5366: --

Line 5365: dbms_sql.define_column(sql_curs, 1, l_cost_allocation_keyflex_id);

5361: if segment(i) is not null then
5362: dbms_sql.bind_variable(sql_curs, 'p_segment'||i, segment(i));
5363: end if;
5364: end loop;
5365: dbms_sql.define_column(sql_curs, 1, l_cost_allocation_keyflex_id);
5366: --
5367: if g_debug then
5368: hr_utility.set_location('hr_entry.maintain_cost_keyflex', 3);
5369: end if;

Line 5371: rows_processed := dbms_sql.execute(sql_curs);

5367: if g_debug then
5368: hr_utility.set_location('hr_entry.maintain_cost_keyflex', 3);
5369: end if;
5370: --
5371: rows_processed := dbms_sql.execute(sql_curs);
5372: --
5373: if g_debug then
5374: hr_utility.set_location('hr_entry.maintain_cost_keyflex ', 4);
5375: end if;

Line 5377: if dbms_sql.fetch_rows(sql_curs) > 0 then

5373: if g_debug then
5374: hr_utility.set_location('hr_entry.maintain_cost_keyflex ', 4);
5375: end if;
5376: --
5377: if dbms_sql.fetch_rows(sql_curs) > 0 then
5378: --
5379: if g_debug then
5380: hr_utility.set_location('hr_entry.maintain_cost_keyflex', 5);
5381: end if;

Line 5382: dbms_sql.column_value(sql_curs, 1, l_cost_allocation_keyflex_id);

5378: --
5379: if g_debug then
5380: hr_utility.set_location('hr_entry.maintain_cost_keyflex', 5);
5381: end if;
5382: dbms_sql.column_value(sql_curs, 1, l_cost_allocation_keyflex_id);
5383: --
5384: if (l_cost_allocation_keyflex_id is null)
5385: then
5386: if g_debug then

Line 5398: dbms_sql.close_cursor(sql_curs);

5394: end if;
5395: l_cost_allocation_keyflex_id := -1;
5396: end if;
5397: --
5398: dbms_sql.close_cursor(sql_curs);
5399: --
5400: --
5401: -- Check to see if the cost allocation keyflex combination already
5402: -- exists.