[Home] [Help]
1: PACKAGE BODY WSH_ROUTING_REQUEST as
2: /* $Header: WSHRORQB.pls 120.1 2005/06/30 03:38:25 rahujain noship $ */
3:
4: -- standard global constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_ROUTING_REQUEST';
6:
7:
8: --Constant are define for each field of Routing Request and
105: -- IN:
106: -- p_index IN Index where address record is to be created.
107: -- p_Address IN OUT Type Address_Rec_type.
108: -- OUT:
109: -- x_return_status OUT NOCOPY Standard to output api status.
110: -- End of comments
111: PROCEDURE Create_Address_Record(
112: p_index IN NUMBER,
113: p_Address IN OUT NOCOPY Address_Rec_type,
175: -- IN:
176: -- p_index IN Index where routing request line record is to be created.
177: -- p_line IN OUT Type Line_Rec_type.
178: -- OUT:
179: -- x_return_status OUT NOCOPY Standard to output api status.
180: -- End of comments
181: PROCEDURE Create_Line_Record(
182: p_index IN NUMBER,
183: p_line IN OUT NOCOPY Line_Rec_type,
242: -- IN:
243: -- p_index IN Index where routing request delivery record is to be created.
244: -- p_delivery IN OUT Type delivery_Rec_type.
245: -- OUT:
246: -- x_return_status OUT NOCOPY Standard to output api status.
247: -- End of comments
248: PROCEDURE Create_Delivery_Record(
249: p_index IN NUMBER,
250: p_delivery IN OUT NOCOPY delivery_Rec_type,
315: -- IN:
316: -- p_index IN Index where routing request delivery record is to be created.
317: -- p_header IN OUT Type Header_Rec_type.
318: -- OUT:
319: -- x_return_status OUT NOCOPY Standard to output api status.
320: -- End of comments
321: PROCEDURE Create_Header_Record(
322: p_index IN NUMBER,
323: p_header IN OUT NOCOPY Header_Rec_type,
377: -- Parameters :
378: -- IN:
379: -- p_error_tbl IN Table of error status of routing request deliveries/address lines.
380: -- OUT:
381: -- x_return_status OUT NOCOPY Standard to output api status.
382: -- End of comments
383: PROCEDURE Is_All_Line_Error(p_error_tbl IN tbl_var1,
384: x_return_status OUT NOCOPY VARCHAR2) IS
385:
1293: -- p_col_value IN Value of field.
1294: -- p_index IN Index of global record g_field, where validation are defined.
1295: -- p_address IN Record of type Address_Rec_Type to hold address line information.
1296: -- OUT:
1297: -- x_return_status OUT NOCOPY Standard to output api status.
1298: -- End of comments
1299: PROCEDURE Process_Address_Line(
1300: p_col_name IN varchar2,
1301: p_col_value IN varchar2,
1499: -- p_in_param IN Hold additional parameter passed by UI.
1500: -- p_file_fields IN Hold Supplier Address book record as passed by UI
1501: -- OUT:
1502: -- x_message_tbl OUT NOCOPY List of Success/Error messages passed back to UI for display.
1503: -- x_return_status OUT NOCOPY Standard to output api status.
1504: -- End of comments
1505: PROCEDURE Process_Address_File(
1506: p_in_param IN In_Param_Rec_Type,
1507: p_file_fields IN WSH_FILE_RECORD_TYPE ,
1749: -- p_col_value IN Value of field.
1750: -- p_index IN Index of global record g_field, where validation are defined.
1751: -- p_address IN Record of type Line_Rec_Type to hold routing request line information.
1752: -- OUT:
1753: -- x_return_status OUT NOCOPY Standard to output api status.
1754: -- End of comments
1755: PROCEDURE Process_Line(
1756: p_col_name IN varchar2,
1757: p_col_value IN varchar2,
1931: -- p_col_value IN Value of field.
1932: -- p_index IN Index of global record g_field, where validation are defined.
1933: -- p_address IN Record of type Delivery_Rec_Type to hold routing request delivery information.
1934: -- OUT:
1935: -- x_return_status OUT NOCOPY Standard to output api status.
1936: -- End of comments
1937: PROCEDURE Process_Delivery(
1938: p_col_name IN varchar2,
1939: p_col_value IN varchar2,
2164: -- p_col_value IN Value of field.
2165: -- p_index IN Index of global record g_field, where validation are defined.
2166: -- p_address IN Record of type Header_Rec_Type to hold routing request header information.
2167: -- OUT:
2168: -- x_return_status OUT NOCOPY Standard to output api status.
2169: -- End of comments
2170: PROCEDURE Process_Header(
2171: p_col_name IN varchar2,
2172: p_col_value IN varchar2,
2275: -- p_inventory_item_id IN Item Id.
2276: -- p_detail_uom_code IN UOM code of detail line.
2277: -- OUT:
2278: -- x_convert_qty OUT NOCOPY Converted quantity in detail line UOM.
2279: -- x_return_status OUT NOCOPY Standard to output api status.
2280: -- End of comments
2281: PROCEDURE Validate_UOM(
2282: p_uom_type IN VARCHAR2,
2283: p_organization_id IN NUMBER,
2435: -- p_email IN Email
2436: -- OUT:
2437: -- x_location_id OUT NOCOPY Location Id for given input information.
2438: -- x_party_site_id OUT NOCOPY Party Site Id for given input information.
2439: -- x_return_status OUT NOCOPY Standard to output api status.
2440: -- End of comments
2441: PROCEDURE Process_Address(
2442: P_vendor_id IN number,
2443: P_party_id IN number,
2673: -- p_po_line_location_id IN PO Line location Id.
2674: -- p_detail_att IN Attribute of detail line.
2675: -- x_delivery_detail_id IN Delivery detail id from which PO line need to created.
2676: -- OUT:
2677: -- x_return_status OUT NOCOPY Standard to output api status.
2678: -- End of comments
2679: PROCEDURE Create_PO( p_po_line_location_id IN NUMBER,
2680: p_detail_att IN detail_att_rec_type,
2681: x_delivery_detail_id OUT NOCOPY NUMBER,
2847: -- p_line_id IN PO Line Id.
2848: -- p_line_location_id IN PO Line location Id.
2849: -- p_release_id IN PO release Id.
2850: -- OUT:
2851: -- x_return_status OUT NOCOPY Standard to output api status.
2852: -- End of comments
2853: PROCEDURE Validate_PO(
2854: p_header_id IN NUMBER,
2855: p_header IN varchar2,
3029: -- OUT:
3030: -- x_detail_item_qty OUT NOCOPY Item Qty in detail UOM.
3031: -- x_detail_weight_qty OUT NOCOPY Weight in detail UOM.
3032: -- x_detail_volume_qty OUT NOCOPY Volume in detail UOM.
3033: -- x_return_status OUT NOCOPY varchar2 standard to output status
3034: -- End of comments
3035: PROCEDURE Validate_line(
3036: p_organization_id IN NUMBER,
3037: p_item_id IN NUMBER,
3358: -- p_detail_att IN Attributes of delivery detail line.
3359: -- p_delivery_index IN Index of delivery record.
3360: -- p_delivery IN Delivery_Rec_Type,Routing Request delivery record.
3361: -- OUT:
3362: -- x_return_status OUT NOCOPY varchar2 standard to output status.
3363: -- End of comments
3364:
3365: PROCEDURE Validate_Delivery(
3366: p_detail_att IN OUT NOCOPY detail_att_rec_type,
3538: -- p_organization_id IN Organization Id.
3539: -- p_delivery_index IN Index of delivery record.
3540: -- p_delivery IN Delivery_Rec_Type,Routing Request delivery record.
3541: -- OUT:
3542: -- x_return_status OUT NOCOPY varchar2 standard to output status.
3543: -- End of comments
3544: PROCEDURE Validate_Delivery_uom(
3545: p_organization_id IN NUMBER,
3546: p_delivery_index IN NUMBER,
3675: -- p_detail_ids IN List of delivery detail line Id's.
3676: -- p_detail_att IN Attributes of delivery and delivery line.
3677: -- OUT:
3678: -- x_new_detail_ids OUT NOCOPY New delivery detail id's created result of split.
3679: -- x_return_status OUT NOCOPY Standard to output api status.
3680: -- End of comments
3681: PROCEDURE Update_Split_Details(
3682: p_detail_ids IN wsh_util_core.id_tab_type,
3683: p_detail_att IN detail_att_rec_type,
4000: -- Parameters :
4001: -- IN:
4002: -- p_routing_req_id IN Routing Request id
4003: -- OUT:
4004: -- x_return_status OUT NOCOPY Standard to output api status.
4005: -- End of comments
4006: PROCEDURE UnAssign_Details(
4007: p_routing_req_id IN number ,
4008: x_return_status OUT NOCOPY varchar2) IS
4161: -- p_delivery_index IN Index of delivery record.
4162: -- p_delivery IN Delivery record type Delivery_Rec_Type.
4163: -- OUT:
4164: -- x_new_deliveries OUT NOCOPY Id of new delivery created.
4165: -- x_return_status OUT NOCOPY Standard to output api status.
4166: -- End of comments
4167: PROCEDURE Create_Delivery(
4168: p_detail_ids IN wsh_util_core.id_tab_type,
4169: p_delivery_index IN NUMBER,
4517: -- p_supplier_name IN Supplier Name.
4518: -- p_line_number IN Line of Routing Request File.
4519: -- p_detail_att IN OUT Attributes of routing request line type In_param_Rec_Type.
4520: -- OUT:
4521: -- x_return_status OUT NOCOPY Standard to output api status.
4522: -- End of comments
4523: PROCEDURE Validate_Header(
4524: p_in_param IN In_param_Rec_Type,
4525: p_request_number IN VARCHAR2 ,
4711: -- IN:
4712: -- p_org_name IN Operating Unit Name.
4713: -- OUT:
4714: -- x_org_id OUT NOCOPY org Id
4715: -- x_return_status OUT NOCOPY Standard to output api status.
4716: -- End of comments
4717: PROCEDURE Validate_Org(
4718: p_org_name IN varchar2,
4719: x_org_id OUT NOCOPY number,
4825: -- p_delivery IN OUT Type Delivery_Rec_Type,hold delivery information of Routing Request file.
4826: -- p_line IN OUT Type Line_Rec_Type,hold line information of Routing Request file.
4827: -- OUT:
4828: -- x_success_tbl OUT NOCOPY List of output message need to be displayed in Routing Request UI.
4829: -- x_return_status OUT NOCOPY Standard to output api status.
4830: -- End of comments
4831: PROCEDURE Process_Routing_Request(
4832: p_in_param IN In_param_Rec_Type,
4833: p_header IN OUT NOCOPY Header_Rec_type,
5793: -- p_in_param IN Hold additional parameter passed by UI.
5794: -- p_file_fields IN Hold Routing Request records as passed by UI
5795: -- OUT:
5796: -- x_message_tbl OUT NOCOPY List of Success/Error messages passed back to UI for display.
5797: -- x_return_status OUT NOCOPY Standard to output api status.
5798: -- End of comments
5799: PROCEDURE Process_Routing_Request_File(
5800: p_in_param IN In_param_Rec_Type,
5801: p_file_fields IN WSH_FILE_RECORD_TYPE ,
6357: -- p_date_format IN UI date format need to be same with server date format.
6358: -- p_file_fields IN List of fields as parse from Routing Request/Supplier Address book file.
6359: -- OUT:
6360: -- x_message_tbl OUT NOCOPY List of success/error messages return to calling api.
6361: -- x_return_status OUT NOCOPY Standard to output api status.
6362: -- End of comments
6363: PROCEDURE Process_File(
6364: p_caller IN VARCHAR2,
6365: p_txn_type IN VARCHAR2,