DBA Data[Home] [Help]

PACKAGE: APPS.JTF_RS_CONC_RES_PUB

Source


1 PACKAGE  jtf_rs_conc_res_pub AUTHID CURRENT_USER AS
2 /* $Header: jtfrsbrs.pls 120.0 2005/05/11 08:19:24 appldev ship $ */
3 
4   /*****************************************************************************************
5    This is a concurrent program to fetch all employees from the employee database for creating
6    resources in resource manager. All employees who are valid on sysdate and are not already
7    existing in resource manager will be fetched
8 
9    ******************************************************************************************/
10 
11 
12   /* Procedure to create the resource  */
13   PROCEDURE  create_employee
14   (P_CREATE_SRP              IN  VARCHAR2 DEFAULT 'N',
15    P_SALES_CREDIT_TYPE       IN  VARCHAR2 DEFAULT NULL,
16    P_CHECK_JOB_ROLE_MAP      IN  VARCHAR2 DEFAULT 'N');
17 
18   PROCEDURE  terminate_employee;
19 
20   PROCEDURE  update_employee
21   (P_OVERWRITE_NAME          IN  VARCHAR2 DEFAULT 'N');
22 
23   PROCEDURE  synchronize_employee
24   (ERRBUF                    OUT NOCOPY VARCHAR2,
25    RETCODE                   OUT NOCOPY VARCHAR2,
26    P_OVERWRITE_NAME          IN  VARCHAR2 DEFAULT 'No',
27    P_GET_NEW_EMP             IN  VARCHAR2 DEFAULT 'N',
28    P_DUMMY_1                 IN  VARCHAR2 DEFAULT 'N',
29    P_CREATE_SRP              IN  VARCHAR2 DEFAULT 'N',
30    P_DUMMY_2                 IN  VARCHAR2 DEFAULT 'N',
31    P_SALES_CREDIT_TYPE       IN  VARCHAR2 DEFAULT NULL,
32    P_CHECK_JOB_ROLE_MAP      IN  VARCHAR2 DEFAULT 'N'
33   );
34 
35   PROCEDURE  update_terminated_employee;
36 
37   PROCEDURE  synchronize_party
38   (ERRBUF                    OUT NOCOPY VARCHAR2,
39    RETCODE                   OUT NOCOPY VARCHAR2,
40    P_OVERWRITE_NAME          IN  VARCHAR2 DEFAULT 'N'
41    );
42 
43   PROCEDURE update_party
44   (P_OVERWRITE_NAME          IN  VARCHAR2 DEFAULT 'N');
45 
46   PROCEDURE terminate_partner_rel;
47 
48   PROCEDURE  synchronize_supp_contact
49   (ERRBUF                    OUT NOCOPY VARCHAR2,
50    RETCODE                   OUT NOCOPY VARCHAR2,
51    P_OVERWRITE_NAME          IN  VARCHAR2 DEFAULT 'N'
52    );
53 
54   PROCEDURE update_supp_contact
55   (P_OVERWRITE_NAME          IN  VARCHAR2 DEFAULT 'N');
56 
57   PROCEDURE terminate_supplier_contact;
58 
59   PROCEDURE update_username;
60 
61   PROCEDURE update_userid;
62 
63   PROCEDURE  synchronize_user_name
64   (ERRBUF                    OUT NOCOPY VARCHAR2,
65    RETCODE                   OUT NOCOPY VARCHAR2,
66    P_SYNCHRONIZE             IN  VARCHAR2 DEFAULT 'Both'
67   );
68 
69 END jtf_rs_conc_res_pub;