APPS.POS_EXCELASN_PVT dependencies on PO_TBL_NUMBER

Line 283: l_n_attributes_tbl po_tbl_number := po_tbl_number();

279: l_nattribute9 number;
280: l_nattribute10 number;
281:
282: l_c_attributes_tbl po_tbl_varchar2000 := po_tbl_varchar2000();
283: l_n_attributes_tbl po_tbl_number := po_tbl_number();
284: l_d_attributes_tbl po_tbl_date := po_tbl_date();
285:
286: l_grade_code varchar2(2000);
287: l_origination_date date;

Line 4219: l_lineIdTbl po_tbl_number := po_tbl_number();

4215: and pht.ship_from_location_code is not null
4216: and ps.party_site_number = pht.ship_from_location_code||'|'||pht.vendor_id
4217: order by pht.header_id;
4218:
4219: l_lineIdTbl po_tbl_number := po_tbl_number();
4220: l_lineLocIdTbl po_tbl_number := po_tbl_number();
4221: l_count NUMBER := 0;
4222: l_return_status VARCHAR2(2000);
4223: l_prev_header_id pos_exasn_headers.header_id%type := -1;

Line 4220: l_lineLocIdTbl po_tbl_number := po_tbl_number();

4216: and ps.party_site_number = pht.ship_from_location_code||'|'||pht.vendor_id
4217: order by pht.header_id;
4218:
4219: l_lineIdTbl po_tbl_number := po_tbl_number();
4220: l_lineLocIdTbl po_tbl_number := po_tbl_number();
4221: l_count NUMBER := 0;
4222: l_return_status VARCHAR2(2000);
4223: l_prev_header_id pos_exasn_headers.header_id%type := -1;
4224: l_prev_ship_from VARCHAR2(30) := '';

Line 4323: l_LineIdTbl := po_tbl_number();

4319: end if;
4320:
4321: else
4322: -- empty the linelocid table and shiplocid table and prepare for new validation
4323: l_LineIdTbl := po_tbl_number();
4324: l_LineLocIdTbl := po_tbl_number();
4325: end if;
4326: end if;
4327: l_lineIdTbl.EXTEND;

Line 4324: l_LineLocIdTbl := po_tbl_number();

4320:
4321: else
4322: -- empty the linelocid table and shiplocid table and prepare for new validation
4323: l_LineIdTbl := po_tbl_number();
4324: l_LineLocIdTbl := po_tbl_number();
4325: end if;
4326: end if;
4327: l_lineIdTbl.EXTEND;
4328: l_lineLocIdTbl.EXTEND;