[Home] [Help]
102: WHERE location_id = V_LOCATION_ID
103: AND request_id = l_request_id);
104:
105: BEGIN
106: pnp_debug_pkg.put_log_msg('PNRXULOB: pn_sp_util_locConditions(+)');
107: --Initialise status parameters...
108: retcode:=0;
109: errbuf:='';
110: fnd_profile.get('LOGIN_ID', l_login_id);
178: l_statement || ' AND 3 = 3 ';
179:
180: END IF;
181:
182: pnp_debug_pkg.log('l_statement:'||l_statement);
183:
184: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
185:
186: dbms_sql.bind_variable
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:
504:
505: END IF;
506:
507: END LOOP;
508: pnp_debug_pkg.put_log_msg('PNRXULOB: c_pn: c_util_loc Loop (-)');
509:
510: IF dbms_sql.is_open (l_cursor_2) THEN
511: dbms_sql.close_cursor (l_cursor_2);
512: END IF;
511: dbms_sql.close_cursor (l_cursor_2);
512: END IF;
513:
514: END LOOP;
515: pnp_debug_pkg.put_log_msg('PNRXULOB: c_pn Loop (-)');
516:
517: IF dbms_sql.is_open (l_cursor) THEN
518: dbms_sql.close_cursor (l_cursor);
519: END IF;
519: END IF;
520:
521: COMMIT;
522: --If there is something amiss...
523: pnp_debug_pkg.put_log_msg('PNRXULOB: pn_sp_util_locConditions(-)');
524:
525: EXCEPTION
526: WHEN OTHERS THEN
527: retcode:=2;