DBA Data[Home] [Help]

APPS.PO_INTERFACE_S dependencies on PO_TBL_NUMBER

Line 439: , x_line_loc_id_tbl OUT NOCOPY po_tbl_number

435: , p_po_line_id IN NUMBER
436: , p_precision IN NUMBER
437: , p_ext_precision IN NUMBER
438: , x_line_location_id OUT NOCOPY NUMBER
439: , x_line_loc_id_tbl OUT NOCOPY po_tbl_number
440: );
441:
442: PROCEDURE create_payitem_dists(
443: p_po_line_id IN NUMBER

Line 2684: l_line_loc_id_tbl po_tbl_number;

2680: x_quantity number := '';
2681: x_requisition_header_id number := ''; /* Used for copying attachments */
2682:
2683: x_line_location_id number := null;
2684: l_line_loc_id_tbl po_tbl_number;
2685:
2686: l_price_break_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;--
2687:
2688: x_quote_header_id number := null;

Line 14003: , x_line_loc_id_tbl OUT NOCOPY po_tbl_number

13999: , p_po_line_id IN NUMBER
14000: , p_precision IN NUMBER
14001: , p_ext_precision IN NUMBER
14002: , x_line_location_id OUT NOCOPY NUMBER
14003: , x_line_loc_id_tbl OUT NOCOPY po_tbl_number
14004: )
14005: IS
14006:
14007: d_progress NUMBER;

Line 14037: l_payitem_tax_code_id_tbl po_tbl_number;

14033:
14034: l_isFinancing BOOLEAN;
14035: l_ship_to_location_id NUMBER;
14036:
14037: l_payitem_tax_code_id_tbl po_tbl_number;
14038: l_payitems_created NUMBER;
14039:
14040: l_routing_name RCV_ROUTING_HEADERS.routing_name%TYPE;
14041: l_line_loc_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

Line 14368: x_line_loc_id_tbl := po_tbl_number();

14364:
14365: END IF; -- if interface.requisition_line_id IS NOT NULL
14366:
14367: d_progress := 150;
14368: x_line_loc_id_tbl := po_tbl_number();
14369: l_payitem_tax_code_id_tbl := po_tbl_number();
14370: l_payitems_created := 0;
14371:
14372: -- now iterate over the rows in the interface table

Line 14369: l_payitem_tax_code_id_tbl := po_tbl_number();

14365: END IF; -- if interface.requisition_line_id IS NOT NULL
14366:
14367: d_progress := 150;
14368: x_line_loc_id_tbl := po_tbl_number();
14369: l_payitem_tax_code_id_tbl := po_tbl_number();
14370: l_payitems_created := 0;
14371:
14372: -- now iterate over the rows in the interface table
14373: -- for each row, get the default tax, receiving controls, and country of

Line 14763: l_line_loc_id_tbl po_tbl_number;

14759: AND pod.req_distribution_id IS NULL;
14760:
14761: payitem_acct_rec payitem_acct_gen_cursor%ROWTYPE;
14762:
14763: l_line_loc_id_tbl po_tbl_number;
14764: l_line_loc_value_basis_tbl po_tbl_varchar30;
14765: l_dist_id_tbl po_tbl_number;
14766:
14767: l_return_status VARCHAR2(1);

Line 14765: l_dist_id_tbl po_tbl_number;

14761: payitem_acct_rec payitem_acct_gen_cursor%ROWTYPE;
14762:
14763: l_line_loc_id_tbl po_tbl_number;
14764: l_line_loc_value_basis_tbl po_tbl_varchar30;
14765: l_dist_id_tbl po_tbl_number;
14766:
14767: l_return_status VARCHAR2(1);
14768: l_msg_count NUMBER;
14769: l_msg_data VARCHAR2(2000);