eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PNRX_SP_ASSIGN_BY_LOC dependencies on DBMS_SQL

Line 189: l_cursor := dbms_sql.open_cursor;

185: FROM gl_sets_of_books
186: WHERE set_of_books_id= TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
187: pn_mo_cache_utils.get_current_org_id));
188:
189: l_cursor := dbms_sql.open_cursor;
190:
191: --property code conditions
192:
193: l_property_code_low := property_code_low;

Line 258: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);

254: ||property_code_where_clause||location_code_where_clause||location_type_where_clause;
255:
256:
257:
258: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);
259:
260: --------------------------------------
261: --property code conditions
262: IF property_code_low IS NOT NULL AND property_code_high IS NOT NULL THEN

Line 263: dbms_sql.bind_variable(l_cursor,'l_property_code_low',l_property_code_low);

259:
260: --------------------------------------
261: --property code conditions
262: IF property_code_low IS NOT NULL AND property_code_high IS NOT NULL THEN
263: dbms_sql.bind_variable(l_cursor,'l_property_code_low',l_property_code_low);
264: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);
265: ELSIF property_code_low IS NULL AND property_code_high IS NOT NULL THEN
266: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);
267: ELSIF property_code_low IS NOT NULL AND property_code_high IS NULL THEN

Line 264: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);

260: --------------------------------------
261: --property code conditions
262: IF property_code_low IS NOT NULL AND property_code_high IS NOT NULL THEN
263: dbms_sql.bind_variable(l_cursor,'l_property_code_low',l_property_code_low);
264: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);
265: ELSIF property_code_low IS NULL AND property_code_high IS NOT NULL THEN
266: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);
267: ELSIF property_code_low IS NOT NULL AND property_code_high IS NULL THEN
268: dbms_sql.bind_variable(l_cursor,'l_property_code_low',l_property_code_low);

Line 266: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);

262: IF property_code_low IS NOT NULL AND property_code_high IS NOT NULL THEN
263: dbms_sql.bind_variable(l_cursor,'l_property_code_low',l_property_code_low);
264: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);
265: ELSIF property_code_low IS NULL AND property_code_high IS NOT NULL THEN
266: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);
267: ELSIF property_code_low IS NOT NULL AND property_code_high IS NULL THEN
268: dbms_sql.bind_variable(l_cursor,'l_property_code_low',l_property_code_low);
269: END IF;
270:

Line 268: dbms_sql.bind_variable(l_cursor,'l_property_code_low',l_property_code_low);

264: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);
265: ELSIF property_code_low IS NULL AND property_code_high IS NOT NULL THEN
266: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);
267: ELSIF property_code_low IS NOT NULL AND property_code_high IS NULL THEN
268: dbms_sql.bind_variable(l_cursor,'l_property_code_low',l_property_code_low);
269: END IF;
270:
271:
272: --location code conditions.....

Line 274: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);

270:
271:
272: --location code conditions.....
273: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN
274: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
275: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
276: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
277: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
278: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN

Line 275: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);

271:
272: --location code conditions.....
273: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN
274: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
275: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
276: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
277: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
278: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN
279: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);

Line 277: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);

273: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN
274: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
275: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
276: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
277: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
278: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN
279: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
280: END IF;
281:

Line 279: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);

275: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
276: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
277: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
278: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN
279: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
280: END IF;
281:
282:
283: --location type conditions....

Line 285: dbms_sql.bind_variable(l_cursor,'l_location_type',l_location_type);

281:
282:
283: --location type conditions....
284: IF location_type IS NOT NULL THEN
285: dbms_sql.bind_variable(l_cursor,'l_location_type',l_location_type);
286: END IF;
287:
288: dbms_sql.define_column (l_cursor,1,v_location_id_1);
289: l_rows := dbms_sql.execute(l_cursor);

Line 288: dbms_sql.define_column (l_cursor,1,v_location_id_1);

284: IF location_type IS NOT NULL THEN
285: dbms_sql.bind_variable(l_cursor,'l_location_type',l_location_type);
286: END IF;
287:
288: dbms_sql.define_column (l_cursor,1,v_location_id_1);
289: l_rows := dbms_sql.execute(l_cursor);
290:
291: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locQuery(-)');
292: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locLoop(+)');

Line 289: l_rows := dbms_sql.execute(l_cursor);

285: dbms_sql.bind_variable(l_cursor,'l_location_type',l_location_type);
286: END IF;
287:
288: dbms_sql.define_column (l_cursor,1,v_location_id_1);
289: l_rows := dbms_sql.execute(l_cursor);
290:
291: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locQuery(-)');
292: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locLoop(+)');
293: LOOP

Line 294: l_count := dbms_sql.fetch_rows( l_cursor );

290:
291: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locQuery(-)');
292: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locLoop(+)');
293: LOOP
294: l_count := dbms_sql.fetch_rows( l_cursor );
295: EXIT WHEN l_count <> 1;
296:
297: dbms_sql.column_value(l_cursor,1,v_location_id_1);
298:

Line 297: dbms_sql.column_value(l_cursor,1,v_location_id_1);

293: LOOP
294: l_count := dbms_sql.fetch_rows( l_cursor );
295: EXIT WHEN l_count <> 1;
296:
297: dbms_sql.column_value(l_cursor,1,v_location_id_1);
298:
299: OPEN c_e_assign_pn FOR
300: SELECT DISTINCT
301: loc.location_id location_id,

Line 574: IF dbms_sql.is_open (l_cursor) THEN

570: END IF;
571: END LOOP;
572: END LOOP;
573: END LOOP;
574: IF dbms_sql.is_open (l_cursor) THEN
575: dbms_sql.close_cursor (l_cursor);
576: END IF;
577: COMMIT;
578: END IF;

Line 575: dbms_sql.close_cursor (l_cursor);

571: END LOOP;
572: END LOOP;
573: END LOOP;
574: IF dbms_sql.is_open (l_cursor) THEN
575: dbms_sql.close_cursor (l_cursor);
576: END IF;
577: COMMIT;
578: END IF;
579:

Line 589: IF NOT dbms_sql.is_open (l_cursor) THEN

585: FROM pn_locations loc,
586: pn_properties p
587: WHERE p.property_id(+) = loc.property_id '
588: ||property_code_where_clause||location_code_where_clause||location_type_where_clause;
589: IF NOT dbms_sql.is_open (l_cursor) THEN
590: l_cursor := dbms_sql.open_cursor;
591: END IF;
592: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);
593:

Line 590: l_cursor := dbms_sql.open_cursor;

586: pn_properties p
587: WHERE p.property_id(+) = loc.property_id '
588: ||property_code_where_clause||location_code_where_clause||location_type_where_clause;
589: IF NOT dbms_sql.is_open (l_cursor) THEN
590: l_cursor := dbms_sql.open_cursor;
591: END IF;
592: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);
593:
594: --------------------------------------

Line 592: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);

588: ||property_code_where_clause||location_code_where_clause||location_type_where_clause;
589: IF NOT dbms_sql.is_open (l_cursor) THEN
590: l_cursor := dbms_sql.open_cursor;
591: END IF;
592: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);
593:
594: --------------------------------------
595: --property code conditions
596: IF property_code_low IS NOT NULL AND property_code_high IS NOT NULL THEN

Line 597: dbms_sql.bind_variable(l_cursor,'l_property_code_low',l_property_code_low);

593:
594: --------------------------------------
595: --property code conditions
596: IF property_code_low IS NOT NULL AND property_code_high IS NOT NULL THEN
597: dbms_sql.bind_variable(l_cursor,'l_property_code_low',l_property_code_low);
598: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);
599: ELSIF property_code_low IS NULL AND property_code_high IS NOT NULL THEN
600: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);
601: ELSIF property_code_low IS NOT NULL AND property_code_high IS NULL THEN

Line 598: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);

594: --------------------------------------
595: --property code conditions
596: IF property_code_low IS NOT NULL AND property_code_high IS NOT NULL THEN
597: dbms_sql.bind_variable(l_cursor,'l_property_code_low',l_property_code_low);
598: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);
599: ELSIF property_code_low IS NULL AND property_code_high IS NOT NULL THEN
600: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);
601: ELSIF property_code_low IS NOT NULL AND property_code_high IS NULL THEN
602: dbms_sql.bind_variable(l_cursor,'l_property_code_low',l_property_code_low);

Line 600: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);

596: IF property_code_low IS NOT NULL AND property_code_high IS NOT NULL THEN
597: dbms_sql.bind_variable(l_cursor,'l_property_code_low',l_property_code_low);
598: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);
599: ELSIF property_code_low IS NULL AND property_code_high IS NOT NULL THEN
600: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);
601: ELSIF property_code_low IS NOT NULL AND property_code_high IS NULL THEN
602: dbms_sql.bind_variable(l_cursor,'l_property_code_low',l_property_code_low);
603: END IF;
604:

Line 602: dbms_sql.bind_variable(l_cursor,'l_property_code_low',l_property_code_low);

598: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);
599: ELSIF property_code_low IS NULL AND property_code_high IS NOT NULL THEN
600: dbms_sql.bind_variable(l_cursor,'l_property_code_high',l_property_code_high);
601: ELSIF property_code_low IS NOT NULL AND property_code_high IS NULL THEN
602: dbms_sql.bind_variable(l_cursor,'l_property_code_low',l_property_code_low);
603: END IF;
604:
605:
606: --location code conditions.....

Line 608: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);

604:
605:
606: --location code conditions.....
607: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN
608: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
609: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
610: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
611: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
612: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN

Line 609: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);

605:
606: --location code conditions.....
607: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN
608: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
609: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
610: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
611: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
612: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN
613: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);

Line 611: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);

607: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN
608: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
609: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
610: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
611: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
612: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN
613: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
614: END IF;
615:

Line 613: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);

609: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
610: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
611: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
612: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN
613: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
614: END IF;
615:
616:
617: --location type conditions....

Line 619: dbms_sql.bind_variable(l_cursor,'l_location_type',l_location_type);

615:
616:
617: --location type conditions....
618: IF location_type IS NOT NULL THEN
619: dbms_sql.bind_variable(l_cursor,'l_location_type',l_location_type);
620: END IF;
621:
622: dbms_sql.define_column (l_cursor,1,v_location_id_1);
623: l_rows := dbms_sql.execute(l_cursor);

Line 622: dbms_sql.define_column (l_cursor,1,v_location_id_1);

618: IF location_type IS NOT NULL THEN
619: dbms_sql.bind_variable(l_cursor,'l_location_type',l_location_type);
620: END IF;
621:
622: dbms_sql.define_column (l_cursor,1,v_location_id_1);
623: l_rows := dbms_sql.execute(l_cursor);
624: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locQuery(-)');
625: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locLoop(+)');
626: LOOP

Line 623: l_rows := dbms_sql.execute(l_cursor);

619: dbms_sql.bind_variable(l_cursor,'l_location_type',l_location_type);
620: END IF;
621:
622: dbms_sql.define_column (l_cursor,1,v_location_id_1);
623: l_rows := dbms_sql.execute(l_cursor);
624: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locQuery(-)');
625: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locLoop(+)');
626: LOOP
627: l_count := dbms_sql.fetch_rows( l_cursor );

Line 627: l_count := dbms_sql.fetch_rows( l_cursor );

623: l_rows := dbms_sql.execute(l_cursor);
624: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locQuery(-)');
625: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locLoop(+)');
626: LOOP
627: l_count := dbms_sql.fetch_rows( l_cursor );
628: EXIT WHEN l_count <> 1;
629:
630:
631: dbms_sql.column_value(l_cursor,1,v_location_id_1);

Line 631: dbms_sql.column_value(l_cursor,1,v_location_id_1);

627: l_count := dbms_sql.fetch_rows( l_cursor );
628: EXIT WHEN l_count <> 1;
629:
630:
631: dbms_sql.column_value(l_cursor,1,v_location_id_1);
632: OPEN c_c_assign_pn FOR
633: SELECT DISTINCT
634: loc.location_id location_id,
635: fl1.meaning location_type,

Line 920: IF dbms_sql.is_open (l_cursor) THEN

916: END LOOP;
917: END LOOP;
918: END LOOP;
919: COMMIT;
920: IF dbms_sql.is_open (l_cursor) THEN
921: dbms_sql.close_cursor (l_cursor);
922: END IF;
923:
924: END IF;

Line 921: dbms_sql.close_cursor (l_cursor);

917: END LOOP;
918: END LOOP;
919: COMMIT;
920: IF dbms_sql.is_open (l_cursor) THEN
921: dbms_sql.close_cursor (l_cursor);
922: END IF;
923:
924: END IF;
925: