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 2831: l_cursorid := dbms_sql.open_cursor;

2827:
2828: -- Fix for Bug#3776819 - Derive employee id
2829: -- Use Dynamic SQL to execute the HR API to derive the person id
2830: begin
2831: l_cursorid := dbms_sql.open_cursor;
2832: l_blockstr :=
2833: 'BEGIN
2834: hr_tca_utility.get_person_id(p_party_id => :l_party_id, p_person_id => :l_person_id, p_matches => :l_matches);
2835: END;';

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

2833: 'BEGIN
2834: hr_tca_utility.get_person_id(p_party_id => :l_party_id, p_person_id => :l_person_id, p_matches => :l_matches);
2835: END;';
2836:
2837: dbms_sql.parse(l_cursorid, l_blockstr, dbms_sql.v7);
2838:
2839: dbms_sql.bind_variable(l_cursorid, ':l_party_id', l_person_party_id);
2840: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
2841: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);

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

2835: END;';
2836:
2837: dbms_sql.parse(l_cursorid, l_blockstr, dbms_sql.v7);
2838:
2839: dbms_sql.bind_variable(l_cursorid, ':l_party_id', l_person_party_id);
2840: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
2841: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
2842:
2843: l_dummy := dbms_sql.execute(l_cursorid);

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

2836:
2837: dbms_sql.parse(l_cursorid, l_blockstr, dbms_sql.v7);
2838:
2839: dbms_sql.bind_variable(l_cursorid, ':l_party_id', l_person_party_id);
2840: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
2841: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
2842:
2843: l_dummy := dbms_sql.execute(l_cursorid);
2844:

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

2837: dbms_sql.parse(l_cursorid, l_blockstr, dbms_sql.v7);
2838:
2839: dbms_sql.bind_variable(l_cursorid, ':l_party_id', l_person_party_id);
2840: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
2841: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
2842:
2843: l_dummy := dbms_sql.execute(l_cursorid);
2844:
2845: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);

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

2839: dbms_sql.bind_variable(l_cursorid, ':l_party_id', l_person_party_id);
2840: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
2841: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
2842:
2843: l_dummy := dbms_sql.execute(l_cursorid);
2844:
2845: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);
2846: dbms_sql.variable_value(l_cursorid, ':l_matches', l_matches);
2847: dbms_sql.close_cursor(l_cursorid);

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

2841: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
2842:
2843: l_dummy := dbms_sql.execute(l_cursorid);
2844:
2845: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);
2846: dbms_sql.variable_value(l_cursorid, ':l_matches', l_matches);
2847: dbms_sql.close_cursor(l_cursorid);
2848:
2849: -- Set the employee id

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

2842:
2843: l_dummy := dbms_sql.execute(l_cursorid);
2844:
2845: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);
2846: dbms_sql.variable_value(l_cursorid, ':l_matches', l_matches);
2847: dbms_sql.close_cursor(l_cursorid);
2848:
2849: -- Set the employee id
2850: if (l_person_id is not null) then

Line 2847: dbms_sql.close_cursor(l_cursorid);

2843: l_dummy := dbms_sql.execute(l_cursorid);
2844:
2845: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);
2846: dbms_sql.variable_value(l_cursorid, ':l_matches', l_matches);
2847: dbms_sql.close_cursor(l_cursorid);
2848:
2849: -- Set the employee id
2850: if (l_person_id is not null) then
2851: l_employee_id := l_person_id;

Line 2863: dbms_sql.close_cursor(l_cursorid);

2859:
2860: exception
2861: when others then
2862: l_employee_id := null;
2863: dbms_sql.close_cursor(l_cursorid);
2864: end;
2865:
2866: -- Return
2867: customer_id := l_customer_id;