1 PACKAGE PO_MOD_CONTROL_PVT AUTHID CURRENT_USER AS
2 /* $Header: PO_MOD_CONTROL_PVT.pls 120.4.12020000.3 2013/03/19 08:08:41 amalick ship $ */
3
4 procedure process_mod_control_action(p_draft_id in number,
5 p_action in varchar2,
6 p_po_header_id in number,
7 resultout out NOCOPY varchar2);
8
9 -- Performs the withdraw action on the MOD
10 procedure process_mod_withdrawn_action(p_draft_id IN NUMBER,
11 status IN VARCHAR2,
12 result OUT NOCOPY VARCHAR2
13 );
14
15 -- Performs the delete action on the MOD
16 procedure process_mod_delete_action(p_draft_id IN NUMBER,
17 result OUT NOCOPY varchar2);
18
19 -- Performs Cancel, Close, Finally Close aactions at line level
20 procedure do_mod_line_control_action(p_draft_id in number,
21 p_action in varchar2,
22 p_po_line_id in number,
23 resultout out NOCOPY varchar2);
24
25 -- Performs Cancel, Close, Finally Close aactions at line level
26 procedure do_mod_line_loc_control_action(p_draft_id in number,
27 p_action in varchar2,
28 p_po_line_loc_id in number,
29 resultout out NOCOPY varchar2);
30
31 -- Fetch MOD related action at Header, Lines and Line Locations level
32 procedure get_mod_valid_control_actions( p_mode IN VARCHAR2
33 ,p_doc_level IN VARCHAR2
34 ,p_doc_type IN VARCHAR2
35 ,p_doc_header_id IN NUMBER
36 ,p_doc_level_id IN NUMBER
37 ,p_draft_id IN NUMBER
38 ,x_return_status OUT NOCOPY VARCHAR2
39 ,x_valid_ctrl_ctn_tbl OUT NOCOPY PO_TBL_VARCHAR30);
40
41
42 -- Deletes uda data from ext tables corresponding to given entity.
43 procedure delete_uda_data(p_draft_id IN NUMBER,
44 p_entity_id IN Number,
45 p_entity_level IN VARCHAR2,
46 x_return_status OUT NOCOPY VARCHAR2);
47
48 -- <PAR Project>
49 -- Performs the withdraw action on the PAR
50 procedure process_par_withdraw_action(p_draft_id IN NUMBER,
51 p_employee_id IN NUMBER,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_return_mssg OUT NOCOPY VARCHAR2);
54
55 --<PAR Project>
56 --Updates reqs_in_pool_flag for the dummy header req
57 PROCEDURE update_header_dummy_req(p_draft_id IN NUMBER);
58
59
60 END PO_MOD_CONTROL_PVT;