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.FND_USER_PKG dependencies on DBMS_SQL

Line 3438: l_cursorid := dbms_sql.open_cursor;

3434:
3435: -- Fix for Bug#3776819 - Derive employee id
3436: -- Use Dynamic SQL to execute the HR API to derive the person id
3437: begin
3438: l_cursorid := dbms_sql.open_cursor;
3439: l_blockstr :=
3440: 'BEGIN
3441: hr_tca_utility.get_person_id(p_party_id => :l_party_id, p_person_id => :l_person_id, p_matches => :l_matches);
3442: END;';

Line 3444: dbms_sql.parse(l_cursorid, l_blockstr, dbms_sql.v7);

3440: 'BEGIN
3441: hr_tca_utility.get_person_id(p_party_id => :l_party_id, p_person_id => :l_person_id, p_matches => :l_matches);
3442: END;';
3443:
3444: dbms_sql.parse(l_cursorid, l_blockstr, dbms_sql.v7);
3445:
3446: dbms_sql.bind_variable(l_cursorid, ':l_party_id', l_person_party_id);
3447: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
3448: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);

Line 3446: dbms_sql.bind_variable(l_cursorid, ':l_party_id', l_person_party_id);

3442: END;';
3443:
3444: dbms_sql.parse(l_cursorid, l_blockstr, dbms_sql.v7);
3445:
3446: dbms_sql.bind_variable(l_cursorid, ':l_party_id', l_person_party_id);
3447: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
3448: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
3449:
3450: l_dummy := dbms_sql.execute(l_cursorid);

Line 3447: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);

3443:
3444: dbms_sql.parse(l_cursorid, l_blockstr, dbms_sql.v7);
3445:
3446: dbms_sql.bind_variable(l_cursorid, ':l_party_id', l_person_party_id);
3447: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
3448: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
3449:
3450: l_dummy := dbms_sql.execute(l_cursorid);
3451:

Line 3448: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);

3444: dbms_sql.parse(l_cursorid, l_blockstr, dbms_sql.v7);
3445:
3446: dbms_sql.bind_variable(l_cursorid, ':l_party_id', l_person_party_id);
3447: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
3448: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
3449:
3450: l_dummy := dbms_sql.execute(l_cursorid);
3451:
3452: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);

Line 3450: l_dummy := dbms_sql.execute(l_cursorid);

3446: dbms_sql.bind_variable(l_cursorid, ':l_party_id', l_person_party_id);
3447: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
3448: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
3449:
3450: l_dummy := dbms_sql.execute(l_cursorid);
3451:
3452: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);
3453: dbms_sql.variable_value(l_cursorid, ':l_matches', l_matches);
3454: dbms_sql.close_cursor(l_cursorid);

Line 3452: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);

3448: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
3449:
3450: l_dummy := dbms_sql.execute(l_cursorid);
3451:
3452: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);
3453: dbms_sql.variable_value(l_cursorid, ':l_matches', l_matches);
3454: dbms_sql.close_cursor(l_cursorid);
3455:
3456: -- Set the employee id

Line 3453: dbms_sql.variable_value(l_cursorid, ':l_matches', l_matches);

3449:
3450: l_dummy := dbms_sql.execute(l_cursorid);
3451:
3452: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);
3453: dbms_sql.variable_value(l_cursorid, ':l_matches', l_matches);
3454: dbms_sql.close_cursor(l_cursorid);
3455:
3456: -- Set the employee id
3457: if (l_person_id is not null) then

Line 3454: dbms_sql.close_cursor(l_cursorid);

3450: l_dummy := dbms_sql.execute(l_cursorid);
3451:
3452: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);
3453: dbms_sql.variable_value(l_cursorid, ':l_matches', l_matches);
3454: dbms_sql.close_cursor(l_cursorid);
3455:
3456: -- Set the employee id
3457: if (l_person_id is not null) then
3458: l_employee_id := l_person_id;

Line 3470: dbms_sql.close_cursor(l_cursorid);

3466:
3467: exception
3468: when others then
3469: l_employee_id := null;
3470: dbms_sql.close_cursor(l_cursorid);
3471: end;
3472:
3473: -- Return
3474: customer_id := l_customer_id;