1 PACKAGE EAM_DEPT_APPROVERS_PUB AS
2 /* $Header: EAMPDAPS.pls 120.0 2005/05/27 15:01:21 appldev noship $ */
3 /*#
4 * This package is used for the INSERT / UPDATE of Department Approvers.
5 * It defines 2 key procedures insert_dept_appr, update_dept_appr
6 * which first validates and massages the IN parameters
7 * and then carries out the respective operations.
8 * @rep:scope public
9 * @rep:product EAM
10 * @rep:lifecycle active
11 * @rep:displayname Department Approvers
12 * @rep:category BUSINESS_ENTITY EAM_DEPARTMENT_APPROVER
13 */
14
15
16 /*#
17 * This procedure is used to insert records in BOM_EAM_DEPT_APPROVERS.
18 * It is used to create Department Approvers.
19 * @param p_api_version Version of the API
20 * @param p_init_msg_list Flag to indicate initialization of message list
21 * @param p_commit Flag to indicate whether API should commit changes
22 * @param p_validation_level Validation Level of the API
23 * @param x_return_status Return status of the procedure call
24 * @param x_msg_count Count of the return messages that API returns
25 * @param x_msg_data The collection of the messages.
26 * @param p_dept_id Department Identifier
27 * @param p_organization_id Organization Identifier
28 * @param p_resp_app_id Internal identifier of the appliation with which the responsibility is tied to
29 * @param p_responsibility_id Internal identifier of the responsibility associated with a department
30 * @param p_primary_approver_id Internal Identifier of the primary approver for the current department
31 * @return Returns the status of the procedure call as well as the return messages
32 * @rep:scope public
33 * @rep:displayname Insert Department Approvers
34 */
35
36
37 PROCEDURE insert_dept_appr
38 (
39 p_api_version IN NUMBER ,
40 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
41 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
42 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43
44 x_return_status OUT NOCOPY VARCHAR2 ,
45 x_msg_count OUT NOCOPY NUMBER ,
46 x_msg_data OUT NOCOPY VARCHAR2 ,
47
48 p_dept_id IN NUMBER,
49 p_organization_id IN NUMBER,
50 p_resp_app_id IN NUMBER,
51 p_responsibility_id IN NUMBER,
52 p_primary_approver_id IN NUMBER
53 );
54
55 /**
56 * This procedure is used to update the existing records in BOM_EAM_DEPT_APPROVERS.
57 * It is used to update Department Approvers.
58 * @param p_api_version Version of the API
59 * @param p_init_msg_list Flag to indicate initialization of message list
60 * @param p_commit Flag to indicate whether API should commit changes
61 * @param p_validation_level Validation Level of the API
62 * @param x_return_status Return status of the procedure call
63 * @param x_msg_count Count of the return messages that API returns
64 * @param x_msg_data The collection of the messages.
65 * @param p_dept_id Department Identifier
66 * @param p_organization_id Organization Identifier
67 * @param p_resp_app_id Internal identifier of the appliation with which the responsibility is tied to
68 * @param p_responsibility_id Internal identifier of the responsibility associated with a department
69 * @param p_primary_approver_id Internal Identifier of the primary approver for the current department
70 * @return Returns the status of the procedure call as well as the return messages
71 * @rep:scope public
72 * @rep:displayname Update Department Approvers
73 */
74
75 PROCEDURE update_dept_appr
76 (
77 p_api_version IN NUMBER ,
78 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
79 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
80 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81
82 x_return_status OUT NOCOPY VARCHAR2 ,
83 x_msg_count OUT NOCOPY NUMBER ,
84 x_msg_data OUT NOCOPY VARCHAR2 ,
85
86 p_dept_id IN NUMBER,
87 p_organization_id IN NUMBER,
88 p_resp_app_id IN NUMBER,
89 p_responsibility_id IN NUMBER,
90 p_primary_approver_id IN NUMBER
91 );
92
93 END;