APPS.OKC_CREATE_PO_FROM_K_PVT dependencies on PO_DISTRIBUTIONS_INTERFACE

Line 229: -- po_distributions_interface table

225: );
226:
227: -------------------------------------------------------------------------
228: -- po_distributions_rec_type holds the values that will be inserted in
229: -- po_distributions_interface table
230: -- interface_distribution_id - Interface line unique identifier
231: -- interface_line_id - Unit price for the line
232: -------------------------------------------------------------------------
233:

Line 237: interface_distribution_id po_distributions_interface.interface_distribution_id%type,

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
241: );

Line 240: charge_account_id po_distributions_interface.charge_account_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
241: );
242:
243:
244: ----------------------------------------------------------------------------

Line 917: -- x_po_dist_tab Table to hold po distributions interface data

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
921: ,x_return_status OUT NOCOPY VARCHAR2

Line 1695: -- In Parameters: p_po_dist_tab Table to hold po distributions interface data

1691: ------------- Procedure: insert_po_distributions ---------------------
1692: --------------------------------------------------------------------------------
1693: -- Purpose: Populate purchase order distributions interface table
1694:
1695: -- In Parameters: p_po_dist_tab Table to hold po distributions interface data
1696:
1697: -- Out Parameters: x_return_status Standard return status
1698: ------------------------------------------------------------------------------------
1699:

Line 1747: INSERT INTO PO_DISTRIBUTIONS_INTERFACE

1743:
1744: IF p_po_dist_tab.first is not NULL THEN
1745: FORALL i IN p_po_dist_tab.first..p_po_dist_tab.last
1746:
1747: INSERT INTO PO_DISTRIBUTIONS_INTERFACE
1748: (
1749: interface_header_id,
1750: interface_line_id,
1751: interface_distribution_id,

Line 1762: po_distributions_interface_s.NEXTVAL, -- interface_distribution_id

1758: VALUES
1759: (
1760: ls_interface_header_id(i), -- interface_header_id
1761: ls_interface_line_id(i), -- interface_line_id
1762: po_distributions_interface_s.NEXTVAL, -- interface_distribution_id
1763: 1, -- distribution_num
1764: ls_org_id(i), -- org_id
1765: ls_quantity_ordered(i), -- quantity_ordered
1766: g_po_dis_destination_type_code, -- destination_type_code