DBA Data[Home] [Help]

APPS.PO_INTERFACE_S dependencies on PO_TBL_NUMBER

Line 446: , x_line_loc_id_tbl OUT NOCOPY po_tbl_number

442: , p_po_line_id IN NUMBER
443: , p_precision IN NUMBER
444: , p_ext_precision IN NUMBER
445: , x_line_location_id OUT NOCOPY NUMBER
446: , x_line_loc_id_tbl OUT NOCOPY po_tbl_number
447: );
448:
449: PROCEDURE create_payitem_dists(
450: p_po_line_id IN NUMBER

Line 3021: l_line_loc_id_tbl po_tbl_number;

3017: --declared x_amount
3018: x_amount number;
3019:
3020: x_line_location_id number := null;
3021: l_line_loc_id_tbl po_tbl_number;
3022:
3023: l_price_break_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;--
3024:
3025: x_quote_header_id number := null;

Line 14909: , x_line_loc_id_tbl OUT NOCOPY po_tbl_number

14905: , p_po_line_id IN NUMBER
14906: , p_precision IN NUMBER
14907: , p_ext_precision IN NUMBER
14908: , x_line_location_id OUT NOCOPY NUMBER
14909: , x_line_loc_id_tbl OUT NOCOPY po_tbl_number
14910: )
14911: IS
14912:
14913: d_progress NUMBER;

Line 14943: l_payitem_tax_code_id_tbl po_tbl_number;

14939:
14940: l_isFinancing BOOLEAN;
14941: l_ship_to_location_id NUMBER;
14942:
14943: l_payitem_tax_code_id_tbl po_tbl_number;
14944: l_payitems_created NUMBER;
14945:
14946: l_routing_name RCV_ROUTING_HEADERS.routing_name%TYPE;
14947: l_line_loc_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

Line 15276: x_line_loc_id_tbl := po_tbl_number();

15272:
15273: END IF; -- if interface.requisition_line_id IS NOT NULL
15274:
15275: d_progress := 150;
15276: x_line_loc_id_tbl := po_tbl_number();
15277: l_payitem_tax_code_id_tbl := po_tbl_number();
15278: l_payitems_created := 0;
15279:
15280: -- now iterate over the rows in the interface table

Line 15277: l_payitem_tax_code_id_tbl := po_tbl_number();

15273: END IF; -- if interface.requisition_line_id IS NOT NULL
15274:
15275: d_progress := 150;
15276: x_line_loc_id_tbl := po_tbl_number();
15277: l_payitem_tax_code_id_tbl := po_tbl_number();
15278: l_payitems_created := 0;
15279:
15280: -- now iterate over the rows in the interface table
15281: -- for each row, get the default tax, receiving controls, and country of

Line 15672: l_line_loc_id_tbl po_tbl_number;

15668: AND pod.req_distribution_id IS NULL;
15669:
15670: payitem_acct_rec payitem_acct_gen_cursor%ROWTYPE;
15671:
15672: l_line_loc_id_tbl po_tbl_number;
15673: l_line_loc_value_basis_tbl po_tbl_varchar30;
15674: l_dist_id_tbl po_tbl_number;
15675:
15676: l_return_status VARCHAR2(1);

Line 15674: l_dist_id_tbl po_tbl_number;

15670: payitem_acct_rec payitem_acct_gen_cursor%ROWTYPE;
15671:
15672: l_line_loc_id_tbl po_tbl_number;
15673: l_line_loc_value_basis_tbl po_tbl_varchar30;
15674: l_dist_id_tbl po_tbl_number;
15675:
15676: l_return_status VARCHAR2(1);
15677: l_msg_count NUMBER;
15678: l_msg_data VARCHAR2(2000);