1 PACKAGE EAM_MATERIAL_REQUEST_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMWEMRS.pls 120.1.12020000.3 2012/11/08 17:56:40 vchidura ship $*/
3
4 /* Author: dgupta
5 A wrapper to the WIP picking API. This API works at the component level.
6 Note that messaging is enhanced. If the WIP API errors out, we try to determine
7 the problem here and give a more meaningful error message.
8 */
9
10 PROCEDURE allocate(
11 p_api_version IN NUMBER := 1.0,
12 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
13 p_commit IN VARCHAR2 := fnd_api.g_false,
14 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
15 x_return_status OUT NOCOPY VARCHAR2,
16 x_msg_count OUT NOCOPY NUMBER,
17 x_msg_data OUT NOCOPY VARCHAR2,
18 x_request_number OUT NOCOPY VARCHAR2,
19 p_wip_entity_type IN NUMBER,
20 p_organization_id IN NUMBER,
21 p_wip_entity_id IN NUMBER,
22 p_operation_seq_num IN NUMBER,
23 p_inventory_item_id IN NUMBER,
24 p_project_id IN NUMBER := null,
25 p_task_id IN NUMBER := null,
26 p_requested_quantity IN NUMBER := null,
27 p_source_subinventory IN VARCHAR2 := null,
28 p_source_locator IN NUMBER := null,
29 p_lot_number IN VARCHAR2 := null,
30 p_fm_serial IN VARCHAR2 := null,
31 p_to_serial IN VARCHAR2 := null
32 );
33
34 --14786085
35 --This procedure is called by the EAM Work Orders Component Pick Release Concurrent Program for workorders
36 procedure allocate_comp_mat(errbuf OUT NOCOPY VARCHAR2,
37 retcode OUT NOCOPY NUMBER,
38 p_wip_entity_type NUMBER,
39 p_job_type NUMBER DEFAULT 4, /*Bug 5932126 (FP of 5880558): Added one new parameter for job type*/
40 p_days_forward NUMBER,
41 p_organization_id NUMBER,
42 p_use_pickset_indicator NUMBER,
43 p_pick_grouping_rule_id NUMBER := NULL,
44 p_print_pickslips NUMBER DEFAULT NULL, -- lookup code is 1 for default value YES
45 p_plan_tasks NUMBER DEFAULT NULL, -- lookup code is 2 for default value NO
46 p_auto_req_material NUMBER DEFAULT NULL,
47 p_days_to_alloc NUMBER DEFAULT NULL); --only used for rep scheds
48
49 END EAM_MATERIAL_REQUEST_PVT;