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 348: x_note_to_vendor po_requisition_lines_all.note_to_vendor%TYPE;

344: x_deliver_to_location_id number;
345: x_negotiation_line_num number;
346: x_num_records number;
347: x_req_header_id number;
348: x_note_to_vendor po_requisition_lines_all.note_to_vendor%TYPE;
349: x_need_by_date date := null;
350: x_req_num varchar2(30);
351: x_item_num varchar2(80);
352: x_item_desc varchar2(240);

Line 396: l_from_org_id PO_REQUISITION_LINES_ALL.org_id%TYPE;

392: --
393: -- The conversion rate from the current org to the destination org
394: l_conv_rate NUMBER;
395: -- The organization of the req line.
396: l_from_org_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
397: --
398:
399: x_progress varchar2(3);
400:

Line 407: x_line_type po_requisition_lines_all.LINE_TYPE_ID%type;

403: TYPE t_crs is ref cursor;
404: l_cursor t_crs;
405: l_string VARCHAR2(10000);
406:
407: x_line_type po_requisition_lines_all.LINE_TYPE_ID%type;
408: x_item_id po_requisition_lines_all.ITEM_ID%type;
409: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
410: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
411: x_quantity po_requisition_lines_all.QUANTITY%type;

Line 408: x_item_id po_requisition_lines_all.ITEM_ID%type;

404: l_cursor t_crs;
405: l_string VARCHAR2(10000);
406:
407: x_line_type po_requisition_lines_all.LINE_TYPE_ID%type;
408: x_item_id po_requisition_lines_all.ITEM_ID%type;
409: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
410: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
411: x_quantity po_requisition_lines_all.QUANTITY%type;
412: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;

Line 409: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;

405: l_string VARCHAR2(10000);
406:
407: x_line_type po_requisition_lines_all.LINE_TYPE_ID%type;
408: x_item_id po_requisition_lines_all.ITEM_ID%type;
409: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
410: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
411: x_quantity po_requisition_lines_all.QUANTITY%type;
412: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
413: x_job_id po_requisition_lines_all.JOB_ID%type;

Line 410: x_category_id po_requisition_lines_all.CATEGORY_ID%type;

406:
407: x_line_type po_requisition_lines_all.LINE_TYPE_ID%type;
408: x_item_id po_requisition_lines_all.ITEM_ID%type;
409: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
410: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
411: x_quantity po_requisition_lines_all.QUANTITY%type;
412: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
413: x_job_id po_requisition_lines_all.JOB_ID%type;
414: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;

Line 411: x_quantity po_requisition_lines_all.QUANTITY%type;

407: x_line_type po_requisition_lines_all.LINE_TYPE_ID%type;
408: x_item_id po_requisition_lines_all.ITEM_ID%type;
409: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
410: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
411: x_quantity po_requisition_lines_all.QUANTITY%type;
412: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
413: x_job_id po_requisition_lines_all.JOB_ID%type;
414: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
415: x_line_num po_requisition_lines_all.line_num%TYPE;

Line 412: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;

408: x_item_id po_requisition_lines_all.ITEM_ID%type;
409: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
410: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
411: x_quantity po_requisition_lines_all.QUANTITY%type;
412: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
413: x_job_id po_requisition_lines_all.JOB_ID%type;
414: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
415: x_line_num po_requisition_lines_all.line_num%TYPE;
416: x_neg_line_num_disp pon_auction_item_prices_all.line_num_display%TYPE;

Line 413: x_job_id po_requisition_lines_all.JOB_ID%type;

409: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
410: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
411: x_quantity po_requisition_lines_all.QUANTITY%type;
412: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
413: x_job_id po_requisition_lines_all.JOB_ID%type;
414: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
415: x_line_num po_requisition_lines_all.line_num%TYPE;
416: x_neg_line_num_disp pon_auction_item_prices_all.line_num_display%TYPE;
417:

Line 414: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;

410: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
411: x_quantity po_requisition_lines_all.QUANTITY%type;
412: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
413: x_job_id po_requisition_lines_all.JOB_ID%type;
414: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
415: x_line_num po_requisition_lines_all.line_num%TYPE;
416: x_neg_line_num_disp pon_auction_item_prices_all.line_num_display%TYPE;
417:
418: -- added for CLIN SLIN Project

Line 415: x_line_num po_requisition_lines_all.line_num%TYPE;

411: x_quantity po_requisition_lines_all.QUANTITY%type;
412: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
413: x_job_id po_requisition_lines_all.JOB_ID%type;
414: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
415: x_line_num po_requisition_lines_all.line_num%TYPE;
416: x_neg_line_num_disp pon_auction_item_prices_all.line_num_display%TYPE;
417:
418: -- added for CLIN SLIN Project
419: x_line_num_display po_requisition_lines_all.line_num_display%TYPE;

Line 419: x_line_num_display po_requisition_lines_all.line_num_display%TYPE;

415: x_line_num po_requisition_lines_all.line_num%TYPE;
416: x_neg_line_num_disp pon_auction_item_prices_all.line_num_display%TYPE;
417:
418: -- added for CLIN SLIN Project
419: x_line_num_display po_requisition_lines_all.line_num_display%TYPE;
420: x_group_line_id po_requisition_lines_all.group_line_id%TYPE;
421: x_clm_info_flag po_requisition_lines_all.clm_info_flag%TYPE;
422: x_clm_option_indicator po_requisition_lines_all.clm_option_indicator%TYPE;
423: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;

Line 420: x_group_line_id po_requisition_lines_all.group_line_id%TYPE;

416: x_neg_line_num_disp pon_auction_item_prices_all.line_num_display%TYPE;
417:
418: -- added for CLIN SLIN Project
419: x_line_num_display po_requisition_lines_all.line_num_display%TYPE;
420: x_group_line_id po_requisition_lines_all.group_line_id%TYPE;
421: x_clm_info_flag po_requisition_lines_all.clm_info_flag%TYPE;
422: x_clm_option_indicator po_requisition_lines_all.clm_option_indicator%TYPE;
423: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;
424: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;

Line 421: x_clm_info_flag po_requisition_lines_all.clm_info_flag%TYPE;

417:
418: -- added for CLIN SLIN Project
419: x_line_num_display po_requisition_lines_all.line_num_display%TYPE;
420: x_group_line_id po_requisition_lines_all.group_line_id%TYPE;
421: x_clm_info_flag po_requisition_lines_all.clm_info_flag%TYPE;
422: x_clm_option_indicator po_requisition_lines_all.clm_option_indicator%TYPE;
423: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;
424: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;
425: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;

Line 422: x_clm_option_indicator po_requisition_lines_all.clm_option_indicator%TYPE;

418: -- added for CLIN SLIN Project
419: x_line_num_display po_requisition_lines_all.line_num_display%TYPE;
420: x_group_line_id po_requisition_lines_all.group_line_id%TYPE;
421: x_clm_info_flag po_requisition_lines_all.clm_info_flag%TYPE;
422: x_clm_option_indicator po_requisition_lines_all.clm_option_indicator%TYPE;
423: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;
424: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;
425: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;
426: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;

Line 423: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;

419: x_line_num_display po_requisition_lines_all.line_num_display%TYPE;
420: x_group_line_id po_requisition_lines_all.group_line_id%TYPE;
421: x_clm_info_flag po_requisition_lines_all.clm_info_flag%TYPE;
422: x_clm_option_indicator po_requisition_lines_all.clm_option_indicator%TYPE;
423: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;
424: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;
425: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;
426: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;
427: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;

Line 424: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;

420: x_group_line_id po_requisition_lines_all.group_line_id%TYPE;
421: x_clm_info_flag po_requisition_lines_all.clm_info_flag%TYPE;
422: x_clm_option_indicator po_requisition_lines_all.clm_option_indicator%TYPE;
423: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;
424: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;
425: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;
426: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;
427: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;
428: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;

Line 425: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;

421: x_clm_info_flag po_requisition_lines_all.clm_info_flag%TYPE;
422: x_clm_option_indicator po_requisition_lines_all.clm_option_indicator%TYPE;
423: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;
424: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;
425: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;
426: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;
427: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;
428: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;
429: x_COST_CONSTRAINT po_requisition_lines_all.COST_CONSTRAINT%TYPE;

Line 426: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;

422: x_clm_option_indicator po_requisition_lines_all.clm_option_indicator%TYPE;
423: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;
424: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;
425: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;
426: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;
427: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;
428: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;
429: x_COST_CONSTRAINT po_requisition_lines_all.COST_CONSTRAINT%TYPE;
430: x_CLM_IDC_TYPE po_lines_all.CLM_IDC_TYPE%TYPE;

Line 427: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;

423: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;
424: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;
425: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;
426: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;
427: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;
428: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;
429: x_COST_CONSTRAINT po_requisition_lines_all.COST_CONSTRAINT%TYPE;
430: x_CLM_IDC_TYPE po_lines_all.CLM_IDC_TYPE%TYPE;
431: x_req_line_temp_id po_requisition_lines_all.UDA_TEMPLATE_ID%TYPE; --

Line 428: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;

424: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;
425: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;
426: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;
427: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;
428: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;
429: x_COST_CONSTRAINT po_requisition_lines_all.COST_CONSTRAINT%TYPE;
430: x_CLM_IDC_TYPE po_lines_all.CLM_IDC_TYPE%TYPE;
431: x_req_line_temp_id po_requisition_lines_all.UDA_TEMPLATE_ID%TYPE; --
432:

Line 429: x_COST_CONSTRAINT po_requisition_lines_all.COST_CONSTRAINT%TYPE;

425: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;
426: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;
427: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;
428: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;
429: x_COST_CONSTRAINT po_requisition_lines_all.COST_CONSTRAINT%TYPE;
430: x_CLM_IDC_TYPE po_lines_all.CLM_IDC_TYPE%TYPE;
431: x_req_line_temp_id po_requisition_lines_all.UDA_TEMPLATE_ID%TYPE; --
432:
433: --bug5841426

Line 431: x_req_line_temp_id po_requisition_lines_all.UDA_TEMPLATE_ID%TYPE; --

427: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;
428: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;
429: x_COST_CONSTRAINT po_requisition_lines_all.COST_CONSTRAINT%TYPE;
430: x_CLM_IDC_TYPE po_lines_all.CLM_IDC_TYPE%TYPE;
431: x_req_line_temp_id po_requisition_lines_all.UDA_TEMPLATE_ID%TYPE; --
432:
433: --bug5841426
434:
435: --bug6131913

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

636:
637: x_result:=-1;
638: fnd_message.set_name('PO', 'PO_ALL_REQ_LINE_DLTD_CANT_AC');
639: /*
640: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
641: WHERE prh.requisition_header_id = prl.requisition_header_id
642: AND prl.requisition_line_id = t_req_lines(i);
643:
644: fnd_message.set_token('REQ_NUM', x_req_num);

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

657: if (SQLCODE=-54)
658: THEN
659: x_result:=-1;
660: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_LOCKED_CANT_AC');
661: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
662: WHERE prh.requisition_header_id = prl.requisition_header_id
663: AND prl.requisition_line_id = t_req_lines(i);
664:
665: fnd_message.set_token('REQ_NUM', x_req_num);

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

685: then
686: /* The req line has been auto created already. */
687: x_result:=-1;
688: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_ALREADY_AC');
689: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
690: WHERE prh.requisition_header_id = prl.requisition_header_id
691: AND prl.requisition_line_id = t_req_lines(i);
692:
693: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

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

707: elsif (x_cancel_flag = 'Y') then
708: /* The req line has been cancelled. */
709: x_result:=-1;
710: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_CNCLD_CANT_AC');
711: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
712: WHERE prh.requisition_header_id = prl.requisition_header_id
713: AND prl.requisition_line_id = t_req_lines(i);
714:
715: fnd_message.set_token('REQ_NUM', x_req_num);

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

723: elsif (x_closed_code = 'FINALLY CLOSED') then
724: /* The req line has been auto created already. */
725: x_result:=-1;
726: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_FCLSD_CANT_AC');
727: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
728: WHERE prh.requisition_header_id = prl.requisition_header_id
729: AND prl.requisition_line_id = t_req_lines(i);
730:
731: fnd_message.set_token('REQ_NUM', x_req_num);

Line 775: FROM po_requisition_lines_all prl,

771: prl.line_num,
772: prl.item_id,
773: prl.category_id,
774: decode (prl.purchase_basis , 'TEMP LABOR' , prl.assignment_start_date , prl.need_by_date )
775: FROM po_requisition_lines_all prl,
776: po_requisition_headers_all prh
777: WHERE prh.requisition_header_id = prl.requisition_header_id
778: AND prl.requisition_line_id = t_req_lines(i);
779: else

Line 791: FROM po_requisition_lines_all prl,

787: prl.category_id,
788: t_neg_lines(i),
789: t_neg_line_num(i),
790: decode (prl.purchase_basis , 'TEMP LABOR' , prl.assignment_start_date , prl.need_by_date )
791: FROM po_requisition_lines_all prl,
792: po_requisition_headers_all prh
793: WHERE prh.requisition_header_id = prl.requisition_header_id
794: AND prl.requisition_line_id = t_req_lines(i);
795: end if;

Line 860: from po_requisition_lines_all rl, --

856: x_item_desc,
857: l_job_name, --
858: l_job_long_description, --
859: l_from_org_id */ --
860: from po_requisition_lines_all rl, --
861: mtl_system_items_kfv msi,
862: per_jobs_vl PJ,
863: PO_SESSION_GT psg --
864: where requisition_line_id = psg.key --

Line 1144: update po_requisition_lines_all --

1140: -- logme( '008 : x_negotiation_id = '|| x_negotiation_id || ' to_char(x_negotiation_id) = ' || to_char(x_negotiation_id)
1141: -- || ' x_negotiation_line_num = '|| x_negotiation_line_num || ' sysdate = '|| SYSDATE ||
1142: -- ' to_number(FND_PROFILE.VALUE(user_id)) = ' || to_number(FND_PROFILE.VALUE('user_id'))
1143: -- || ' x_req_line_id = ' || x_req_line_id);
1144: update po_requisition_lines_all --
1145: set on_rfq_flag = 'Y',
1146: auction_header_id = x_negotiation_id,
1147: auction_display_number = to_char(x_negotiation_id) ,
1148: auction_line_number = x_negotiation_line_num,

Line 1159: update po_requisition_lines_all

1155:
1156: -- bug# 9887326
1157: IF ( PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(x_negotiation_id) = 1 ) THEN
1158: SELECT document_number INTO x_document_number FROM pon_auction_headers_all WHERE auction_header_id=x_negotiation_id;
1159: update po_requisition_lines_all
1160: SET auction_display_number = x_document_number
1161: where requisition_line_id = x_req_line_id ;
1162: END IF;
1163:

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

1410: if x_negotiation_line_num is null then
1411:
1412: -- : added update of at_sourcing_flag and of
1413: -- WHO columns.
1414: update po_requisition_lines_all prla --Bug 4001965: use _all
1415: set auction_header_id = null,
1416: auction_display_number = null,
1417: auction_line_number = null,
1418: at_sourcing_flag = null, --

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

1443:
1444: else
1445: -- : added update of at_sourcing_flag and of
1446: -- WHO columns.
1447: update po_requisition_lines_all prla --Bug 4001965: use _all
1448: set auction_header_id = null,
1449: auction_display_number = null,
1450: auction_line_number = null,
1451: at_sourcing_flag = null, --

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

1492: x_new_negotiation_id in number ,
1493: x_new_negotiation_num in varchar2 ,
1494: x_error_code out NOCOPY varchar2) is
1495: BEGIN
1496: update po_requisition_lines_all --Bug 4001965: use _all
1497: set auction_header_id = x_new_negotiation_id,
1498: auction_display_number = x_new_negotiation_num
1499: where auction_header_id = x_old_negotiation_id;
1500:

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

1556: END IF;
1557:
1558: l_progress := '001';
1559:
1560: update po_requisition_lines_all --Bug 4001965: use _all
1561: set auction_header_id = p_new_negotiation_id,
1562: auction_display_number = p_new_negotiation_num,
1563: auction_line_number = p_new_negotiation_line_num
1564: where auction_header_id = p_old_negotiation_id and

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

1593: x_negotiation_line_num in number,
1594: x_flag_value in varchar2,
1595: x_error_code out NOCOPY varchar2) is
1596:
1597: x_sourcing_flag_value PO_REQUISITION_LINES_ALL.at_sourcing_flag%TYPE; --
1598: x_new_pool_value PO_REQUISITION_LINES_ALL.reqs_in_pool_flag%TYPE; --
1599: BEGIN
1600: -- : check sourcing flag value and convert to new Y/NULL
1601: -- domain for reqs_in_pool_flag and new col at_sourcing_flag

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

1594: x_flag_value in varchar2,
1595: x_error_code out NOCOPY varchar2) is
1596:
1597: x_sourcing_flag_value PO_REQUISITION_LINES_ALL.at_sourcing_flag%TYPE; --
1598: x_new_pool_value PO_REQUISITION_LINES_ALL.reqs_in_pool_flag%TYPE; --
1599: BEGIN
1600: -- : check sourcing flag value and convert to new Y/NULL
1601: -- domain for reqs_in_pool_flag and new col at_sourcing_flag
1602: IF(x_flag_value = 'N') THEN

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

1610:
1611: if x_negotiation_line_num is null then
1612: -- : added update of at_sourcing_flag and of
1613: -- WHO columns.
1614: update po_requisition_lines_all prla --Bug 4001965: use _all
1615: set reqs_in_pool_flag = x_new_pool_value,
1616: at_sourcing_flag = x_sourcing_flag_value, --
1617: last_update_date = SYSDATE,
1618: last_updated_by = FND_GLOBAL.USER_ID,

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

1635:
1636: else
1637: -- : added update of at_sourcing_flag and of
1638: -- WHO columns.
1639: update po_requisition_lines_all prla --Bug 4001965: use _all
1640: set reqs_in_pool_flag = x_new_pool_value,
1641: at_sourcing_flag = x_sourcing_flag_value, --
1642: last_update_date = SYSDATE,
1643: last_updated_by = FND_GLOBAL.USER_ID,

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

1677: x_negotiation_ref_flag IN OUT NOCOPY varchar2) is
1678:
1679: cursor c1(x_doc_line_id in number) is
1680: select at_sourcing_flag --
1681: from po_requisition_lines_all --Bug 4001965: use _all
1682: where requisition_line_id = X_doc_line_id;
1683:
1684: cursor c2(x_doc_header_id in number) is
1685: select at_sourcing_flag --

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

1682: where requisition_line_id = X_doc_line_id;
1683:
1684: cursor c2(x_doc_header_id in number) is
1685: select at_sourcing_flag --
1686: from po_requisition_lines_all --Bug 4001965: use _all
1687: where requisition_header_id = X_doc_header_id;
1688:
1689: x_doc_line_id number;
1690: x_doc_header_id number;

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

1687: where requisition_header_id = X_doc_header_id;
1688:
1689: x_doc_line_id number;
1690: x_doc_header_id number;
1691: x_sourcing_flag PO_REQUISITION_LINES_ALL.at_sourcing_flag%TYPE; --
1692: x_sourcing_install_status varchar2(1);
1693:
1694: BEGIN
1695:

Line 2436: x_note_to_vendor po_requisition_lines_all.note_to_vendor%TYPE;

2432: x_ship_to_location_id number;
2433: x_deliver_to_location_id number;
2434: x_negotiation_line_num number;
2435: x_req_header_id number;
2436: x_note_to_vendor po_requisition_lines_all.note_to_vendor%TYPE;
2437: x_need_by_date date := null;
2438: x_req_num varchar2(30);
2439: x_item_num varchar2(80);
2440: x_item_desc varchar2(240);

Line 2464: l_from_org_id PO_REQUISITION_LINES_ALL.org_id%TYPE;

2460: WHERE entity_type = 'REQ LINE'
2461: AND entity_id = p_req_line_id;
2462:
2463: l_conv_rate NUMBER;
2464: l_from_org_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
2465:
2466: x_progress varchar2(3);
2467: TYPE t_crs is ref cursor;
2468: l_cursor t_crs;

Line 2471: x_line_type po_requisition_lines_all.LINE_TYPE_ID%type;

2467: TYPE t_crs is ref cursor;
2468: l_cursor t_crs;
2469: l_string VARCHAR2(10000);
2470:
2471: x_line_type po_requisition_lines_all.LINE_TYPE_ID%type;
2472: x_item_id po_requisition_lines_all.ITEM_ID%type;
2473: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
2474: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
2475: x_quantity po_requisition_lines_all.QUANTITY%type;

Line 2472: x_item_id po_requisition_lines_all.ITEM_ID%type;

2468: l_cursor t_crs;
2469: l_string VARCHAR2(10000);
2470:
2471: x_line_type po_requisition_lines_all.LINE_TYPE_ID%type;
2472: x_item_id po_requisition_lines_all.ITEM_ID%type;
2473: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
2474: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
2475: x_quantity po_requisition_lines_all.QUANTITY%type;
2476: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;

Line 2473: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;

2469: l_string VARCHAR2(10000);
2470:
2471: x_line_type po_requisition_lines_all.LINE_TYPE_ID%type;
2472: x_item_id po_requisition_lines_all.ITEM_ID%type;
2473: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
2474: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
2475: x_quantity po_requisition_lines_all.QUANTITY%type;
2476: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
2477: x_job_id po_requisition_lines_all.JOB_ID%type;

Line 2474: x_category_id po_requisition_lines_all.CATEGORY_ID%type;

2470:
2471: x_line_type po_requisition_lines_all.LINE_TYPE_ID%type;
2472: x_item_id po_requisition_lines_all.ITEM_ID%type;
2473: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
2474: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
2475: x_quantity po_requisition_lines_all.QUANTITY%type;
2476: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
2477: x_job_id po_requisition_lines_all.JOB_ID%type;
2478: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;

Line 2475: x_quantity po_requisition_lines_all.QUANTITY%type;

2471: x_line_type po_requisition_lines_all.LINE_TYPE_ID%type;
2472: x_item_id po_requisition_lines_all.ITEM_ID%type;
2473: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
2474: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
2475: x_quantity po_requisition_lines_all.QUANTITY%type;
2476: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
2477: x_job_id po_requisition_lines_all.JOB_ID%type;
2478: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
2479: x_line_num po_requisition_lines_all.line_num%TYPE;

Line 2476: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;

2472: x_item_id po_requisition_lines_all.ITEM_ID%type;
2473: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
2474: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
2475: x_quantity po_requisition_lines_all.QUANTITY%type;
2476: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
2477: x_job_id po_requisition_lines_all.JOB_ID%type;
2478: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
2479: x_line_num po_requisition_lines_all.line_num%TYPE;
2480:

Line 2477: x_job_id po_requisition_lines_all.JOB_ID%type;

2473: x_item_rev po_requisition_lines_all.ITEM_REVISION%type;
2474: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
2475: x_quantity po_requisition_lines_all.QUANTITY%type;
2476: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
2477: x_job_id po_requisition_lines_all.JOB_ID%type;
2478: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
2479: x_line_num po_requisition_lines_all.line_num%TYPE;
2480:
2481: -- added for CLIN SLIN Project

Line 2478: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;

2474: x_category_id po_requisition_lines_all.CATEGORY_ID%type;
2475: x_quantity po_requisition_lines_all.QUANTITY%type;
2476: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
2477: x_job_id po_requisition_lines_all.JOB_ID%type;
2478: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
2479: x_line_num po_requisition_lines_all.line_num%TYPE;
2480:
2481: -- added for CLIN SLIN Project
2482: x_line_num_display po_requisition_lines_all.line_num_display%TYPE;

Line 2479: x_line_num po_requisition_lines_all.line_num%TYPE;

2475: x_quantity po_requisition_lines_all.QUANTITY%type;
2476: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
2477: x_job_id po_requisition_lines_all.JOB_ID%type;
2478: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
2479: x_line_num po_requisition_lines_all.line_num%TYPE;
2480:
2481: -- added for CLIN SLIN Project
2482: x_line_num_display po_requisition_lines_all.line_num_display%TYPE;
2483: x_group_line_id po_requisition_lines_all.group_line_id%TYPE;

Line 2482: x_line_num_display po_requisition_lines_all.line_num_display%TYPE;

2478: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
2479: x_line_num po_requisition_lines_all.line_num%TYPE;
2480:
2481: -- added for CLIN SLIN Project
2482: x_line_num_display po_requisition_lines_all.line_num_display%TYPE;
2483: x_group_line_id po_requisition_lines_all.group_line_id%TYPE;
2484: x_clm_info_flag po_requisition_lines_all.clm_info_flag%TYPE;
2485: x_clm_option_indicator po_requisition_lines_all.clm_option_indicator%TYPE;
2486: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;

Line 2483: x_group_line_id po_requisition_lines_all.group_line_id%TYPE;

2479: x_line_num po_requisition_lines_all.line_num%TYPE;
2480:
2481: -- added for CLIN SLIN Project
2482: x_line_num_display po_requisition_lines_all.line_num_display%TYPE;
2483: x_group_line_id po_requisition_lines_all.group_line_id%TYPE;
2484: x_clm_info_flag po_requisition_lines_all.clm_info_flag%TYPE;
2485: x_clm_option_indicator po_requisition_lines_all.clm_option_indicator%TYPE;
2486: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;
2487: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;

Line 2484: x_clm_info_flag po_requisition_lines_all.clm_info_flag%TYPE;

2480:
2481: -- added for CLIN SLIN Project
2482: x_line_num_display po_requisition_lines_all.line_num_display%TYPE;
2483: x_group_line_id po_requisition_lines_all.group_line_id%TYPE;
2484: x_clm_info_flag po_requisition_lines_all.clm_info_flag%TYPE;
2485: x_clm_option_indicator po_requisition_lines_all.clm_option_indicator%TYPE;
2486: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;
2487: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;
2488: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;

Line 2485: x_clm_option_indicator po_requisition_lines_all.clm_option_indicator%TYPE;

2481: -- added for CLIN SLIN Project
2482: x_line_num_display po_requisition_lines_all.line_num_display%TYPE;
2483: x_group_line_id po_requisition_lines_all.group_line_id%TYPE;
2484: x_clm_info_flag po_requisition_lines_all.clm_info_flag%TYPE;
2485: x_clm_option_indicator po_requisition_lines_all.clm_option_indicator%TYPE;
2486: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;
2487: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;
2488: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;
2489: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;

Line 2486: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;

2482: x_line_num_display po_requisition_lines_all.line_num_display%TYPE;
2483: x_group_line_id po_requisition_lines_all.group_line_id%TYPE;
2484: x_clm_info_flag po_requisition_lines_all.clm_info_flag%TYPE;
2485: x_clm_option_indicator po_requisition_lines_all.clm_option_indicator%TYPE;
2486: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;
2487: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;
2488: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;
2489: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;
2490: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;

Line 2487: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;

2483: x_group_line_id po_requisition_lines_all.group_line_id%TYPE;
2484: x_clm_info_flag po_requisition_lines_all.clm_info_flag%TYPE;
2485: x_clm_option_indicator po_requisition_lines_all.clm_option_indicator%TYPE;
2486: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;
2487: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;
2488: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;
2489: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;
2490: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;
2491: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;

Line 2488: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;

2484: x_clm_info_flag po_requisition_lines_all.clm_info_flag%TYPE;
2485: x_clm_option_indicator po_requisition_lines_all.clm_option_indicator%TYPE;
2486: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;
2487: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;
2488: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;
2489: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;
2490: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;
2491: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;
2492: x_COST_CONSTRAINT po_requisition_lines_all.COST_CONSTRAINT%TYPE;

Line 2489: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;

2485: x_clm_option_indicator po_requisition_lines_all.clm_option_indicator%TYPE;
2486: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;
2487: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;
2488: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;
2489: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;
2490: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;
2491: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;
2492: x_COST_CONSTRAINT po_requisition_lines_all.COST_CONSTRAINT%TYPE;
2493: x_CLM_IDC_TYPE po_lines_all.CLM_IDC_TYPE%TYPE;

Line 2490: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;

2486: x_clm_option_num po_requisition_lines_all.clm_option_num%TYPE;
2487: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;
2488: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;
2489: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;
2490: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;
2491: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;
2492: x_COST_CONSTRAINT po_requisition_lines_all.COST_CONSTRAINT%TYPE;
2493: x_CLM_IDC_TYPE po_lines_all.CLM_IDC_TYPE%TYPE;
2494: x_req_line_temp_id po_requisition_lines_all.UDA_TEMPLATE_ID%TYPE; --

Line 2491: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;

2487: x_clm_option_from_date po_requisition_lines_all.clm_option_from_date%TYPE;
2488: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;
2489: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;
2490: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;
2491: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;
2492: x_COST_CONSTRAINT po_requisition_lines_all.COST_CONSTRAINT%TYPE;
2493: x_CLM_IDC_TYPE po_lines_all.CLM_IDC_TYPE%TYPE;
2494: x_req_line_temp_id po_requisition_lines_all.UDA_TEMPLATE_ID%TYPE; --
2495: x_req_in_pool_flag VARCHAR2(1) :=NULL;

Line 2492: x_COST_CONSTRAINT po_requisition_lines_all.COST_CONSTRAINT%TYPE;

2488: x_clm_option_to_date po_requisition_lines_all.clm_option_to_date%TYPE;
2489: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;
2490: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;
2491: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;
2492: x_COST_CONSTRAINT po_requisition_lines_all.COST_CONSTRAINT%TYPE;
2493: x_CLM_IDC_TYPE po_lines_all.CLM_IDC_TYPE%TYPE;
2494: x_req_line_temp_id po_requisition_lines_all.UDA_TEMPLATE_ID%TYPE; --
2495: x_req_in_pool_flag VARCHAR2(1) :=NULL;
2496: x_cancel_flag varchar2(1);

Line 2494: x_req_line_temp_id po_requisition_lines_all.UDA_TEMPLATE_ID%TYPE; --

2490: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;
2491: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;
2492: x_COST_CONSTRAINT po_requisition_lines_all.COST_CONSTRAINT%TYPE;
2493: x_CLM_IDC_TYPE po_lines_all.CLM_IDC_TYPE%TYPE;
2494: x_req_line_temp_id po_requisition_lines_all.UDA_TEMPLATE_ID%TYPE; --
2495: x_req_in_pool_flag VARCHAR2(1) :=NULL;
2496: x_cancel_flag varchar2(1);
2497: x_closed_code varchar2(25);
2498: x_grouping_method varchar2(24);

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

2607: if (SQLCODE=-54)
2608: THEN
2609: x_result:=-1;
2610: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_LOCKED_CANT_AC');
2611: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
2612: WHERE prh.requisition_header_id = prl.requisition_header_id
2613: AND prl.requisition_line_id = p_req_line_id;
2614:
2615: fnd_message.set_token('REQ_NUM', x_req_num);

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

2629: then
2630: /* The req line has been auto created already. */
2631: x_result:=-1;
2632: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_ALREADY_AC');
2633: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
2634: WHERE prh.requisition_header_id = prl.requisition_header_id
2635: AND prl.requisition_line_id = p_req_line_id;
2636:
2637: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

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

2650: elsif (x_cancel_flag = 'Y') then
2651: /* The req line has been cancelled. */
2652: x_result:=-1;
2653: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_CNCLD_CANT_AC');
2654: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
2655: WHERE prh.requisition_header_id = prl.requisition_header_id
2656: AND prl.requisition_line_id = p_req_line_id;
2657:
2658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

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

2671: elsif (x_closed_code = 'FINALLY CLOSED') then
2672: /* The req line has been auto created already. */
2673: x_result:=-1;
2674: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_FCLSD_CANT_AC');
2675: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
2676: WHERE prh.requisition_header_id = prl.requisition_header_id
2677: AND prl.requisition_line_id = p_req_line_id;
2678:
2679: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 2708: FROM po_requisition_lines_all prl,

2704: prl.line_num,
2705: prl.item_id,
2706: prl.category_id,
2707: decode (prl.purchase_basis , 'TEMP LABOR' , prl.assignment_start_date , prl.need_by_date )
2708: FROM po_requisition_lines_all prl,
2709: po_requisition_headers_all prh
2710: WHERE prh.requisition_header_id = prl.requisition_header_id
2711: AND prl.requisition_line_id = p_req_line_id;
2712:

Line 2751: from po_requisition_lines_all rl, --

2747: rl.CONTRACT_TYPE,
2748: rl.COST_CONSTRAINT,
2749: decode(rl.CONTRACT_TYPE, null, null, ''IDC_NA''),
2750: rl.UDA_TEMPLATE_ID --
2751: from po_requisition_lines_all rl, --
2752: mtl_system_items_kfv msi,
2753: per_jobs_vl PJ,
2754: PO_SESSION_GT psg --
2755: where requisition_line_id = psg.key --

Line 2992: update po_requisition_lines_all --

2988: -- logme( '008 : x_negotiation_id = '|| x_negotiation_id || ' to_char(x_negotiation_id) = ' || to_char(x_negotiation_id)
2989: -- || ' x_negotiation_line_num = '|| x_negotiation_line_num || ' sysdate = '|| SYSDATE ||
2990: -- ' to_number(FND_PROFILE.VALUE(user_id)) = ' || to_number(FND_PROFILE.VALUE('user_id'))
2991: -- || ' x_req_line_id = ' || x_req_line_id);
2992: update po_requisition_lines_all --
2993: set on_rfq_flag = 'Y',
2994: auction_header_id = p_auction_header_id,
2995: auction_display_number = to_char(p_auction_header_id) ,
2996: auction_line_number = x_negotiation_line_num,

Line 3007: update po_requisition_lines_all

3003:
3004: -- bug# 9887326
3005: IF ( PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(p_auction_header_id) = 1 ) THEN
3006: SELECT document_number INTO x_document_number FROM pon_auction_headers_all WHERE auction_header_id=p_auction_header_id;
3007: update po_requisition_lines_all
3008: SET auction_display_number = x_document_number
3009: where requisition_line_id = x_req_line_id ;
3010: END IF;
3011: exception

Line 3222: SELECT requisition_header_id INTO l_req_header_id FROM po_requisition_lines_all WHERE requisition_line_id = l_req_line_id;

3218: l_req_line_id := p_req_lines(i);
3219: END LOOP;
3220:
3221: BEGIN
3222: SELECT requisition_header_id INTO l_req_header_id FROM po_requisition_lines_all WHERE requisition_line_id = l_req_line_id;
3223: SELECT uda_template_id INTO l_sol_uda_temp_id FROM pon_auction_headers_all WHERE auction_header_id = p_auction_header_id;
3224: SELECT uda_template_id INTO l_req_uda_temp_id FROM po_requisition_headers_all WHERE REQUISITION_HEADER_ID= l_req_header_id;
3225:
3226: EXCEPTION WHEN OTHERS THEN

Line 3397: UPDATE po_requisition_lines_all

3393: FOR i in 1..p_requisition_line_id.COUNT LOOP
3394:
3395: IF p_line_type = 'SOLICITATION' THEN --solicited line
3396:
3397: UPDATE po_requisition_lines_all
3398: SET auction_header_id = p_auction_header_id,
3399: auction_line_number = -1,
3400: auction_display_number = -1,
3401: last_update_date = SYSDATE,

Line 3415: UPDATE po_requisition_lines_all

3411: END IF;
3412:
3413: ELSIF p_line_type = 'UNSOLICITED' THEN --unsolicited line
3414:
3415: UPDATE po_requisition_lines_all
3416: SET auction_header_id = p_auction_header_id,
3417: auction_line_number = -1,
3418: auction_display_number = -1,
3419: bid_number = -1,

Line 3437: UPDATE po_requisition_lines_all

3433:
3434: --looping thru the line_id array and updating the reqs_in_pool_flag and at_sourcing_flag for the entire structure(including slins and options) of the selected line
3435: --removing the slins and options of all the selected clins from the requisition pool
3436:
3437: UPDATE po_requisition_lines_all
3438: SET reqs_in_pool_flag = null,
3439: at_sourcing_flag = 'Y',
3440: last_update_date = SYSDATE,
3441: last_updated_by = FND_GLOBAL.USER_ID,

Line 3447: OR (requisition_line_id IN (SELECT group_line_id from po_requisition_lines_all

3443: WHERE requisition_header_id = l_requisition_header_id
3444: AND Nvl(reqs_in_pool_flag, 'N') = 'Y'
3445: AND ((requisition_line_id = p_requisition_line_id(i))
3446: OR (group_line_id = p_requisition_line_id(i))
3447: OR (requisition_line_id IN (SELECT group_line_id from po_requisition_lines_all
3448: WHERE requisition_line_id = p_requisition_line_id(i)
3449: AND requisition_header_id = l_requisition_header_id))
3450: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3451: WHERE requisition_line_id = p_requisition_line_id(i)

Line 3450: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all

3446: OR (group_line_id = p_requisition_line_id(i))
3447: OR (requisition_line_id IN (SELECT group_line_id from po_requisition_lines_all
3448: WHERE requisition_line_id = p_requisition_line_id(i)
3449: AND requisition_header_id = l_requisition_header_id))
3450: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3451: WHERE requisition_line_id = p_requisition_line_id(i)
3452: AND requisition_header_id = l_requisition_header_id))
3453: OR (clm_base_line_num = p_requisition_line_id(i))
3454: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all

Line 3454: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all

3450: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3451: WHERE requisition_line_id = p_requisition_line_id(i)
3452: AND requisition_header_id = l_requisition_header_id))
3453: OR (clm_base_line_num = p_requisition_line_id(i))
3454: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all
3455: WHERE requisition_line_id = p_requisition_line_id(i)
3456: AND requisition_header_id = l_requisition_header_id))
3457: OR (group_line_id IN (SELECT requisition_line_id FROM po_requisition_lines_all
3458: WHERE clm_base_line_num = p_requisition_line_id(i)

Line 3457: OR (group_line_id IN (SELECT requisition_line_id FROM po_requisition_lines_all

3453: OR (clm_base_line_num = p_requisition_line_id(i))
3454: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all
3455: WHERE requisition_line_id = p_requisition_line_id(i)
3456: AND requisition_header_id = l_requisition_header_id))
3457: OR (group_line_id IN (SELECT requisition_line_id FROM po_requisition_lines_all
3458: WHERE clm_base_line_num = p_requisition_line_id(i)
3459: AND requisition_header_id = l_requisition_header_id))
3460: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3461: WHERE clm_base_line_num = p_requisition_line_id(i)

Line 3460: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

3456: AND requisition_header_id = l_requisition_header_id))
3457: OR (group_line_id IN (SELECT requisition_line_id FROM po_requisition_lines_all
3458: WHERE clm_base_line_num = p_requisition_line_id(i)
3459: AND requisition_header_id = l_requisition_header_id))
3460: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3461: WHERE clm_base_line_num = p_requisition_line_id(i)
3462: AND requisition_header_id = l_requisition_header_id))
3463: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3464: WHERE clm_base_line_num = p_requisition_line_id(i)

Line 3463: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

3459: AND requisition_header_id = l_requisition_header_id))
3460: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3461: WHERE clm_base_line_num = p_requisition_line_id(i)
3462: AND requisition_header_id = l_requisition_header_id))
3463: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3464: WHERE clm_base_line_num = p_requisition_line_id(i)
3465: AND requisition_header_id = l_requisition_header_id))
3466: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3467: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

Line 3466: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

3462: AND requisition_header_id = l_requisition_header_id))
3463: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3464: WHERE clm_base_line_num = p_requisition_line_id(i)
3465: AND requisition_header_id = l_requisition_header_id))
3466: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3467: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3468: WHERE requisition_line_id = p_requisition_line_id(i)
3469: AND requisition_header_id = l_requisition_header_id )
3470: AND requisition_header_id = l_requisition_header_id))

Line 3467: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

3463: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3464: WHERE clm_base_line_num = p_requisition_line_id(i)
3465: AND requisition_header_id = l_requisition_header_id))
3466: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3467: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3468: WHERE requisition_line_id = p_requisition_line_id(i)
3469: AND requisition_header_id = l_requisition_header_id )
3470: AND requisition_header_id = l_requisition_header_id))
3471: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

Line 3471: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

3467: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3468: WHERE requisition_line_id = p_requisition_line_id(i)
3469: AND requisition_header_id = l_requisition_header_id )
3470: AND requisition_header_id = l_requisition_header_id))
3471: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3472: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3473: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3474: WHERE requisition_line_id = p_requisition_line_id(i)
3475: AND requisition_header_id = l_requisition_header_id)

Line 3472: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

3468: WHERE requisition_line_id = p_requisition_line_id(i)
3469: AND requisition_header_id = l_requisition_header_id )
3470: AND requisition_header_id = l_requisition_header_id))
3471: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3472: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3473: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3474: WHERE requisition_line_id = p_requisition_line_id(i)
3475: AND requisition_header_id = l_requisition_header_id)
3476: AND requisition_header_id = l_requisition_header_id)

Line 3473: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

3469: AND requisition_header_id = l_requisition_header_id )
3470: AND requisition_header_id = l_requisition_header_id))
3471: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3472: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3473: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3474: WHERE requisition_line_id = p_requisition_line_id(i)
3475: AND requisition_header_id = l_requisition_header_id)
3476: AND requisition_header_id = l_requisition_header_id)
3477: AND requisition_header_id = l_requisition_header_id))

Line 3478: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

3474: WHERE requisition_line_id = p_requisition_line_id(i)
3475: AND requisition_header_id = l_requisition_header_id)
3476: AND requisition_header_id = l_requisition_header_id)
3477: AND requisition_header_id = l_requisition_header_id))
3478: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3479: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3480: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3481: WHERE requisition_line_id = p_requisition_line_id(i)
3482: AND requisition_header_id = l_requisition_header_id)

Line 3479: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

3475: AND requisition_header_id = l_requisition_header_id)
3476: AND requisition_header_id = l_requisition_header_id)
3477: AND requisition_header_id = l_requisition_header_id))
3478: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3479: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3480: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3481: WHERE requisition_line_id = p_requisition_line_id(i)
3482: AND requisition_header_id = l_requisition_header_id)
3483: AND requisition_header_id = l_requisition_header_id)

Line 3480: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

3476: AND requisition_header_id = l_requisition_header_id)
3477: AND requisition_header_id = l_requisition_header_id))
3478: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3479: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3480: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3481: WHERE requisition_line_id = p_requisition_line_id(i)
3482: AND requisition_header_id = l_requisition_header_id)
3483: AND requisition_header_id = l_requisition_header_id)
3484: AND requisition_header_id = l_requisition_header_id)));

Line 3532: FROM po_requisition_lines_all

3528:
3529: FOR i IN 1..p_req_line_ids.Count LOOP
3530:
3531: SELECT requisition_header_id, Decode(Nvl(group_line_id, -999), -999, 'Y','N') INTO l_requisition_header_id, l_priced_clin_YN
3532: FROM po_requisition_lines_all
3533: WHERE requisition_line_id = p_req_line_ids(i);
3534:
3535: IF (l_priced_clin_YN = 'Y') THEN
3536:

Line 3537: UPDATE po_requisition_lines_all prla SET at_sourcing_flag = NULL,

3533: WHERE requisition_line_id = p_req_line_ids(i);
3534:
3535: IF (l_priced_clin_YN = 'Y') THEN
3536:
3537: UPDATE po_requisition_lines_all prla SET at_sourcing_flag = NULL,
3538: reqs_in_pool_flag = (CASE
3539: WHEN (nvl(modified_by_agent_flag,'N') = 'Y'
3540: or NVL(cancel_flag,'N') IN ('Y', 'I')
3541: or NVL(closed_code,'OPEN') = 'FINALLY CLOSED'

Line 3560: OR (group_line_id IN (SELECT requisition_line_id FROM po_requisition_lines_all

3556: WHERE requisition_header_id = l_requisition_header_id
3557: AND ((requisition_line_id = p_req_line_ids(i) )
3558: OR (group_line_id = p_req_line_ids(i))
3559: OR (clm_base_line_num = p_req_line_ids(i))
3560: OR (group_line_id IN (SELECT requisition_line_id FROM po_requisition_lines_all
3561: WHERE clm_base_line_num = p_req_line_ids(i)
3562: AND requisition_header_id = l_requisition_header_id)));
3563:
3564: ELSE

Line 3570: FROM po_requisition_lines_all

3566: BEGIN
3567:
3568:
3569: SELECT requisition_line_id INTO l_req_id
3570: FROM po_requisition_lines_all
3571: WHERE requisition_header_id = l_requisition_header_id
3572: AND ((requisition_line_id = p_req_line_ids(i) )
3573: OR (requisition_line_id = (SELECT group_line_id from po_requisition_lines_all
3574: WHERE requisition_line_id = p_req_line_ids(i)

Line 3573: OR (requisition_line_id = (SELECT group_line_id from po_requisition_lines_all

3569: SELECT requisition_line_id INTO l_req_id
3570: FROM po_requisition_lines_all
3571: WHERE requisition_header_id = l_requisition_header_id
3572: AND ((requisition_line_id = p_req_line_ids(i) )
3573: OR (requisition_line_id = (SELECT group_line_id from po_requisition_lines_all
3574: WHERE requisition_line_id = p_req_line_ids(i)
3575: AND requisition_header_id = l_requisition_header_id))
3576: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3577: WHERE requisition_line_id = p_req_line_ids(i)

Line 3576: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all

3572: AND ((requisition_line_id = p_req_line_ids(i) )
3573: OR (requisition_line_id = (SELECT group_line_id from po_requisition_lines_all
3574: WHERE requisition_line_id = p_req_line_ids(i)
3575: AND requisition_header_id = l_requisition_header_id))
3576: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3577: WHERE requisition_line_id = p_req_line_ids(i)
3578: AND requisition_header_id = l_requisition_header_id))
3579: OR (clm_base_line_num = p_req_line_ids(i))
3580: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all

Line 3580: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all

3576: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3577: WHERE requisition_line_id = p_req_line_ids(i)
3578: AND requisition_header_id = l_requisition_header_id))
3579: OR (clm_base_line_num = p_req_line_ids(i))
3580: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all
3581: WHERE requisition_line_id = p_req_line_ids(i)
3582: AND requisition_header_id = l_requisition_header_id))
3583: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3584: WHERE clm_base_line_num = p_req_line_ids(i)

Line 3583: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

3579: OR (clm_base_line_num = p_req_line_ids(i))
3580: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all
3581: WHERE requisition_line_id = p_req_line_ids(i)
3582: AND requisition_header_id = l_requisition_header_id))
3583: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3584: WHERE clm_base_line_num = p_req_line_ids(i)
3585: AND requisition_header_id = l_requisition_header_id))
3586: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3587: WHERE clm_base_line_num = p_req_line_ids(i)

Line 3586: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

3582: AND requisition_header_id = l_requisition_header_id))
3583: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3584: WHERE clm_base_line_num = p_req_line_ids(i)
3585: AND requisition_header_id = l_requisition_header_id))
3586: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3587: WHERE clm_base_line_num = p_req_line_ids(i)
3588: AND requisition_header_id = l_requisition_header_id))
3589: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3590: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

Line 3589: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

3585: AND requisition_header_id = l_requisition_header_id))
3586: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3587: WHERE clm_base_line_num = p_req_line_ids(i)
3588: AND requisition_header_id = l_requisition_header_id))
3589: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3590: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3591: WHERE requisition_line_id = p_req_line_ids(i)
3592: AND requisition_header_id = l_requisition_header_id)
3593: AND requisition_header_id = l_requisition_header_id))

Line 3590: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

3586: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3587: WHERE clm_base_line_num = p_req_line_ids(i)
3588: AND requisition_header_id = l_requisition_header_id))
3589: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3590: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3591: WHERE requisition_line_id = p_req_line_ids(i)
3592: AND requisition_header_id = l_requisition_header_id)
3593: AND requisition_header_id = l_requisition_header_id))
3594: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

Line 3594: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

3590: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3591: WHERE requisition_line_id = p_req_line_ids(i)
3592: AND requisition_header_id = l_requisition_header_id)
3593: AND requisition_header_id = l_requisition_header_id))
3594: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3595: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3596: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3597: WHERE requisition_line_id = p_req_line_ids(i)
3598: AND requisition_header_id = l_requisition_header_id)

Line 3595: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

3591: WHERE requisition_line_id = p_req_line_ids(i)
3592: AND requisition_header_id = l_requisition_header_id)
3593: AND requisition_header_id = l_requisition_header_id))
3594: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3595: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3596: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3597: WHERE requisition_line_id = p_req_line_ids(i)
3598: AND requisition_header_id = l_requisition_header_id)
3599: AND requisition_header_id = l_requisition_header_id)

Line 3596: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

3592: AND requisition_header_id = l_requisition_header_id)
3593: AND requisition_header_id = l_requisition_header_id))
3594: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3595: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3596: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3597: WHERE requisition_line_id = p_req_line_ids(i)
3598: AND requisition_header_id = l_requisition_header_id)
3599: AND requisition_header_id = l_requisition_header_id)
3600: AND requisition_header_id = l_requisition_header_id))

Line 3601: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

3597: WHERE requisition_line_id = p_req_line_ids(i)
3598: AND requisition_header_id = l_requisition_header_id)
3599: AND requisition_header_id = l_requisition_header_id)
3600: AND requisition_header_id = l_requisition_header_id))
3601: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3602: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3603: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3604: WHERE requisition_line_id = p_req_line_ids(i)
3605: AND requisition_header_id = l_requisition_header_id)

Line 3602: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

3598: AND requisition_header_id = l_requisition_header_id)
3599: AND requisition_header_id = l_requisition_header_id)
3600: AND requisition_header_id = l_requisition_header_id))
3601: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3602: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3603: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3604: WHERE requisition_line_id = p_req_line_ids(i)
3605: AND requisition_header_id = l_requisition_header_id)
3606: AND requisition_header_id = l_requisition_header_id)

Line 3603: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

3599: AND requisition_header_id = l_requisition_header_id)
3600: AND requisition_header_id = l_requisition_header_id))
3601: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3602: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3603: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3604: WHERE requisition_line_id = p_req_line_ids(i)
3605: AND requisition_header_id = l_requisition_header_id)
3606: AND requisition_header_id = l_requisition_header_id)
3607: AND requisition_header_id = l_requisition_header_id)))

Line 3614: UPDATE po_requisition_lines_all prla SET at_sourcing_flag = NULL,

3610:
3611: EXCEPTION
3612: WHEN No_Data_Found THEN
3613:
3614: UPDATE po_requisition_lines_all prla SET at_sourcing_flag = NULL,
3615: reqs_in_pool_flag = (CASE
3616: WHEN (nvl(modified_by_agent_flag,'N') = 'Y'
3617: or NVL(cancel_flag,'N') IN ('Y', 'I')
3618: or NVL(closed_code,'OPEN') = 'FINALLY CLOSED'

Line 3635: OR (requisition_line_id = (SELECT group_line_id from po_requisition_lines_all

3631: last_updated_by = FND_GLOBAL.USER_ID,
3632: last_update_login = FND_GLOBAL.LOGIN_ID
3633: WHERE requisition_header_id = l_requisition_header_id
3634: AND ((requisition_line_id = p_req_line_ids(i) )
3635: OR (requisition_line_id = (SELECT group_line_id from po_requisition_lines_all
3636: WHERE requisition_line_id = p_req_line_ids(i)
3637: AND requisition_header_id = l_requisition_header_id))
3638: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3639: WHERE requisition_line_id = p_req_line_ids(i)

Line 3638: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all

3634: AND ((requisition_line_id = p_req_line_ids(i) )
3635: OR (requisition_line_id = (SELECT group_line_id from po_requisition_lines_all
3636: WHERE requisition_line_id = p_req_line_ids(i)
3637: AND requisition_header_id = l_requisition_header_id))
3638: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3639: WHERE requisition_line_id = p_req_line_ids(i)
3640: AND requisition_header_id = l_requisition_header_id))
3641: OR (clm_base_line_num = p_req_line_ids(i))
3642: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all

Line 3642: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all

3638: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3639: WHERE requisition_line_id = p_req_line_ids(i)
3640: AND requisition_header_id = l_requisition_header_id))
3641: OR (clm_base_line_num = p_req_line_ids(i))
3642: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all
3643: WHERE requisition_line_id = p_req_line_ids(i)
3644: AND requisition_header_id = l_requisition_header_id))
3645: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3646: WHERE clm_base_line_num = p_req_line_ids(i)

Line 3645: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

3641: OR (clm_base_line_num = p_req_line_ids(i))
3642: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all
3643: WHERE requisition_line_id = p_req_line_ids(i)
3644: AND requisition_header_id = l_requisition_header_id))
3645: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3646: WHERE clm_base_line_num = p_req_line_ids(i)
3647: AND requisition_header_id = l_requisition_header_id))
3648: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3649: WHERE clm_base_line_num = p_req_line_ids(i)

Line 3648: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

3644: AND requisition_header_id = l_requisition_header_id))
3645: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3646: WHERE clm_base_line_num = p_req_line_ids(i)
3647: AND requisition_header_id = l_requisition_header_id))
3648: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3649: WHERE clm_base_line_num = p_req_line_ids(i)
3650: AND requisition_header_id = l_requisition_header_id))
3651: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3652: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

Line 3651: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

3647: AND requisition_header_id = l_requisition_header_id))
3648: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3649: WHERE clm_base_line_num = p_req_line_ids(i)
3650: AND requisition_header_id = l_requisition_header_id))
3651: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3652: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3653: WHERE requisition_line_id = p_req_line_ids(i)
3654: AND requisition_header_id = l_requisition_header_id)))
3655: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

Line 3652: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

3648: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3649: WHERE clm_base_line_num = p_req_line_ids(i)
3650: AND requisition_header_id = l_requisition_header_id))
3651: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3652: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3653: WHERE requisition_line_id = p_req_line_ids(i)
3654: AND requisition_header_id = l_requisition_header_id)))
3655: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3656: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

Line 3655: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

3651: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3652: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3653: WHERE requisition_line_id = p_req_line_ids(i)
3654: AND requisition_header_id = l_requisition_header_id)))
3655: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3656: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3657: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3658: WHERE requisition_line_id = p_req_line_ids(i)
3659: AND requisition_header_id = l_requisition_header_id)

Line 3656: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

3652: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3653: WHERE requisition_line_id = p_req_line_ids(i)
3654: AND requisition_header_id = l_requisition_header_id)))
3655: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3656: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3657: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3658: WHERE requisition_line_id = p_req_line_ids(i)
3659: AND requisition_header_id = l_requisition_header_id)
3660: AND requisition_header_id = l_requisition_header_id )

Line 3657: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

3653: WHERE requisition_line_id = p_req_line_ids(i)
3654: AND requisition_header_id = l_requisition_header_id)))
3655: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3656: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3657: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3658: WHERE requisition_line_id = p_req_line_ids(i)
3659: AND requisition_header_id = l_requisition_header_id)
3660: AND requisition_header_id = l_requisition_header_id )
3661: AND requisition_header_id = l_requisition_header_id))

Line 3662: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

3658: WHERE requisition_line_id = p_req_line_ids(i)
3659: AND requisition_header_id = l_requisition_header_id)
3660: AND requisition_header_id = l_requisition_header_id )
3661: AND requisition_header_id = l_requisition_header_id))
3662: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3663: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3664: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3665: WHERE requisition_line_id = p_req_line_ids(i)
3666: AND requisition_header_id = l_requisition_header_id)

Line 3663: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

3659: AND requisition_header_id = l_requisition_header_id)
3660: AND requisition_header_id = l_requisition_header_id )
3661: AND requisition_header_id = l_requisition_header_id))
3662: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3663: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3664: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3665: WHERE requisition_line_id = p_req_line_ids(i)
3666: AND requisition_header_id = l_requisition_header_id)
3667: AND requisition_header_id = l_requisition_header_id)

Line 3664: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

3660: AND requisition_header_id = l_requisition_header_id )
3661: AND requisition_header_id = l_requisition_header_id))
3662: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
3663: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
3664: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
3665: WHERE requisition_line_id = p_req_line_ids(i)
3666: AND requisition_header_id = l_requisition_header_id)
3667: AND requisition_header_id = l_requisition_header_id)
3668: AND requisition_header_id = l_requisition_header_id)) );

Line 3721: --update sol ref in po_requisition_lines_all

3717: IF p_delete_pbr_yn = 'Y' THEN
3718: DELETE FROM pon_backing_requisitions WHERE auction_header_id = p_auction_header_id;
3719: END IF;
3720:
3721: --update sol ref in po_requisition_lines_all
3722:
3723: update po_requisition_lines_all prla
3724: set auction_header_id = null,
3725: auction_display_number = null,

Line 3723: update po_requisition_lines_all prla

3719: END IF;
3720:
3721: --update sol ref in po_requisition_lines_all
3722:
3723: update po_requisition_lines_all prla
3724: set auction_header_id = null,
3725: auction_display_number = null,
3726: auction_line_number = null,
3727: at_sourcing_flag = null,

Line 3822: current auction_header_id then update sol ref in po_requisition_lines_all*/

3818:
3819: END IF;
3820:
3821: /*IF the deleted req line id is not referred anywhere other than in this line for the
3822: current auction_header_id then update sol ref in po_requisition_lines_all*/
3823:
3824: IF (p_table_name = 'PON_BACKING_REQUISITIONS') THEN
3825:
3826: UPDATE po_requisition_lines_all prl SET auction_header_id = NULL,

Line 3826: UPDATE po_requisition_lines_all prl SET auction_header_id = NULL,

3822: current auction_header_id then update sol ref in po_requisition_lines_all*/
3823:
3824: IF (p_table_name = 'PON_BACKING_REQUISITIONS') THEN
3825:
3826: UPDATE po_requisition_lines_all prl SET auction_header_id = NULL,
3827: auction_line_number = NULL,
3828: auction_display_number = NULL,
3829: last_update_date = SYSDATE,
3830: last_updated_by = FND_GLOBAL.USER_ID,

Line 3841: UPDATE po_requisition_lines_all prl SET auction_header_id = NULL,

3837: GROUP BY requisition_line_id )
3838: RETURNING requisition_line_id BULK COLLECT INTO l_req_line_ids;
3839:
3840: ELSE
3841: UPDATE po_requisition_lines_all prl SET auction_header_id = NULL,
3842: auction_line_number = NULL,
3843: auction_display_number = NULL,
3844: bid_number = NULL,
3845: bid_line_number = NULL,

Line 3911: /Update ref of auction in po_requisition_lines_all table only for those lines copied to the new auction/

3907: OPEN c_deleted_pr_ref_csr;
3908: FETCH c_deleted_pr_ref_csr BULK COLLECT INTO l_req_line_ids;
3909: CLOSE c_deleted_pr_ref_csr;
3910:
3911: /*Update ref of auction in po_requisition_lines_all table only for those lines copied to the new auction*/
3912:
3913: UPDATE po_requisition_lines_all prl SET auction_header_id = p_new_auction_id
3914: WHERE EXISTS (SELECT DISTINCT(requisition_line_id)
3915: FROM pon_backing_requisitions pbr

Line 3913: UPDATE po_requisition_lines_all prl SET auction_header_id = p_new_auction_id

3909: CLOSE c_deleted_pr_ref_csr;
3910:
3911: /*Update ref of auction in po_requisition_lines_all table only for those lines copied to the new auction*/
3912:
3913: UPDATE po_requisition_lines_all prl SET auction_header_id = p_new_auction_id
3914: WHERE EXISTS (SELECT DISTINCT(requisition_line_id)
3915: FROM pon_backing_requisitions pbr
3916: WHERE auction_header_id = p_new_auction_id
3917: AND prl.requisition_line_id = pbr.requisition_line_id);

Line 3919: /* For deleted PR references remove sol references in po_requisition_lines_all*/

3915: FROM pon_backing_requisitions pbr
3916: WHERE auction_header_id = p_new_auction_id
3917: AND prl.requisition_line_id = pbr.requisition_line_id);
3918:
3919: /* For deleted PR references remove sol references in po_requisition_lines_all*/
3920: UPDATE po_requisition_lines_all SET auction_header_id = NULL,
3921: auction_line_number = NULL,
3922: auction_display_number = NULL,
3923: last_update_date = SYSDATE,

Line 3920: UPDATE po_requisition_lines_all SET auction_header_id = NULL,

3916: WHERE auction_header_id = p_new_auction_id
3917: AND prl.requisition_line_id = pbr.requisition_line_id);
3918:
3919: /* For deleted PR references remove sol references in po_requisition_lines_all*/
3920: UPDATE po_requisition_lines_all SET auction_header_id = NULL,
3921: auction_line_number = NULL,
3922: auction_display_number = NULL,
3923: last_update_date = SYSDATE,
3924: last_updated_by = FND_GLOBAL.USER_ID,