1 PACKAGE EAM_WO_CHANGE_STATUS_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVWOSS.pls 120.6 2010/04/19 11:14:08 vchidura ship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- EAMVWOSS.pls
11 --
12 -- DESCRIPTION
13 --
14 -- Spec of package EAM_WO_CHANGE_STATUS_PVT
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 12-JUN-2002 Amit Mondal Initial Creation
21 ***************************************************************************/
22
23
24 PROCEDURE change_status (
25 p_api_version IN NUMBER
26 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
27 ,p_commit IN VARCHAR2 := fnd_api.g_false
28 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
29 ,p_wip_entity_id IN NUMBER
30 ,p_organization_id IN NUMBER
31 ,p_to_status_type IN NUMBER := wip_constants.unreleased
32 ,p_user_id IN NUMBER := null
33 ,p_responsibility_id IN NUMBER := null
34 ,p_date_released IN DATE := sysdate
35 , p_report_type IN NUMBER := null
36 , p_actual_close_date IN DATE := sysdate
37 , p_submission_date IN DATE := sysdate
38 ,p_work_order_mode IN NUMBER := EAM_PROCESS_WO_PVT.G_OPR_CREATE
39 ,x_request_id OUT NOCOPY NUMBER
40 ,x_return_status OUT NOCOPY VARCHAR2
41 ,x_msg_count OUT NOCOPY NUMBER
42 ,x_msg_data OUT NOCOPY VARCHAR2
43 ,x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type);
44
45 /*Procedure to create osp requisitions at workorder release
46 This procedure will check if there are any existing requisitions for each operation.
47 If reqs. are not there then osp requisitions will be created for such operations
48 */
49 PROCEDURE create_osp_req_at_rel
50 (
51 p_wip_entity_id IN NUMBER,
52 p_organization_id IN NUMBER);
53
54 FUNCTION PO_REQ_EXISTS ( p_wip_entity_id in NUMBER
55 ,p_rep_sched_id in NUMBER
56 ,p_organization_id in NUMBER
57 ,p_op_seq_num in NUMBER default NULL
58 ,p_res_seq_num in NUMBER default NULL
59 ,p_entity_type in NUMBER
60 ) RETURN BOOLEAN;
61
62 END EAM_WO_CHANGE_STATUS_PVT;
63
64
65
66
67