APPS.HR_ENTRY dependencies on DBMS_SQL

Line 5741: sql_curs := dbms_sql.open_cursor;

5737: if g_debug then
5738: hr_utility.set_location('hr_entry.maintain_cost_keyflex', 2);
5739: end if;
5740: --
5741: sql_curs := dbms_sql.open_cursor;
5742: --
5743: dbms_sql.parse(sql_curs,
5744: statem,
5745: dbms_sql.v7);

Line 5743: dbms_sql.parse(sql_curs,

5739: end if;
5740: --
5741: sql_curs := dbms_sql.open_cursor;
5742: --
5743: dbms_sql.parse(sql_curs,
5744: statem,
5745: dbms_sql.v7);
5746: --
5747: dbms_sql.bind_variable(sql_curs, 'p_cost_keyflex_structure', p_cost_keyflex_structure);

Line 5745: dbms_sql.v7);

5741: sql_curs := dbms_sql.open_cursor;
5742: --
5743: dbms_sql.parse(sql_curs,
5744: statem,
5745: dbms_sql.v7);
5746: --
5747: dbms_sql.bind_variable(sql_curs, 'p_cost_keyflex_structure', p_cost_keyflex_structure);
5748: --
5749: for i in 1..30 loop

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

5743: dbms_sql.parse(sql_curs,
5744: statem,
5745: dbms_sql.v7);
5746: --
5747: dbms_sql.bind_variable(sql_curs, 'p_cost_keyflex_structure', p_cost_keyflex_structure);
5748: --
5749: for i in 1..30 loop
5750: if segment(i) is not null then
5751: dbms_sql.bind_variable(sql_curs, 'p_segment'||i, segment(i));

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

5747: dbms_sql.bind_variable(sql_curs, 'p_cost_keyflex_structure', p_cost_keyflex_structure);
5748: --
5749: for i in 1..30 loop
5750: if segment(i) is not null then
5751: dbms_sql.bind_variable(sql_curs, 'p_segment'||i, segment(i));
5752: end if;
5753: end loop;
5754: dbms_sql.define_column(sql_curs, 1, l_cost_allocation_keyflex_id);
5755: --

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

5750: if segment(i) is not null then
5751: dbms_sql.bind_variable(sql_curs, 'p_segment'||i, segment(i));
5752: end if;
5753: end loop;
5754: dbms_sql.define_column(sql_curs, 1, l_cost_allocation_keyflex_id);
5755: --
5756: if g_debug then
5757: hr_utility.set_location('hr_entry.maintain_cost_keyflex', 3);
5758: end if;

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

5756: if g_debug then
5757: hr_utility.set_location('hr_entry.maintain_cost_keyflex', 3);
5758: end if;
5759: --
5760: rows_processed := dbms_sql.execute(sql_curs);
5761: --
5762: if g_debug then
5763: hr_utility.set_location('hr_entry.maintain_cost_keyflex ', 4);
5764: end if;

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

5762: if g_debug then
5763: hr_utility.set_location('hr_entry.maintain_cost_keyflex ', 4);
5764: end if;
5765: --
5766: if dbms_sql.fetch_rows(sql_curs) > 0 then
5767: --
5768: if g_debug then
5769: hr_utility.set_location('hr_entry.maintain_cost_keyflex', 5);
5770: end if;

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

5767: --
5768: if g_debug then
5769: hr_utility.set_location('hr_entry.maintain_cost_keyflex', 5);
5770: end if;
5771: dbms_sql.column_value(sql_curs, 1, l_cost_allocation_keyflex_id);
5772: --
5773: if (l_cost_allocation_keyflex_id is null)
5774: then
5775: if g_debug then

Line 5787: dbms_sql.close_cursor(sql_curs);

5783: end if;
5784: l_cost_allocation_keyflex_id := -1;
5785: end if;
5786: --
5787: dbms_sql.close_cursor(sql_curs);
5788: --
5789: --
5790: -- Check to see if the cost allocation keyflex combination already
5791: -- exists.