APPS.UMX_REGISTRATION_PVT dependencies on DBMS_SQL

Line 1352: l_cursorid := dbms_sql.open_cursor;

1348:
1349: -- Use dynamamic SQL - Bug 4653519
1350: begin -- Outer Begin
1351: begin -- Inner begin for dynamic SQL
1352: l_cursorid := dbms_sql.open_cursor;
1353: l_blockstr :=
1354: 'BEGIN
1355: hr_tca_utility.get_person_id(p_party_id => :l_party_id,
1356: p_person_id => :l_person_id,

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

1356: p_person_id => :l_person_id,
1357: p_matches => :l_matches);
1358: END;';
1359:
1360: dbms_sql.parse(l_cursorid, l_blockstr, dbms_sql.v7);
1361:
1362: dbms_sql.bind_variable(l_cursorid, ':l_party_id', p_party_id);
1363: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
1364: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);

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

1358: END;';
1359:
1360: dbms_sql.parse(l_cursorid, l_blockstr, dbms_sql.v7);
1361:
1362: dbms_sql.bind_variable(l_cursorid, ':l_party_id', p_party_id);
1363: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
1364: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
1365:
1366: l_dummy := dbms_sql.execute(l_cursorid);

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

1359:
1360: dbms_sql.parse(l_cursorid, l_blockstr, dbms_sql.v7);
1361:
1362: dbms_sql.bind_variable(l_cursorid, ':l_party_id', p_party_id);
1363: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
1364: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
1365:
1366: l_dummy := dbms_sql.execute(l_cursorid);
1367:

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

1360: dbms_sql.parse(l_cursorid, l_blockstr, dbms_sql.v7);
1361:
1362: dbms_sql.bind_variable(l_cursorid, ':l_party_id', p_party_id);
1363: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
1364: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
1365:
1366: l_dummy := dbms_sql.execute(l_cursorid);
1367:
1368: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);

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

1362: dbms_sql.bind_variable(l_cursorid, ':l_party_id', p_party_id);
1363: dbms_sql.bind_variable(l_cursorid, ':l_person_id', l_person_id);
1364: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
1365:
1366: l_dummy := dbms_sql.execute(l_cursorid);
1367:
1368: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);
1369: dbms_sql.variable_value(l_cursorid, ':l_matches', l_matches);
1370: dbms_sql.close_cursor(l_cursorid);

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

1364: dbms_sql.bind_variable(l_cursorid, ':l_matches', l_matches, 1);
1365:
1366: l_dummy := dbms_sql.execute(l_cursorid);
1367:
1368: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);
1369: dbms_sql.variable_value(l_cursorid, ':l_matches', l_matches);
1370: dbms_sql.close_cursor(l_cursorid);
1371:
1372: exception

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

1365:
1366: l_dummy := dbms_sql.execute(l_cursorid);
1367:
1368: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);
1369: dbms_sql.variable_value(l_cursorid, ':l_matches', l_matches);
1370: dbms_sql.close_cursor(l_cursorid);
1371:
1372: exception
1373: when others then

Line 1370: dbms_sql.close_cursor(l_cursorid);

1366: l_dummy := dbms_sql.execute(l_cursorid);
1367:
1368: dbms_sql.variable_value(l_cursorid, ':l_person_id', l_person_id);
1369: dbms_sql.variable_value(l_cursorid, ':l_matches', l_matches);
1370: dbms_sql.close_cursor(l_cursorid);
1371:
1372: exception
1373: when others then
1374: l_person_id := null;

Line 1375: dbms_sql.close_cursor(l_cursorid);

1371:
1372: exception
1373: when others then
1374: l_person_id := null;
1375: dbms_sql.close_cursor(l_cursorid);
1376: end;
1377: return l_person_id;
1378: end GET_PERSON_ID;
1379: