1 PACKAGE PO_Mass_Update_Req_GRP AUTHID CURRENT_USER AS
2 /* $Header: PO_Mass_Update_Req_GRP.pls 120.2 2008/01/09 14:33:44 rakchakr noship $*/
3
4 --------------------------------------------------------------------------------------------------
5 -- Start of Comments
6
7 -- API Name : Update_Persons
8 -- Type : Group
9 -- Pre-reqs : None
10 -- Function : Calls the procedure PO_Mass_Update_Req_PVT.Do_Update to update the
11 -- Preparer/Approver/Requestor accordingly to the input received
12 -- from the Update_Person parameter value set.
13 -- Parameters :
14
15 -- IN : p_update_person Person needs to be updated(Preparer/Approver/Requestor).
16 -- p_old_personid Id of the old person.
17 -- p_new_personid Id of the new person.
18 -- p_document_type Type of the document(INTERNAL AND PURCHASE).
19 -- p_document_no_from Document number from.
20 -- p_document_no_to Document number to.
21 -- p_date_from Date from.
22 -- p_date_to Date to.
23 -- p_commit_interval Commit interval.
24
25 -- OUT : p_msg_data Actual message in encoded format.
26 -- p_msg_count Holds the number of messages in the API list.
27 -- p_return_status Return status of the API (Includes 'S','E','U').
28
29 -- End of Comments
30 --------------------------------------------------------------------------------------------------
31
32 PROCEDURE Update_Persons(p_update_person IN VARCHAR2,
33 p_old_personid IN NUMBER,
34 p_new_personid IN NUMBER,
35 p_document_type IN VARCHAR2,
36 p_document_no_from IN VARCHAR2,
37 p_document_no_to IN VARCHAR2,
38 p_date_from IN DATE,
39 p_date_to IN DATE,
40 p_commit_interval IN NUMBER,
41 p_msg_data OUT NOCOPY VARCHAR2,
42 p_msg_count OUT NOCOPY NUMBER,
43 p_return_status OUT NOCOPY VARCHAR2);
44
45 END PO_Mass_Update_Req_GRP;