DBA Data[Home] [Help]

APPS.PO_RESCHEDULE_PKG dependencies on PO_TBL_VARCHAR2000

Line 116: l_error_message po_tbl_varchar2000;

112: p_ship_methods po_tbl_varchar30
113: ) Return boolean IS
114: l_result BOOLEAN;
115: l_api_name CONSTANT VARCHAR2(30) := 'RESCHEDULE-2';
116: l_error_message po_tbl_varchar2000;
117: BEGIN
118: l_result:= RESCHEDULE (X_need_by_dates_old => X_need_by_dates_old,
119: X_need_by_dates => X_need_by_dates,
120: X_po_header_id => X_po_header_id,

Line 156: x_error_message OUT NOCOPY po_tbl_varchar2000 --bug9693292

152: X_supply_number VARCHAR2,
153: X_shipment_nums po_tbl_number,
154: p_estimated_pickup_dates po_tbl_date,
155: p_ship_methods po_tbl_varchar30,
156: x_error_message OUT NOCOPY po_tbl_varchar2000 --bug9693292
157: ) Return boolean IS
158:
159: l_po_release_id number;
160: X_po_type varchar2(25) := 'RELEASE';

Line 176: l_nbd_validate_tbl PO_TBL_VARCHAR2000:=NULL;

172: l_changes PO_CHANGES_REC_TYPE;
173: l_shipment_changes PO_SHIPMENTS_REC_TYPE;
174: l_line_location_id_tbl PO_TBL_NUMBER;
175: l_need_by_date_tbl PO_TBL_DATE;
176: l_nbd_validate_tbl PO_TBL_VARCHAR2000:=NULL;
177: l_return_status VARCHAR2(1);
178: l_api_errors PO_API_ERRORS_REC_TYPE;
179: l_release_type PO_RELEASES_ALL.RELEASE_TYPE%TYPE;
180: l_session_gt_key NUMBER;

Line 442: x_error_message := po_tbl_varchar2000();

438: FROM po_session_gt scratch
439: WHERE scratch.KEY = l_session_gt_key
440: AND Nvl(scratch.char2,'Y') = 'N';
441:
442: x_error_message := po_tbl_varchar2000();
443:
444: IF (supply_number_tbl.Count > 0) THEN
445: FOR i IN 1..supply_number_tbl.Count LOOP
446: FND_MESSAGE.SET_NAME('PO','PO_NEED_BY_DATE_MISMATCH');