1 PACKAGE Pos_ExcelAsn_PVT AUTHID CURRENT_USER AS
2 /* $Header: POSVEXAS.pls 120.1.12010000.2 2008/11/07 20:23:47 sthoppan ship $ */
3
4
5 TYPE vendor_id_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6
7 procedure ProcessExcelAsn(p_api_version in number,
8 x_return_status out nocopy varchar2,
9 x_return_code out nocopy varchar2,
10 x_return_msg out nocopy varchar2,
11 x_error_tbl out NOCOPY POS_EXCELASN_ERROR_TABLE,
12 x_user_vendor_id out nocopy number);
13
14
15 function getConvertedQuantity(p_line_location_id in number,
16 p_quantity in number,
17 p_uom in varchar2
18 ) return number;
19
20 procedure CheckLlsControl(x_return_status out nocopy varchar2,
21 x_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,
22 l_error_pointer in out nocopy number);
23 procedure CreateNewHeader(p_asn_header_id in number, p_ex_header_id in number,
24 p_ex_vendor_id in number, p_ex_ship_to_org_id in number, p_ex_vendor_site_id in number);
25
26 procedure CreateNewLine(p_qty in number, p_lpn in varchar2, p_line_id in number, p_old_ln in number);
27 procedure FixHeadersAndLines(x_error_tbl in out NOCOPY POS_EXCELASN_ERROR_TABLE,
28 l_error_pointer in out NOCOPY number);
29
30 function InsertError(p_error_tbl in out NOCOPY POS_EXCELASN_ERROR_TABLE,
31 p_error_msg in varchar2,
32 p_error_index in out NOCOPY number)
33 return number;
34 procedure InsertIntoLLS(x_return_status out nocopy varchar2,
35 p_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,
36 p_error_pointer in out nocopy number);
37
38 procedure CreateRTI4Lot;
39 procedure CreateRTI4Lpn;
40 procedure CreateRTI4Ser;
41 procedure UpdateLinesAndLls(x_error_tbl in out NOCOPY POS_EXCELASN_ERROR_TABLE,
42 l_error_pointer in out NOCOPY number);
43 procedure ValidateHeaders(x_return_status out nocopy varchar2,
44 p_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,
45 p_error_pointer in out nocopy number);
46 procedure ValidateLines(x_return_status out nocopy varchar2,
47 p_user_vendor_id_tbl in vendor_id_tbl_type,
48 p_secure_by_site in varchar2,
49 p_secure_by_contact in varchar2,
50 x_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,
51 x_error_pointer in out nocopy number);
52 procedure ValidateLls(x_return_status out nocopy varchar2,
53 x_error_tbl in out NOCOPY POS_EXCELASN_ERROR_TABLE,
54 x_error_pointer in out NOCOPY number);
55
56 function get_status(p_group_id in number) return varchar2;
57
58 --Refer the bug 7338353 and its package body for more information
59 function getvendorpaysiteid(p_vendor_id in varchar2,p_vendor_site_id IN varchar2,p_currency_code IN varchar2) RETURN PO_VENDOR_SITES_ALL.vendor_site_id%TYPE;
60
61
62 END Pos_ExcelAsn_PVT;