APPS.UMX_REGISTRATION_PVT dependencies on DBMS_SQL

Line 1337: l_cursorid := dbms_sql.open_cursor;

1333:
1334: -- Use dynamamic SQL - Bug 4653519
1335: begin -- Outer Begin
1336: begin -- Inner begin for dynamic SQL
1337: l_cursorid := dbms_sql.open_cursor;
1338: l_blockstr :=
1339: 'BEGIN
1340: hr_tca_utility.get_person_id(p_party_id => :l_party_id,
1341: p_person_id => :l_person_id,

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

1341: p_person_id => :l_person_id,
1342: p_matches => :l_matches);
1343: END;';
1344:
1345: dbms_sql.parse(l_cursorid, l_blockstr, dbms_sql.v7);
1346:
1347: dbms_sql.bind_variable(l_cursorid, ':l_party_id', p_party_id);
1348: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
1349: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);

Line 1347: dbms_sql.bind_variable(l_cursorid, ':l_party_id', p_party_id);

1343: END;';
1344:
1345: dbms_sql.parse(l_cursorid, l_blockstr, dbms_sql.v7);
1346:
1347: dbms_sql.bind_variable(l_cursorid, ':l_party_id', p_party_id);
1348: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
1349: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
1350:
1351: l_dummy := dbms_sql.execute(l_cursorid);

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

1344:
1345: dbms_sql.parse(l_cursorid, l_blockstr, dbms_sql.v7);
1346:
1347: dbms_sql.bind_variable(l_cursorid, ':l_party_id', p_party_id);
1348: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
1349: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
1350:
1351: l_dummy := dbms_sql.execute(l_cursorid);
1352:

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

1345: dbms_sql.parse(l_cursorid, l_blockstr, dbms_sql.v7);
1346:
1347: dbms_sql.bind_variable(l_cursorid, ':l_party_id', p_party_id);
1348: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
1349: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
1350:
1351: l_dummy := dbms_sql.execute(l_cursorid);
1352:
1353: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);

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

1347: dbms_sql.bind_variable(l_cursorid, ':l_party_id', p_party_id);
1348: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
1349: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
1350:
1351: l_dummy := dbms_sql.execute(l_cursorid);
1352:
1353: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);
1354: dbms_sql.variable_value(l_cursorid, ':l_matches', l_matches);
1355: dbms_sql.close_cursor(l_cursorid);

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

1349: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
1350:
1351: l_dummy := dbms_sql.execute(l_cursorid);
1352:
1353: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);
1354: dbms_sql.variable_value(l_cursorid, ':l_matches', l_matches);
1355: dbms_sql.close_cursor(l_cursorid);
1356:
1357: exception

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

1350:
1351: l_dummy := dbms_sql.execute(l_cursorid);
1352:
1353: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);
1354: dbms_sql.variable_value(l_cursorid, ':l_matches', l_matches);
1355: dbms_sql.close_cursor(l_cursorid);
1356:
1357: exception
1358: when others then

Line 1355: dbms_sql.close_cursor(l_cursorid);

1351: l_dummy := dbms_sql.execute(l_cursorid);
1352:
1353: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);
1354: dbms_sql.variable_value(l_cursorid, ':l_matches', l_matches);
1355: dbms_sql.close_cursor(l_cursorid);
1356:
1357: exception
1358: when others then
1359: l_person_id := null;

Line 1360: dbms_sql.close_cursor(l_cursorid);

1356:
1357: exception
1358: when others then
1359: l_person_id := null;
1360: dbms_sql.close_cursor(l_cursorid);
1361: end;
1362: return l_person_id;
1363: end GET_PERSON_ID;
1364: