1 PACKAGE PO_Mass_Update_PO_GRP AUTHID CURRENT_USER AS
2 /* $Header: PO_Mass_Update_PO_GRP.pls 120.2 2008/01/09 14:27:20 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_PO_PVT.Do_Update to update the
11 -- Buyer/Approver/Deliver_To person 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(Buyer/Approver/Deliver_To).
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(STANDARD,BLANKET.CONTRACT,PLANNED).
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_supplier_id Supplier id.
24 -- p_include_close_po Include Close PO's or not (Value as Yes or No).
25 -- p_commit_interval Commit interval.
26
27 -- OUT : p_msg_data Actual message in encoded format.
28 -- p_msg_count Holds the number of messages in the API list.
29 -- p_return_status Return status of the API (Includes 'S','E','U').
30
31 -- End of Comments
32 --------------------------------------------------------------------------------------------------
33
34
35 PROCEDURE Update_Persons(p_update_person IN VARCHAR2,
36 p_old_personid IN NUMBER,
37 p_new_personid IN NUMBER,
38 p_document_type IN VARCHAR2,
39 p_document_no_from IN VARCHAR2,
40 p_document_no_to IN VARCHAR2,
41 p_date_from IN DATE,
42 p_date_to IN DATE,
43 p_supplier_id IN NUMBER,
44 p_include_close_po IN VARCHAR2,
45 p_commit_interval IN NUMBER,
46 p_msg_data OUT NOCOPY VARCHAR2,
47 p_msg_count OUT NOCOPY NUMBER,
48 p_return_status OUT NOCOPY VARCHAR2);
49
50 END PO_Mass_Update_PO_GRP;