APPS.PON_UNSOL_CREATE_PO_PKG dependencies on PO_LINES_INTERFACE

Line 14: INSERT into PO_LINES_INTERFACE (

10: p_is_fed IN VARCHAR2,
11: p_user_id IN NUMBER) IS
12:
13: BEGIN
14: INSERT into PO_LINES_INTERFACE (
15: interface_header_id,
16: interface_line_id,
17: requisition_line_id,
18: line_type_id,

Line 75: po_lines_interface_s.nextval, -- interface_line_id

71: CLM_POP_DURATION_UOM
72: )
73: SELECT
74: p_interface_header_id, -- interface_header_id
75: po_lines_interface_s.nextval, -- interface_line_id
76: NULL, -- requisition_line_id
77: pbip.line_type_id, -- line_type_id
78: NULL,--pbip.item_id, -- item_id
79: NULL,--pbip.item_revision, -- item_revision

Line 225: po_lines_interface pli,

221: pbav.value,
222: paa.attribute_name
223: FROM pon_bid_item_prices pbip,
224: pon_auction_headers_all pah,
225: po_lines_interface pli,
226: pon_bid_attribute_values pbav,
227: pon_auction_attributes paa,
228: icx_cat_agreement_attrs_v icx
229: WHERE pbip.auction_header_id = p_auction_header_id AND

Line 477: INSERT into PO_LINES_INTERFACE (

473: p_is_fed IN VARCHAR2,
474: p_user_id IN NUMBER,
475: x_rows_processed IN OUT NOCOPY NUMBER) IS
476: BEGIN
477: INSERT into PO_LINES_INTERFACE (
478: interface_header_id,
479: interface_line_id,
480: requisition_line_id,
481: line_type_id,

Line 530: po_lines_interface_s.nextval, -- interface_line_id

526:
527: )
528: SELECT
529: p_interface_header_id, -- interface_header_id
530: po_lines_interface_s.nextval, -- interface_line_id
531: NULL, -- requisition_line_id
532: pbip.line_type_id, -- line_type_id
533: x_rows_processed + rownum, -- line num
534: null, -- item_id

Line 611: UPDATE po_lines_interface PLI1

607: x_rows_processed := SQL%ROWCOUNT;
608:
609: -- If unsol lines are inserted, update group_line_id's accordingly.
610: IF Nvl(p_is_fed,'N') = 'Y' AND x_rows_processed > 0 THEN
611: UPDATE po_lines_interface PLI1
612: SET PLI1.group_line_id = (select PLI2.interface_line_id from po_lines_interface PLI2
613: where PLI2.interface_header_id = p_interface_header_id
614: and PLI2.auction_header_id = p_auction_header_id
615: and PLI2.auction_line_number = PLI1.group_line_id

Line 612: SET PLI1.group_line_id = (select PLI2.interface_line_id from po_lines_interface PLI2

608:
609: -- If unsol lines are inserted, update group_line_id's accordingly.
610: IF Nvl(p_is_fed,'N') = 'Y' AND x_rows_processed > 0 THEN
611: UPDATE po_lines_interface PLI1
612: SET PLI1.group_line_id = (select PLI2.interface_line_id from po_lines_interface PLI2
613: where PLI2.interface_header_id = p_interface_header_id
614: and PLI2.auction_header_id = p_auction_header_id
615: and PLI2.auction_line_number = PLI1.group_line_id
616: AND PLI2.group_line_id IS NULL )