APPS.PNRX_SP_UTIL_BY_LOC dependencies on PN_SPACE_UTIL_LOC_ITF

Line 101: FROM pn_space_util_loc_itf

97: CURSOR c_check IS
98: SELECT 'Y'
99: FROM dual
100: WHERE EXISTS (SELECT null
101: FROM pn_space_util_loc_itf
102: WHERE location_id = V_LOCATION_ID
103: AND request_id = l_request_id);
104:
105: BEGIN

Line 398: pnp_debug_pkg.log(' bfore insert into pn_space_util_loc_itf ');

394: dbms_sql.column_value (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
395: dbms_sql.column_value (l_cursor_2, 31,V_CREATION_DATE);
396: dbms_sql.column_value (l_cursor_2, 32,V_CREATED_BY);
397:
398: pnp_debug_pkg.log(' bfore insert into pn_space_util_loc_itf ');
399: v_code_data := pnp_util_func.get_location_name(V_LOCATION_ID, as_of_date);
400:
401: /* Before inserting, check to see whether the record already exists in the table */
402:

Line 410: INSERT INTO pn_space_util_loc_itf

406: CLOSE c_check;
407:
408: IF l_found = 'N' then
409:
410: INSERT INTO pn_space_util_loc_itf
411: (LOCATION_ID ,
412: LOCATION_TYPE ,
413: LOCATION_NAME ,
414: LOCATION_CODE ,