18: BEGIN
19:
20: -- Sample Code
21: /* IF p_srcSystem = 'PER' THEN
22: IF per_empdir_ss.jobTbl.display_name(p_rec_locator) IS NOT NULL THEN
23: per_empdir_ss.jobTbl.attribute1(p_rec_locator) :=
24: per_empdir_ss.jobTbl.name(p_rec_locator);
25: per_empdir_ss.jobTbl.name(p_rec_locator) :=
26: per_empdir_ss.jobTbl.display_name(p_rec_locator);
19:
20: -- Sample Code
21: /* IF p_srcSystem = 'PER' THEN
22: IF per_empdir_ss.jobTbl.display_name(p_rec_locator) IS NOT NULL THEN
23: per_empdir_ss.jobTbl.attribute1(p_rec_locator) :=
24: per_empdir_ss.jobTbl.name(p_rec_locator);
25: per_empdir_ss.jobTbl.name(p_rec_locator) :=
26: per_empdir_ss.jobTbl.display_name(p_rec_locator);
27: END IF;
20: -- Sample Code
21: /* IF p_srcSystem = 'PER' THEN
22: IF per_empdir_ss.jobTbl.display_name(p_rec_locator) IS NOT NULL THEN
23: per_empdir_ss.jobTbl.attribute1(p_rec_locator) :=
24: per_empdir_ss.jobTbl.name(p_rec_locator);
25: per_empdir_ss.jobTbl.name(p_rec_locator) :=
26: per_empdir_ss.jobTbl.display_name(p_rec_locator);
27: END IF;
28: END IF; */
21: /* IF p_srcSystem = 'PER' THEN
22: IF per_empdir_ss.jobTbl.display_name(p_rec_locator) IS NOT NULL THEN
23: per_empdir_ss.jobTbl.attribute1(p_rec_locator) :=
24: per_empdir_ss.jobTbl.name(p_rec_locator);
25: per_empdir_ss.jobTbl.name(p_rec_locator) :=
26: per_empdir_ss.jobTbl.display_name(p_rec_locator);
27: END IF;
28: END IF; */
29:
22: IF per_empdir_ss.jobTbl.display_name(p_rec_locator) IS NOT NULL THEN
23: per_empdir_ss.jobTbl.attribute1(p_rec_locator) :=
24: per_empdir_ss.jobTbl.name(p_rec_locator);
25: per_empdir_ss.jobTbl.name(p_rec_locator) :=
26: per_empdir_ss.jobTbl.display_name(p_rec_locator);
27: END IF;
28: END IF; */
29:
30: NULL;
31:
32: EXCEPTION WHEN OTHERS THEN
33: errbuf := errbuf||SQLERRM;
34: retcode := '1';
35: per_empdir_ss.write_log(1, 'Error in before_dml jobs : '||SQLCODE);
36: per_empdir_ss.write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
37: END before_dml;
38: END PER_EMPDIR_JOBS_OVERRIDE;
32: EXCEPTION WHEN OTHERS THEN
33: errbuf := errbuf||SQLERRM;
34: retcode := '1';
35: per_empdir_ss.write_log(1, 'Error in before_dml jobs : '||SQLCODE);
36: per_empdir_ss.write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
37: END before_dml;
38: END PER_EMPDIR_JOBS_OVERRIDE;