[Home] [Help]
197: );
198:
199: -------------------------------------------------------------------------
200: -- po_lines_rec_type holds the values that will be inserted in
201: -- po_lines_interface table
202: -- item_id - Item unique identifier
203: -- unit_price - Unit price for the line
204: -- list_price_per_unit - List price for the item on the line
205: -- need_by_date - Date the goods are needed by
214: quantity okc_k_items.number_of_items%type,
215: unit_price okc_k_lines_b.price_negotiated%type,
216: list_price_per_unit okc_k_lines_b.price_unit%type,
217: need_by_date okc_k_lines_b.start_date%type,
218: interface_line_id po_lines_interface.interface_line_id%type,
219: po_line_id po_lines_interface.po_line_id%type,
220: interface_header_id po_headers_interface.interface_header_id%type,
221: ship_to_organization_id okc_rules_b.object1_id1%type,
222: ship_to_location_id okc_rules_b.object1_id1%type,
215: unit_price okc_k_lines_b.price_negotiated%type,
216: list_price_per_unit okc_k_lines_b.price_unit%type,
217: need_by_date okc_k_lines_b.start_date%type,
218: interface_line_id po_lines_interface.interface_line_id%type,
219: po_line_id po_lines_interface.po_line_id%type,
220: interface_header_id po_headers_interface.interface_header_id%type,
221: ship_to_organization_id okc_rules_b.object1_id1%type,
222: ship_to_location_id okc_rules_b.object1_id1%type,
223: terms_id okc_rules_b.object1_id1%type,
232: -------------------------------------------------------------------------
233:
234: TYPE po_distributions_rec_type IS RECORD(
235: interface_header_id po_headers_interface.interface_header_id%type,
236: interface_line_id po_lines_interface.interface_line_id%type,
237: interface_distribution_id po_distributions_interface.interface_distribution_id%type,
238: org_id okc_k_headers_b.authoring_org_id%type,
239: quantity_ordered okc_k_items.number_of_items%type,
240: charge_account_id po_distributions_interface.charge_account_id%TYPE
912: -- In Parameters: p_chr_id Contract header id
913: --
914: -- Out Parameters: x_return_status Standard return status
915: -- x_po_header_rec Record to hold po header interface data
916: -- x_po_lines_tab Table to hold po lines interface data
917: -- x_po_dist_tab Table to hold po distributions interface data
918: --------------------------------------------------------------------------------
919:
920: PROCEDURE get_k_info (p_chr_id IN okc_k_headers_b.ID%TYPE
1085:
1086:
1087: x_po_lines_tab(l_idx).interface_header_id := x_po_header_rec.interface_header_id;
1088:
1089: -- making this select separately as I got an error when selecting po_lines_interface_s.NEXTVAL in the c_top_cle cursor above
1090:
1091: SELECT po_lines_interface_s.NEXTVAL
1092: INTO x_po_lines_tab(l_idx).interface_line_id
1093: FROM dual;
1087: x_po_lines_tab(l_idx).interface_header_id := x_po_header_rec.interface_header_id;
1088:
1089: -- making this select separately as I got an error when selecting po_lines_interface_s.NEXTVAL in the c_top_cle cursor above
1090:
1091: SELECT po_lines_interface_s.NEXTVAL
1092: INTO x_po_lines_tab(l_idx).interface_line_id
1093: FROM dual;
1094:
1095: x_po_dist_tab(l_idx).interface_header_id := x_po_header_rec.interface_header_id;
1446: --------------------------------------------------------------------------------
1447: -- Purpose: Populate purchase order lines interface table and create
1448: -- related objects for lines
1449: --
1450: -- In Parameters: p_po_lines_tab Table to hold po lines interface data
1451: --
1452: -- Out Parameters: x_return_status Standard return status
1453: ----------------------------------------------------------------------------
1454:
1541: IF p_po_lines_tab.first is not NULL
1542: THEN
1543: FORALL i IN p_po_lines_tab.first..p_po_lines_tab.last
1544:
1545: INSERT INTO PO_LINES_INTERFACE
1546: (
1547: interface_line_id,
1548: interface_header_id,
1549: line_num,