eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_WORKFLOW_SERVICE dependencies on DBMS_SQL

Line 1082: l_cursor_name := dbms_sql.open_cursor;

1078: l_row_processed integer;
1079: --
1080: begin
1081: l_sqlbuf := 'begin ' || p_procedure_name || ' (:v1,:v2,:v3); end;';
1082: l_cursor_name := dbms_sql.open_cursor;
1083: dbms_sql.parse(l_cursor_name, l_sqlbuf, dbms_sql.v7);
1084: dbms_sql.bind_variable(l_cursor_name, ':v1', p_item_type);
1085: dbms_sql.bind_variable(l_cursor_name, ':v2', p_item_key);
1086: dbms_sql.bind_variable(l_cursor_name, ':v3', p_actid);

Line 1083: dbms_sql.parse(l_cursor_name, l_sqlbuf, dbms_sql.v7);

1079: --
1080: begin
1081: l_sqlbuf := 'begin ' || p_procedure_name || ' (:v1,:v2,:v3); end;';
1082: l_cursor_name := dbms_sql.open_cursor;
1083: dbms_sql.parse(l_cursor_name, l_sqlbuf, dbms_sql.v7);
1084: dbms_sql.bind_variable(l_cursor_name, ':v1', p_item_type);
1085: dbms_sql.bind_variable(l_cursor_name, ':v2', p_item_key);
1086: dbms_sql.bind_variable(l_cursor_name, ':v3', p_actid);
1087: l_row_processed := dbms_sql.execute(l_cursor_name);

Line 1084: dbms_sql.bind_variable(l_cursor_name, ':v1', p_item_type);

1080: begin
1081: l_sqlbuf := 'begin ' || p_procedure_name || ' (:v1,:v2,:v3); end;';
1082: l_cursor_name := dbms_sql.open_cursor;
1083: dbms_sql.parse(l_cursor_name, l_sqlbuf, dbms_sql.v7);
1084: dbms_sql.bind_variable(l_cursor_name, ':v1', p_item_type);
1085: dbms_sql.bind_variable(l_cursor_name, ':v2', p_item_key);
1086: dbms_sql.bind_variable(l_cursor_name, ':v3', p_actid);
1087: l_row_processed := dbms_sql.execute(l_cursor_name);
1088: dbms_sql.close_cursor(l_cursor_name);

Line 1085: dbms_sql.bind_variable(l_cursor_name, ':v2', p_item_key);

1081: l_sqlbuf := 'begin ' || p_procedure_name || ' (:v1,:v2,:v3); end;';
1082: l_cursor_name := dbms_sql.open_cursor;
1083: dbms_sql.parse(l_cursor_name, l_sqlbuf, dbms_sql.v7);
1084: dbms_sql.bind_variable(l_cursor_name, ':v1', p_item_type);
1085: dbms_sql.bind_variable(l_cursor_name, ':v2', p_item_key);
1086: dbms_sql.bind_variable(l_cursor_name, ':v3', p_actid);
1087: l_row_processed := dbms_sql.execute(l_cursor_name);
1088: dbms_sql.close_cursor(l_cursor_name);
1089: exception

Line 1086: dbms_sql.bind_variable(l_cursor_name, ':v3', p_actid);

1082: l_cursor_name := dbms_sql.open_cursor;
1083: dbms_sql.parse(l_cursor_name, l_sqlbuf, dbms_sql.v7);
1084: dbms_sql.bind_variable(l_cursor_name, ':v1', p_item_type);
1085: dbms_sql.bind_variable(l_cursor_name, ':v2', p_item_key);
1086: dbms_sql.bind_variable(l_cursor_name, ':v3', p_actid);
1087: l_row_processed := dbms_sql.execute(l_cursor_name);
1088: dbms_sql.close_cursor(l_cursor_name);
1089: exception
1090: when OTHERS then

Line 1087: l_row_processed := dbms_sql.execute(l_cursor_name);

1083: dbms_sql.parse(l_cursor_name, l_sqlbuf, dbms_sql.v7);
1084: dbms_sql.bind_variable(l_cursor_name, ':v1', p_item_type);
1085: dbms_sql.bind_variable(l_cursor_name, ':v2', p_item_key);
1086: dbms_sql.bind_variable(l_cursor_name, ':v3', p_actid);
1087: l_row_processed := dbms_sql.execute(l_cursor_name);
1088: dbms_sql.close_cursor(l_cursor_name);
1089: exception
1090: when OTHERS then
1091: -- supply HR error message

Line 1088: dbms_sql.close_cursor(l_cursor_name);

1084: dbms_sql.bind_variable(l_cursor_name, ':v1', p_item_type);
1085: dbms_sql.bind_variable(l_cursor_name, ':v2', p_item_key);
1086: dbms_sql.bind_variable(l_cursor_name, ':v3', p_actid);
1087: l_row_processed := dbms_sql.execute(l_cursor_name);
1088: dbms_sql.close_cursor(l_cursor_name);
1089: exception
1090: when OTHERS then
1091: -- supply HR error message
1092: -- an error has occurred when attempting to call the stored procedure