DBA Data[Home] [Help]

APPS.POS_EXCELASN_PVT dependencies on POS_EXCELASN_ERROR_TABLE

Line 11: x_error_tbl out NOCOPY POS_EXCELASN_ERROR_TABLE,

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,

Line 21: x_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,

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:

Line 27: procedure FixHeadersAndLines(x_error_tbl in out NOCOPY POS_EXCELASN_ERROR_TABLE,

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,

Line 30: function InsertError(p_error_tbl in out NOCOPY POS_EXCELASN_ERROR_TABLE,

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,

Line 35: 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;

Line 41: procedure UpdateLinesAndLls(x_error_tbl in out NOCOPY POS_EXCELASN_ERROR_TABLE,

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);

Line 44: p_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,

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,

Line 50: x_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,

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);

Line 53: x_error_tbl in out NOCOPY POS_EXCELASN_ERROR_TABLE,

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: