DBA Data[Home] [Help]

PACKAGE BODY: APPS.PER_EMPDIR_ASG_OVERRIDE

Source


1 PACKAGE BODY PER_EMPDIR_ASG_OVERRIDE AS
2 /* $Header: peredcor.pkb 115.1 2003/08/03 12:09 smallina noship $ */
3 
4 g_override_flg BOOLEAN:= FALSE;
5 
6 FUNCTION isOverrideEnabled RETURN BOOLEAN IS
7 BEGIN
8     RETURN g_override_flg;
9 END isOverrideEnabled;
10 
11 PROCEDURE before_dml(
12         errbuf  OUT NOCOPY VARCHAR2
13        ,retcode OUT NOCOPY VARCHAR2
14        ,p_eff_date IN DATE
15        ,p_cnt IN NUMBER
16        ,p_rec_locator IN NUMBER
17        ,p_srcSystem IN VARCHAR2) IS
18 BEGIN
19 
20       -- Sample Code
21     /* IF p_srcSystem = 'PER' THEN
22       per_empdir_ss.asgTbl.discretionary_title(p_rec_locator) :=
23             per_empdir_ss.asgTbl.ass_attribute12(p_rec_locator);
24     END IF; */
25 
26     NULL;
27 
28    EXCEPTION WHEN OTHERS THEN
29         errbuf := errbuf||SQLERRM;
30         retcode := '1';
31         per_empdir_ss.write_log(1, 'Error in before_dml asg '||SQLCODE);
32         per_empdir_ss.write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
33 END before_dml;
34 END PER_EMPDIR_ASG_OVERRIDE;