APPS.PN_CAD_IMPORT dependencies on PN_EMP_SPACE_ASSIGN_ITF

Line 1689: FROM pn_emp_space_assign_itf spc

1685: l_total Number Default 0;
1686:
1687: CURSOR spacecur IS
1688: SELECT spc.*, spc.rowid
1689: FROM pn_emp_space_assign_itf spc
1690: WHERE spc.batch_name = p_batch_name
1691: AND spc.transferred_to_pn is null;
1692:
1693: tlempinfo pn_space_assign_emp_all%ROWTYPE;

Line 2299: -- Set pn_emp_space_assign_itf.transferred_to_pn = 'Y'

2295:
2296: End If;
2297:
2298: ------------------------------------------------
2299: -- Set pn_emp_space_assign_itf.transferred_to_pn = 'Y'
2300: ------------------------------------------------
2301:
2302: put_log('Updating transferred to pn flag in itf table');
2303:

Line 2304: update pn_emp_space_assign_itf

2300: ------------------------------------------------
2301:
2302: put_log('Updating transferred to pn flag in itf table');
2303:
2304: update pn_emp_space_assign_itf
2305: set transferred_to_pn = 'Y',
2306: error_message = NULL
2307: where ROWID = space.ROWID;
2308:

Line 2317: update pn_emp_space_assign_itf

2313: ROLLBACK TO S2;
2314: l_fail := l_fail + 1;
2315:
2316: -- Update ERROR_MESSAGE
2317: update pn_emp_space_assign_itf
2318: set error_message = substr(l_error_message, 1, 240)
2319: where ROWID = space.ROWID;
2320:
2321: -- Spool to Conc Log

Line 2334: update pn_emp_space_assign_itf

2330: l_fail := l_fail + 1;
2331:
2332: l_error_message := fnd_message.get;
2333:
2334: update pn_emp_space_assign_itf
2335: set error_message = substr(l_error_message, 1, 240)
2336: where ROWID = space.ROWID;
2337:
2338: put_line(l_error_message);