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.PO_NEGOTIATIONS_SV1 dependencies on PO_REQUISITION_LINES_ALL

Line 193: x_note_to_vendor po_requisition_lines_all.note_to_vendor%TYPE;

189: x_deliver_to_location_id number;
190: x_negotiation_line_num number;
191: x_num_records number;
192: x_req_header_id number;
193: x_note_to_vendor po_requisition_lines_all.note_to_vendor%TYPE;
194: x_need_by_date date := null;
195: x_req_num varchar2(30);
196: x_item_num varchar2(80);
197: x_item_desc varchar2(240);

Line 240: l_from_org_id PO_REQUISITION_LINES_ALL.org_id%TYPE;

236: --
237: -- The conversion rate from the current org to the destination org
238: l_conv_rate NUMBER;
239: -- The organization of the req line.
240: l_from_org_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
241: --
242:
243: x_progress varchar2(3);
244:

Line 251: x_line_type po_requisition_lines_all.LINE_TYPE_ID%type;

247: TYPE t_crs is ref cursor;
248: l_cursor t_crs;
249: l_string VARCHAR2(10000);
250:
251: x_line_type po_requisition_lines_all.LINE_TYPE_ID%type;
252: x_item_id po_requisition_lines_all.ITEM_ID%type;
253: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
254: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
255: x_quantity po_requisition_lines_all.QUANTITY%type;

Line 252: x_item_id po_requisition_lines_all.ITEM_ID%type;

248: l_cursor t_crs;
249: l_string VARCHAR2(10000);
250:
251: x_line_type po_requisition_lines_all.LINE_TYPE_ID%type;
252: x_item_id po_requisition_lines_all.ITEM_ID%type;
253: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
254: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
255: x_quantity po_requisition_lines_all.QUANTITY%type;
256: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;

Line 253: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;

249: l_string VARCHAR2(10000);
250:
251: x_line_type po_requisition_lines_all.LINE_TYPE_ID%type;
252: x_item_id po_requisition_lines_all.ITEM_ID%type;
253: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
254: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
255: x_quantity po_requisition_lines_all.QUANTITY%type;
256: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
257: x_job_id po_requisition_lines_all.JOB_ID%type;

Line 254: x_category_id po_requisition_lines_all.CATEGORY_ID%type;

250:
251: x_line_type po_requisition_lines_all.LINE_TYPE_ID%type;
252: x_item_id po_requisition_lines_all.ITEM_ID%type;
253: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
254: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
255: x_quantity po_requisition_lines_all.QUANTITY%type;
256: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
257: x_job_id po_requisition_lines_all.JOB_ID%type;
258: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;

Line 255: x_quantity po_requisition_lines_all.QUANTITY%type;

251: x_line_type po_requisition_lines_all.LINE_TYPE_ID%type;
252: x_item_id po_requisition_lines_all.ITEM_ID%type;
253: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
254: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
255: x_quantity po_requisition_lines_all.QUANTITY%type;
256: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
257: x_job_id po_requisition_lines_all.JOB_ID%type;
258: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
259: x_line_num po_requisition_lines_all.line_num%TYPE;

Line 256: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;

252: x_item_id po_requisition_lines_all.ITEM_ID%type;
253: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
254: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
255: x_quantity po_requisition_lines_all.QUANTITY%type;
256: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
257: x_job_id po_requisition_lines_all.JOB_ID%type;
258: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
259: x_line_num po_requisition_lines_all.line_num%TYPE;
260: --bug5841426

Line 257: x_job_id po_requisition_lines_all.JOB_ID%type;

253: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
254: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
255: x_quantity po_requisition_lines_all.QUANTITY%type;
256: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
257: x_job_id po_requisition_lines_all.JOB_ID%type;
258: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
259: x_line_num po_requisition_lines_all.line_num%TYPE;
260: --bug5841426
261:

Line 258: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;

254: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
255: x_quantity po_requisition_lines_all.QUANTITY%type;
256: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
257: x_job_id po_requisition_lines_all.JOB_ID%type;
258: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
259: x_line_num po_requisition_lines_all.line_num%TYPE;
260: --bug5841426
261:
262: --bug6131913

Line 259: x_line_num po_requisition_lines_all.line_num%TYPE;

255: x_quantity po_requisition_lines_all.QUANTITY%type;
256: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
257: x_job_id po_requisition_lines_all.JOB_ID%type;
258: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
259: x_line_num po_requisition_lines_all.line_num%TYPE;
260: --bug5841426
261:
262: --bug6131913
263:

Line 398: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

394: /* The req line has been deleted since it was queried up. */
395: x_result:=-1;
396: fnd_message.set_name('PO', 'PO_ALL_REQ_LINE_DLTD_CANT_AC');
397: /*
398: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
399: WHERE prh.requisition_header_id = prl.requisition_header_id
400: AND prl.requisition_line_id = t_req_lines(i);
401:
402: fnd_message.set_token('REQ_NUM', x_req_num);

Line 415: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

411: if (SQLCODE=-54)
412: THEN
413: x_result:=-1;
414: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_LOCKED_CANT_AC');
415: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
416: WHERE prh.requisition_header_id = prl.requisition_header_id
417: AND prl.requisition_line_id = t_req_lines(i);
418:
419: fnd_message.set_token('REQ_NUM', x_req_num);

Line 437: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

433: then
434: /* The req line has been auto created already. */
435: x_result:=-1;
436: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_ALREADY_AC');
437: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
438: WHERE prh.requisition_header_id = prl.requisition_header_id
439: AND prl.requisition_line_id = t_req_lines(i);
440:
441: fnd_message.set_token('REQ_NUM', x_req_num);

Line 453: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

449: elsif (x_cancel_flag = 'Y') then
450: /* The req line has been cancelled. */
451: x_result:=-1;
452: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_CNCLD_CANT_AC');
453: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
454: WHERE prh.requisition_header_id = prl.requisition_header_id
455: AND prl.requisition_line_id = t_req_lines(i);
456:
457: fnd_message.set_token('REQ_NUM', x_req_num);

Line 469: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

465: elsif (x_closed_code = 'FINALLY CLOSED') then
466: /* The req line has been auto created already. */
467: x_result:=-1;
468: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_FCLSD_CANT_AC');
469: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
470: WHERE prh.requisition_header_id = prl.requisition_header_id
471: AND prl.requisition_line_id = t_req_lines(i);
472:
473: fnd_message.set_token('REQ_NUM', x_req_num);

Line 511: FROM po_requisition_lines_all prl,

507: prl.line_num,
508: prl.item_id,
509: prl.category_id,
510: decode (prl.purchase_basis , 'TEMP LABOR' , prl.assignment_start_date , prl.need_by_date )
511: FROM po_requisition_lines_all prl,
512: po_requisition_headers_all prh
513: WHERE prh.requisition_header_id = prl.requisition_header_id
514: AND prl.requisition_line_id = t_req_lines(i);
515:

Line 561: from po_requisition_lines_all rl, --

557: x_item_desc,
558: l_job_name, --
559: l_job_long_description, --
560: l_from_org_id */ --
561: from po_requisition_lines_all rl, --
562: mtl_system_items_kfv msi,
563: per_jobs_vl PJ,
564: PO_SESSION_GT psg --
565: where requisition_line_id = psg.key --

Line 734: update po_requisition_lines_all --

730:
731: begin
732:
733: x_progress := '008';
734: update po_requisition_lines_all --
735: set on_rfq_flag = 'Y',
736: auction_header_id = x_negotiation_id,
737: auction_display_number = to_char(x_negotiation_id) ,
738: auction_line_number = x_negotiation_line_num,

Line 876: update po_requisition_lines_all prla --Bug 4001965: use _all

872: if x_negotiation_line_num is null then
873:
874: -- : added update of at_sourcing_flag and of
875: -- WHO columns.
876: update po_requisition_lines_all prla --Bug 4001965: use _all
877: set auction_header_id = null,
878: auction_display_number = null,
879: auction_line_number = null,
880: at_sourcing_flag = null, --

Line 909: update po_requisition_lines_all prla --Bug 4001965: use _all

905:
906: else
907: -- : added update of at_sourcing_flag and of
908: -- WHO columns.
909: update po_requisition_lines_all prla --Bug 4001965: use _all
910: set auction_header_id = null,
911: auction_display_number = null,
912: auction_line_number = null,
913: at_sourcing_flag = null, --

Line 958: update po_requisition_lines_all --Bug 4001965: use _all

954: x_new_negotiation_id in number ,
955: x_new_negotiation_num in varchar2 ,
956: x_error_code out NOCOPY varchar2) is
957: BEGIN
958: update po_requisition_lines_all --Bug 4001965: use _all
959: set auction_header_id = x_new_negotiation_id,
960: auction_display_number = x_new_negotiation_num
961: where auction_header_id = x_old_negotiation_id;
962:

Line 1022: update po_requisition_lines_all --Bug 4001965: use _all

1018: END IF;
1019:
1020: l_progress := '001';
1021:
1022: update po_requisition_lines_all --Bug 4001965: use _all
1023: set auction_header_id = p_new_negotiation_id,
1024: auction_display_number = p_new_negotiation_num,
1025: auction_line_number = p_new_negotiation_line_num
1026: where auction_header_id = p_old_negotiation_id and

Line 1059: x_sourcing_flag_value PO_REQUISITION_LINES_ALL.at_sourcing_flag%TYPE; --

1055: x_negotiation_line_num in number,
1056: x_flag_value in varchar2,
1057: x_error_code out NOCOPY varchar2) is
1058:
1059: x_sourcing_flag_value PO_REQUISITION_LINES_ALL.at_sourcing_flag%TYPE; --
1060: x_new_pool_value PO_REQUISITION_LINES_ALL.reqs_in_pool_flag%TYPE; --
1061: BEGIN
1062: -- : check sourcing flag value and convert to new Y/NULL
1063: -- domain for reqs_in_pool_flag and new col at_sourcing_flag

Line 1060: x_new_pool_value PO_REQUISITION_LINES_ALL.reqs_in_pool_flag%TYPE; --

1056: x_flag_value in varchar2,
1057: x_error_code out NOCOPY varchar2) is
1058:
1059: x_sourcing_flag_value PO_REQUISITION_LINES_ALL.at_sourcing_flag%TYPE; --
1060: x_new_pool_value PO_REQUISITION_LINES_ALL.reqs_in_pool_flag%TYPE; --
1061: BEGIN
1062: -- : check sourcing flag value and convert to new Y/NULL
1063: -- domain for reqs_in_pool_flag and new col at_sourcing_flag
1064: IF(x_flag_value = 'N') THEN

Line 1076: update po_requisition_lines_all prla --Bug 4001965: use _all

1072:
1073: if x_negotiation_line_num is null then
1074: -- : added update of at_sourcing_flag and of
1075: -- WHO columns.
1076: update po_requisition_lines_all prla --Bug 4001965: use _all
1077: set reqs_in_pool_flag = x_new_pool_value,
1078: at_sourcing_flag = x_sourcing_flag_value, --
1079: last_update_date = SYSDATE,
1080: last_updated_by = FND_GLOBAL.USER_ID,

Line 1101: update po_requisition_lines_all prla --Bug 4001965: use _all

1097:
1098: else
1099: -- : added update of at_sourcing_flag and of
1100: -- WHO columns.
1101: update po_requisition_lines_all prla --Bug 4001965: use _all
1102: set reqs_in_pool_flag = x_new_pool_value,
1103: at_sourcing_flag = x_sourcing_flag_value, --
1104: last_update_date = SYSDATE,
1105: last_updated_by = FND_GLOBAL.USER_ID,

Line 1143: from po_requisition_lines_all --Bug 4001965: use _all

1139: x_negotiation_ref_flag IN OUT NOCOPY varchar2) is
1140:
1141: cursor c1(x_doc_line_id in number) is
1142: select at_sourcing_flag --
1143: from po_requisition_lines_all --Bug 4001965: use _all
1144: where requisition_line_id = X_doc_line_id;
1145:
1146: cursor c2(x_doc_header_id in number) is
1147: select at_sourcing_flag --

Line 1148: from po_requisition_lines_all --Bug 4001965: use _all

1144: where requisition_line_id = X_doc_line_id;
1145:
1146: cursor c2(x_doc_header_id in number) is
1147: select at_sourcing_flag --
1148: from po_requisition_lines_all --Bug 4001965: use _all
1149: where requisition_header_id = X_doc_header_id;
1150:
1151: x_doc_line_id number;
1152: x_doc_header_id number;

Line 1153: x_sourcing_flag PO_REQUISITION_LINES_ALL.at_sourcing_flag%TYPE; --

1149: where requisition_header_id = X_doc_header_id;
1150:
1151: x_doc_line_id number;
1152: x_doc_header_id number;
1153: x_sourcing_flag PO_REQUISITION_LINES_ALL.at_sourcing_flag%TYPE; --
1154: x_sourcing_install_status varchar2(1);
1155:
1156: BEGIN
1157: