1 PACKAGE jtf_rs_job_roles_pvt AUTHID CURRENT_USER AS
2 /* $Header: jtfrsvns.pls 120.0 2005/05/11 08:23:10 appldev ship $ */
3
4 /*****************************************************************************************
5 This is a private API that caller will invoke.
6 It provides procedures for managing resource job roles, like
7 create and delete resource job roles.
8 Its main procedures are as following:
9 Create Resource Job Roles
10 Delete Resource Job Roles
11 Calls to these procedures will invoke calls to table handlers which
12 do actual inserts and deletes into tables.
13 ******************************************************************************************/
14
15
16 /* Procedure to create the resource job roles
17 based on input values passed by calling routines. */
18
19 PROCEDURE create_resource_job_roles
20 (P_API_VERSION IN NUMBER,
21 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23 P_JOB_ID IN JTF_RS_JOB_ROLES.JOB_ID%TYPE,
24 P_ROLE_ID IN JTF_RS_JOB_ROLES.ROLE_ID%TYPE,
25 P_ATTRIBUTE1 IN JTF_RS_JOB_ROLES.ATTRIBUTE1%TYPE DEFAULT NULL,
26 P_ATTRIBUTE2 IN JTF_RS_JOB_ROLES.ATTRIBUTE2%TYPE DEFAULT NULL,
27 P_ATTRIBUTE3 IN JTF_RS_JOB_ROLES.ATTRIBUTE3%TYPE DEFAULT NULL,
28 P_ATTRIBUTE4 IN JTF_RS_JOB_ROLES.ATTRIBUTE4%TYPE DEFAULT NULL,
29 P_ATTRIBUTE5 IN JTF_RS_JOB_ROLES.ATTRIBUTE5%TYPE DEFAULT NULL,
30 P_ATTRIBUTE6 IN JTF_RS_JOB_ROLES.ATTRIBUTE6%TYPE DEFAULT NULL,
31 P_ATTRIBUTE7 IN JTF_RS_JOB_ROLES.ATTRIBUTE7%TYPE DEFAULT NULL,
32 P_ATTRIBUTE8 IN JTF_RS_JOB_ROLES.ATTRIBUTE8%TYPE DEFAULT NULL,
33 P_ATTRIBUTE9 IN JTF_RS_JOB_ROLES.ATTRIBUTE9%TYPE DEFAULT NULL,
34 P_ATTRIBUTE10 IN JTF_RS_JOB_ROLES.ATTRIBUTE10%TYPE DEFAULT NULL,
35 P_ATTRIBUTE11 IN JTF_RS_JOB_ROLES.ATTRIBUTE11%TYPE DEFAULT NULL,
36 P_ATTRIBUTE12 IN JTF_RS_JOB_ROLES.ATTRIBUTE12%TYPE DEFAULT NULL,
37 P_ATTRIBUTE13 IN JTF_RS_JOB_ROLES.ATTRIBUTE13%TYPE DEFAULT NULL,
38 P_ATTRIBUTE14 IN JTF_RS_JOB_ROLES.ATTRIBUTE14%TYPE DEFAULT NULL,
39 P_ATTRIBUTE15 IN JTF_RS_JOB_ROLES.ATTRIBUTE15%TYPE DEFAULT NULL,
40 P_ATTRIBUTE_CATEGORY IN JTF_RS_JOB_ROLES.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
41 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
42 X_MSG_COUNT OUT NOCOPY NUMBER,
43 X_MSG_DATA OUT NOCOPY VARCHAR2,
44 X_JOB_ROLE_ID OUT NOCOPY JTF_RS_JOB_ROLES.JOB_ROLE_ID%TYPE
45 );
46
47
48
49 /* Procedure to delete the resource job roles. */
50
51 PROCEDURE delete_resource_job_roles
52 (P_API_VERSION IN NUMBER,
53 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55 P_JOB_ROLE_ID IN JTF_RS_JOB_ROLES.JOB_ROLE_ID%TYPE,
56 P_OBJECT_VERSION_NUM IN JTF_RS_JOB_ROLES.OBJECT_VERSION_NUMBER%TYPE,
57 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
58 X_MSG_COUNT OUT NOCOPY NUMBER,
59 X_MSG_DATA OUT NOCOPY VARCHAR2
60 );
61
62
63 END jtf_rs_job_roles_pvt;