APPS.FF_ARCHIVE_UTILS dependencies on DBMS_SQL

Line 73: sql_curs := dbms_sql.open_cursor;

69:
70: hr_utility.trace('statem = ' || statem);
71: hr_utility.trace('length = ' || length(statem));
72:
73: sql_curs := dbms_sql.open_cursor;
74:
75: hr_utility.trace('sql_curs = ' || to_char(sql_curs));
76:
77: dbms_sql.parse(sql_curs,

Line 77: dbms_sql.parse(sql_curs,

73: sql_curs := dbms_sql.open_cursor;
74:
75: hr_utility.trace('sql_curs = ' || to_char(sql_curs));
76:
77: dbms_sql.parse(sql_curs,
78: statem,
79: dbms_sql.v7);
80:
81:

Line 79: dbms_sql.v7);

75: hr_utility.trace('sql_curs = ' || to_char(sql_curs));
76:
77: dbms_sql.parse(sql_curs,
78: statem,
79: dbms_sql.v7);
80:
81:
82: dbms_sql.define_column(sql_curs, 1, l_return_value, 50);
83:

Line 82: dbms_sql.define_column(sql_curs, 1, l_return_value, 50);

78: statem,
79: dbms_sql.v7);
80:
81:
82: dbms_sql.define_column(sql_curs, 1, l_return_value, 50);
83:
84: hr_utility.trace('p_context_value = ' || p_context_value);
85: hr_utility.trace('l_return_value = ' || l_return_value);
86:

Line 87: rows_processed := dbms_sql.execute_and_fetch(sql_curs);

83:
84: hr_utility.trace('p_context_value = ' || p_context_value);
85: hr_utility.trace('l_return_value = ' || l_return_value);
86:
87: rows_processed := dbms_sql.execute_and_fetch(sql_curs);
88:
89: dbms_sql.column_value(sql_curs,1, l_return_value);
90:
91: hr_utility.trace('rows_processed = ' || to_char(rows_processed));

Line 89: dbms_sql.column_value(sql_curs,1, l_return_value);

85: hr_utility.trace('l_return_value = ' || l_return_value);
86:
87: rows_processed := dbms_sql.execute_and_fetch(sql_curs);
88:
89: dbms_sql.column_value(sql_curs,1, l_return_value);
90:
91: hr_utility.trace('rows_processed = ' || to_char(rows_processed));
92: hr_utility.trace('l_return_value = ' || l_return_value);
93:

Line 94: dbms_sql.close_cursor(sql_curs);

90:
91: hr_utility.trace('rows_processed = ' || to_char(rows_processed));
92: hr_utility.trace('l_return_value = ' || l_return_value);
93:
94: dbms_sql.close_cursor(sql_curs);
95:
96: hr_utility.trace('l_return_value = ' || l_return_value);
97: return l_return_value;
98:

Line 101: if dbms_sql.is_open(sql_curs) then

97: return l_return_value;
98:
99: EXCEPTION WHEN OTHERS THEN
100:
101: if dbms_sql.is_open(sql_curs) then
102: dbms_sql.close_cursor(sql_curs);
103: end if;
104:
105: if p_context_name = 'TAX_UNIT_ID' then

Line 102: dbms_sql.close_cursor(sql_curs);

98:
99: EXCEPTION WHEN OTHERS THEN
100:
101: if dbms_sql.is_open(sql_curs) then
102: dbms_sql.close_cursor(sql_curs);
103: end if;
104:
105: if p_context_name = 'TAX_UNIT_ID' then
106: