DBA Data[Home] [Help]

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 4145: l_lineIdTbl po_tbl_number := po_tbl_number();

4141: and pht.ship_from_location_code is not null
4142: and ps.party_site_number = pht.ship_from_location_code||'|'||pht.vendor_id
4143: order by pht.header_id;
4144:
4145: l_lineIdTbl po_tbl_number := po_tbl_number();
4146: l_lineLocIdTbl po_tbl_number := po_tbl_number();
4147: l_count NUMBER := 0;
4148: l_return_status VARCHAR2(2000);
4149: l_prev_header_id pos_exasn_headers.header_id%type := -1;

Line 4146: l_lineLocIdTbl po_tbl_number := po_tbl_number();

4142: and ps.party_site_number = pht.ship_from_location_code||'|'||pht.vendor_id
4143: order by pht.header_id;
4144:
4145: l_lineIdTbl po_tbl_number := po_tbl_number();
4146: l_lineLocIdTbl po_tbl_number := po_tbl_number();
4147: l_count NUMBER := 0;
4148: l_return_status VARCHAR2(2000);
4149: l_prev_header_id pos_exasn_headers.header_id%type := -1;
4150: l_prev_ship_from VARCHAR2(30) := '';

Line 4249: l_LineIdTbl := po_tbl_number();

4245: end if;
4246:
4247: else
4248: -- empty the linelocid table and shiplocid table and prepare for new validation
4249: l_LineIdTbl := po_tbl_number();
4250: l_LineLocIdTbl := po_tbl_number();
4251: end if;
4252: end if;
4253: l_lineIdTbl.EXTEND;

Line 4250: l_LineLocIdTbl := po_tbl_number();

4246:
4247: else
4248: -- empty the linelocid table and shiplocid table and prepare for new validation
4249: l_LineIdTbl := po_tbl_number();
4250: l_LineLocIdTbl := po_tbl_number();
4251: end if;
4252: end if;
4253: l_lineIdTbl.EXTEND;
4254: l_lineLocIdTbl.EXTEND;