1: PACKAGE BODY jtf_rs_conc_res_pub AS
2: /* $Header: jtfrsbrb.pls 120.10.12020000.3 2013/04/12 06:43:02 rgokavar ship $ */
3:
4: /*****************************************************************************************
5: This is a concurrent program to fetch all employees from the employee database for creating
11: ******************************************************************************************/
12:
13: /* Package variables. */
14:
15: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_RS_CONC_RES_PUB';
16: g_run_date DATE;
17:
18: /**
19: * PROCEDURE debug
243:
244: -- End Code for Enh
245:
246: --call terminate api
247: jtf_rs_conc_res_pub.terminate_employee;
248:
249:
250: --call update api
251: jtf_rs_conc_res_pub.update_employee
247: jtf_rs_conc_res_pub.terminate_employee;
248:
249:
250: --call update api
251: jtf_rs_conc_res_pub.update_employee
252: (P_OVERWRITE_NAME => P_OVERWRITE_NAME);
253:
254: -- call update terminated api
255: -- jtf_rs_conc_res_pub.update_terminated_employee;
251: jtf_rs_conc_res_pub.update_employee
252: (P_OVERWRITE_NAME => P_OVERWRITE_NAME);
253:
254: -- call update terminated api
255: -- jtf_rs_conc_res_pub.update_terminated_employee;
256:
257: -- call update phones for employees
258: -- update_emp_phone;
259:
259:
260: --call create api
261: IF(p_get_new_emp = 'Y')
262: THEN
263: jtf_rs_conc_res_pub.create_employee
264: (P_CREATE_SRP => P_CREATE_SRP,
265: P_SALES_CREDIT_TYPE => P_SALES_CREDIT_TYPE,
266: P_CHECK_JOB_ROLE_MAP => P_CHECK_JOB_ROLE_MAP);
267: END IF;
3617:
3618:
3619: BEGIN
3620: --Terminate all partner resource, whose relationship is terminated in hz_relationships
3621: jtf_rs_conc_res_pub.terminate_partner_rel;
3622:
3623: jtf_rs_conc_res_pub.update_party
3624: (p_overwrite_name => P_OVERWRITE_NAME);
3625: COMMIT;
3619: BEGIN
3620: --Terminate all partner resource, whose relationship is terminated in hz_relationships
3621: jtf_rs_conc_res_pub.terminate_partner_rel;
3622:
3623: jtf_rs_conc_res_pub.update_party
3624: (p_overwrite_name => P_OVERWRITE_NAME);
3625: COMMIT;
3626:
3627: EXCEPTION
4000:
4001: BEGIN
4002:
4003: -- Call Terminate Supplier Contact Procedure
4004: jtf_rs_conc_res_pub.terminate_supplier_contact;
4005:
4006: -- Call Update Supplier Contact Procedure
4007: jtf_rs_conc_res_pub.update_supp_contact
4008: (p_overwrite_name => P_OVERWRITE_NAME);
4003: -- Call Terminate Supplier Contact Procedure
4004: jtf_rs_conc_res_pub.terminate_supplier_contact;
4005:
4006: -- Call Update Supplier Contact Procedure
4007: jtf_rs_conc_res_pub.update_supp_contact
4008: (p_overwrite_name => P_OVERWRITE_NAME);
4009: COMMIT;
4010:
4011: EXCEPTION
4597: BEGIN
4598:
4599: IF (P_SYNCHRONIZE = 'User Name' OR P_SYNCHRONIZE = 'Both')
4600: THEN
4601: jtf_rs_conc_res_pub.update_username;
4602: END IF;
4603:
4604: IF (P_SYNCHRONIZE = 'User Identifier' OR P_SYNCHRONIZE = 'Both')
4605: THEN
4602: END IF;
4603:
4604: IF (P_SYNCHRONIZE = 'User Identifier' OR P_SYNCHRONIZE = 'Both')
4605: THEN
4606: jtf_rs_conc_res_pub.update_userid;
4607: END IF;
4608:
4609: COMMIT;
4610: EXCEPTION
4615: THEN
4616: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4617: END synchronize_user_name;
4618:
4619: END jtf_rs_conc_res_pub;