1 PACKAGE OKC_REP_UPD_CON_ADMIN_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVREPUADS.pls 120.2 2005/11/17 17:57:17 vamuru noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL CONSTANTS
6 ---------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_REP_UPD_CON_ADMIN_PVT';
8 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKC';
9 G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||G_PKG_NAME||'.';
10 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
11
12 ------------------------------------------------------------------------------
13 -- GLOBAL EXCEPTION
14 ------------------------------------------------------------------------------
15 E_Resource_Busy EXCEPTION;
16 PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
17
18
19 ---------------------------------------------------------------------------
20 -- Procedures and Functions
21 ---------------------------------------------------------------------------
22
23 -- Start of comments
24 --API name : update_con_admin_manager
25 --Type : Private.
26 --Function : API to update Contract Administrator of Blanket Sales
27 -- Agreements, Sales Orders, Quotes and Repository Contracts
28 -- (Sell and Other intent only)
29 --Pre-reqs : None.
30 --Parameters :
31 --IN : errbuf OUT NUMBER
32 -- : retcode OUT VARCHAR2
33 -- : p_doc_type IN VARCHAR2 Required
34 -- Type of contracts whose administrator need to be modified
35 -- : p_cust_id IN NUMBER Optional
36 -- Customer of contracts whose administrator need to be modified
37 -- : p_prev_con_admin_id IN NUMBER Optional
38 -- Existing administrator of contracts whose administrator need to be modified
39 -- : p_salesrep_id IN NUMBER Optional
40 -- Salesperson of contracts whose administrator need to be modified
41 -- : p_sales_group_id IN NUMBER Optional
42 -- Sales Group of quotes whose administrator need to be modified
43 -- : p_org_id IN NUMBER Optional
44 -- Operating unit of contracts whose administrator need to be modified
45 -- : p_order_type_id IN NUMBER Optional
46 -- Order type of contracts whose administrator need to be modified
47 -- : p_new_con_admin_id IN NUMBER Optional
48 -- New Contract Administrator Id
49 -- : p_new_con_admin_name IN VARCHAR2 Optional
50 -- New Contract Administrator Name
51 -- : p_mode IN VARCHAR2 Optional
52 -- Mode of operation Preview Only or Update
53 -- : p_con_admin_from IN VARCHAR2 Required
54 -- Contract Administrator from, possible values are NEW_CON_ADMIN or SALES_GROUP_ASMT
55 --Note :
56 -- End of comments
57 PROCEDURE update_con_admin_manager(
58 errbuf OUT NOCOPY VARCHAR2,
59 retcode OUT NOCOPY VARCHAR2,
60 p_doc_type IN VARCHAR2,
61 p_cust_id IN NUMBER,
62 p_prev_con_admin_id IN NUMBER,
63 p_salesrep_id IN NUMBER,
64 p_sales_group_id IN NUMBER,
65 p_org_id IN NUMBER,
66 p_order_type_id IN NUMBER,
67 p_new_con_admin_user_id IN NUMBER,
68 p_new_con_admin_name IN VARCHAR2,
69 p_mode IN VARCHAR2,
70 p_con_admin_from IN VARCHAR2
71 );
72
73
74 END OKC_REP_UPD_CON_ADMIN_PVT;