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 1494: p_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,

1490: END ValidateLines;
1491:
1492:
1493: procedure ValidateHeaders(x_return_status out nocopy varchar2,
1494: p_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,
1495: p_error_pointer in out nocopy number)
1496: IS
1497: l_error_ln number;
1498: l_error_field varchar2(200);

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

1704: x_return_status := 'U';
1705: end ValidateHeaders;
1706:
1707:
1708: procedure UpdateLinesAndLls(x_error_tbl in out NOCOPY POS_EXCELASN_ERROR_TABLE,
1709: l_error_pointer in out NOCOPY number)
1710: IS
1711: l_uom pos_exasn_lines.uom%type;
1712: l_po_line_location_id number;

Line 2240: p_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,

2236: */
2237: end CreateRTI4Lot;
2238:
2239: procedure InsertIntoLLS(x_return_status out nocopy varchar2,
2240: p_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,
2241: p_error_pointer in out nocopy number)
2242: is
2243: cursor l_allLots_csr
2244: is

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

2885: end if;
2886: end InsertIntoLLS;
2887:
2888:
2889: function InsertError(p_error_tbl in out NOCOPY POS_EXCELASN_ERROR_TABLE,
2890: p_error_msg in varchar2,
2891: p_error_index in out NOCOPY number)
2892: return number
2893: is

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

2903: end if;
2904: end InsertError;
2905:
2906:
2907: procedure FixHeadersAndLines(x_error_tbl in out NOCOPY POS_EXCELASN_ERROR_TABLE,
2908: l_error_pointer in out NOCOPY number)
2909: is
2910: l_asn_header_id number;
2911: l_ex_header_id number;

Line 3493: x_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,

3489: END;
3490:
3491:
3492: procedure CheckLlsControl(x_return_status out nocopy varchar2,
3493: x_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,
3494: l_error_pointer in out nocopy number)
3495: IS
3496: l_25errors exception;
3497: l_error_ln number;

Line 3924: x_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,

3920: x_return_status out nocopy varchar2,
3921: x_user_vendor_id_tbl out nocopy vendor_id_tbl_type,
3922: x_secure_by_site out nocopy varchar2,
3923: x_secure_by_contact out nocopy varchar2,
3924: x_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,
3925: x_error_pointer in out nocopy number
3926: )
3927: IS
3928: l_num number;

Line 4144: x_error_tbl out NOCOPY POS_EXCELASN_ERROR_TABLE,

4140: procedure ProcessExcelAsn(p_api_version in number,
4141: x_return_status out nocopy varchar2,
4142: x_return_code out nocopy varchar2,
4143: x_return_msg out nocopy varchar2,
4144: x_error_tbl out NOCOPY POS_EXCELASN_ERROR_TABLE,
4145: x_user_vendor_id out nocopy number)
4146: is
4147: x_progress varchar2(10);
4148: l_header_status varchar2(1);

Line 4238: x_error_tbl := POS_EXCELASN_ERROR_TABLE();

4234: begin
4235:
4236: x_progress := '000';
4237: x_return_status := FND_API.G_RET_STS_SUCCESS;
4238: x_error_tbl := POS_EXCELASN_ERROR_TABLE();
4239:
4240: --x_user_vendor_id will no longer be retrieved from the secured attribute,
4241: --ICX_SUPPLIER_ORG_ID
4242: SELECT FND_GLOBAL.USER_NAME INTO l_user_name FROM DUAL;