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