APPS.POS_EXCELASN_PVT dependencies on POS_EXCELASN_ERROR_TABLE

Line 13: x_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,

9: x_return_status out nocopy varchar2,
10: x_user_vendor_id_tbl out nocopy vendor_id_tbl_type,
11: x_secure_by_site out nocopy varchar2,
12: x_secure_by_contact out nocopy varchar2,
13: x_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,
14: x_error_pointer in out nocopy number
15: );
16: ------------------------------------------------------------------
17:

Line 157: x_error_tbl in out NOCOPY POS_EXCELASN_ERROR_TABLE,

153: end get_status;
154:
155:
156: procedure ValidateLls(x_return_status out nocopy varchar2,
157: x_error_tbl in out NOCOPY POS_EXCELASN_ERROR_TABLE,
158: x_error_pointer in out NOCOPY number)
159: IS
160: cursor l_ParentQtyNull_csr
161: is

Line 781: x_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,

777: procedure ValidateLines(x_return_status out nocopy varchar2,
778: p_user_vendor_id_tbl in vendor_id_tbl_type,
779: p_secure_by_site in varchar2,
780: p_secure_by_contact in varchar2,
781: x_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,
782: x_error_pointer in out nocopy number)
783: IS
784:
785: l_doc_num po_headers_all.segment1%type;

Line 1424: p_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,

1420: END ValidateLines;
1421:
1422:
1423: procedure ValidateHeaders(x_return_status out nocopy varchar2,
1424: p_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,
1425: p_error_pointer in out nocopy number)
1426: IS
1427: l_error_ln number;
1428: l_error_field varchar2(200);

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

1634: x_return_status := 'U';
1635: end ValidateHeaders;
1636:
1637:
1638: procedure UpdateLinesAndLls(x_error_tbl in out NOCOPY POS_EXCELASN_ERROR_TABLE,
1639: l_error_pointer in out NOCOPY number)
1640: IS
1641: l_uom pos_exasn_lines.uom%type;
1642: l_po_line_location_id number;

Line 2170: p_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,

2166: */
2167: end CreateRTI4Lot;
2168:
2169: procedure InsertIntoLLS(x_return_status out nocopy varchar2,
2170: p_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,
2171: p_error_pointer in out nocopy number)
2172: is
2173: cursor l_allLots_csr
2174: is

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

2815: end if;
2816: end InsertIntoLLS;
2817:
2818:
2819: function InsertError(p_error_tbl in out NOCOPY POS_EXCELASN_ERROR_TABLE,
2820: p_error_msg in varchar2,
2821: p_error_index in out NOCOPY number)
2822: return number
2823: is

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

2833: end if;
2834: end InsertError;
2835:
2836:
2837: procedure FixHeadersAndLines(x_error_tbl in out NOCOPY POS_EXCELASN_ERROR_TABLE,
2838: l_error_pointer in out NOCOPY number)
2839: is
2840: l_asn_header_id number;
2841: l_ex_header_id number;

Line 3423: x_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,

3419: END;
3420:
3421:
3422: procedure CheckLlsControl(x_return_status out nocopy varchar2,
3423: x_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,
3424: l_error_pointer in out nocopy number)
3425: IS
3426: l_25errors exception;
3427: l_error_ln number;

Line 3850: x_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,

3846: x_return_status out nocopy varchar2,
3847: x_user_vendor_id_tbl out nocopy vendor_id_tbl_type,
3848: x_secure_by_site out nocopy varchar2,
3849: x_secure_by_contact out nocopy varchar2,
3850: x_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,
3851: x_error_pointer in out nocopy number
3852: )
3853: IS
3854: l_num number;

Line 4070: x_error_tbl out NOCOPY POS_EXCELASN_ERROR_TABLE,

4066: procedure ProcessExcelAsn(p_api_version in number,
4067: x_return_status out nocopy varchar2,
4068: x_return_code out nocopy varchar2,
4069: x_return_msg out nocopy varchar2,
4070: x_error_tbl out NOCOPY POS_EXCELASN_ERROR_TABLE,
4071: x_user_vendor_id out nocopy number)
4072: is
4073: x_progress varchar2(10);
4074: l_header_status varchar2(1);

Line 4164: x_error_tbl := POS_EXCELASN_ERROR_TABLE();

4160: begin
4161:
4162: x_progress := '000';
4163: x_return_status := FND_API.G_RET_STS_SUCCESS;
4164: x_error_tbl := POS_EXCELASN_ERROR_TABLE();
4165:
4166: --x_user_vendor_id will no longer be retrieved from the secured attribute,
4167: --ICX_SUPPLIER_ORG_ID
4168: SELECT FND_GLOBAL.USER_NAME INTO l_user_name FROM DUAL;