eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.JTF_RS_RESOURCE_EXTNS_AUD_PVT dependencies on FND_API

Line 66: x_return_status := fnd_api.g_ret_sts_success;

62:
63: --Standard Start of API SAVEPOINT
64: SAVEPOINT RESOURCE_EXTN_AUDIT;
65:
66: x_return_status := fnd_api.g_ret_sts_success;
67:
68: --Standard Call to check API compatibility
69: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
70: THEN

Line 69: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

65:
66: x_return_status := fnd_api.g_ret_sts_success;
67:
68: --Standard Call to check API compatibility
69: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
70: THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:

Line 71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

67:
68: --Standard Call to check API compatibility
69: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
70: THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:
74: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
75: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 75: IF FND_API.To_boolean(P_INIT_MSG_LIST)

71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:
74: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
75: IF FND_API.To_boolean(P_INIT_MSG_LIST)
76: THEN
77: FND_MSG_PUB.Initialize;
78: END IF;
79:

Line 159: IF fnd_api.to_boolean (p_commit)

155:
156:
157:
158:
159: IF fnd_api.to_boolean (p_commit)
160: THEN
161: COMMIT WORK;
162: END IF;
163:

Line 168: WHEN fnd_api.g_exc_unexpected_error

164: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
165:
166:
167: EXCEPTION
168: WHEN fnd_api.g_exc_unexpected_error
169: THEN
170: ROLLBACK TO resource_extn_audit;
171: x_return_status := fnd_api.g_ret_sts_unexp_error;
172: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');

Line 171: x_return_status := fnd_api.g_ret_sts_unexp_error;

167: EXCEPTION
168: WHEN fnd_api.g_exc_unexpected_error
169: THEN
170: ROLLBACK TO resource_extn_audit;
171: x_return_status := fnd_api.g_ret_sts_unexp_error;
172: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
173: FND_MSG_PUB.add;
174: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
175: WHEN OTHERS

Line 178: x_return_status := fnd_api.g_ret_sts_unexp_error;

174: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
175: WHEN OTHERS
176: THEN
177: ROLLBACK TO resource_extn_audit;
178: x_return_status := fnd_api.g_ret_sts_unexp_error;
179: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
180: FND_MSG_PUB.add;
181: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
182:

Line 275: x_return_status := fnd_api.g_ret_sts_success;

271:
272: --Standard Start of API SAVEPOINT
273: SAVEPOINT RESOURCE_EXTN_AUDIT;
274:
275: x_return_status := fnd_api.g_ret_sts_success;
276:
277: --Standard Call to check API compatibility
278: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
279: THEN

Line 278: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

274:
275: x_return_status := fnd_api.g_ret_sts_success;
276:
277: --Standard Call to check API compatibility
278: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
279: THEN
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:

Line 280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

276:
277: --Standard Call to check API compatibility
278: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
279: THEN
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
283: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
284: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 284: IF FND_API.To_boolean(P_INIT_MSG_LIST)

280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
283: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
284: IF FND_API.To_boolean(P_INIT_MSG_LIST)
285: THEN
286: FND_MSG_PUB.Initialize;
287: END IF;
288:

Line 436: IF fnd_api.to_boolean (p_commit)

432: X_OLD_SOURCE_PAGER => null
433: );
434:
435:
436: IF fnd_api.to_boolean (p_commit)
437: THEN
438: COMMIT WORK;
439: END IF;
440:

Line 445: WHEN fnd_api.g_exc_unexpected_error

441: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
442:
443:
444: EXCEPTION
445: WHEN fnd_api.g_exc_unexpected_error
446: THEN
447: ROLLBACK TO resource_extn_audit;
448: x_return_status := fnd_api.g_ret_sts_unexp_error;
449: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');

Line 448: x_return_status := fnd_api.g_ret_sts_unexp_error;

444: EXCEPTION
445: WHEN fnd_api.g_exc_unexpected_error
446: THEN
447: ROLLBACK TO resource_extn_audit;
448: x_return_status := fnd_api.g_ret_sts_unexp_error;
449: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
450: FND_MSG_PUB.add;
451: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
452: WHEN OTHERS

Line 455: x_return_status := fnd_api.g_ret_sts_unexp_error;

451: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
452: WHEN OTHERS
453: THEN
454: ROLLBACK TO resource_extn_audit;
455: x_return_status := fnd_api.g_ret_sts_unexp_error;
456: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
457: FND_MSG_PUB.add;
458: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
459:

Line 617: x_return_status := fnd_api.g_ret_sts_success;

613:
614: --Standard Start of API SAVEPOINT
615: SAVEPOINT RESOURCE_EXTN_AUDIT;
616:
617: x_return_status := fnd_api.g_ret_sts_success;
618:
619: --Standard Call to check API compatibility
620: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
621: THEN

Line 620: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

616:
617: x_return_status := fnd_api.g_ret_sts_success;
618:
619: --Standard Call to check API compatibility
620: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
621: THEN
622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:

Line 622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

618:
619: --Standard Call to check API compatibility
620: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
621: THEN
622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
626: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 626: IF FND_API.To_boolean(P_INIT_MSG_LIST)

622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
626: IF FND_API.To_boolean(P_INIT_MSG_LIST)
627: THEN
628: FND_MSG_PUB.Initialize;
629: END IF;
630:

Line 640: if nvl(p_category,fnd_api.g_miss_char) <> NVL(rr_old_rec.category,fnd_api.g_miss_char)

636: open rr_old_cur(p_resource_id);
637: FETCH rr_old_cur into rr_old_rec;
638: close rr_old_cur;
639:
640: if nvl(p_category,fnd_api.g_miss_char) <> NVL(rr_old_rec.category,fnd_api.g_miss_char)
641: then
642: l_category := rr_old_rec.category;
643: l_category_n := p_category;
644: end if;

Line 645: if nvl(p_resource_number,fnd_api.g_miss_char) <> nvl(rr_old_rec.resource_number, fnd_api.g_miss_char)

641: then
642: l_category := rr_old_rec.category;
643: l_category_n := p_category;
644: end if;
645: if nvl(p_resource_number,fnd_api.g_miss_char) <> nvl(rr_old_rec.resource_number, fnd_api.g_miss_char)
646: then
647: l_resource_number := rr_old_rec.resource_number;
648: l_resource_number_n:= p_resource_number;
649: end if;

Line 675: if nvl(p_end_date_active,fnd_api.g_miss_date)<> nvl(rr_old_rec.end_date_active,fnd_api.g_miss_date)

671: then
672: l_start_date_active := rr_old_rec.start_date_active;
673: l_start_date_active_n := p_start_date_active ;
674: end if;
675: if nvl(p_end_date_active,fnd_api.g_miss_date)<> nvl(rr_old_rec.end_date_active,fnd_api.g_miss_date)
676: then
677: l_end_date_active := rr_old_rec.end_date_active;
678: l_end_date_active_n := p_end_date_active ;
679: end if;

Line 690: if nvl(p_primary_language, fnd_api.g_miss_char) <> nvl(rr_old_rec.primary_language,fnd_api.g_miss_char)

686: then
687: l_cost_per_hr := rr_old_rec.cost_per_hr;
688: l_cost_per_hr_n := p_cost_per_hr ;
689: end if;
690: if nvl(p_primary_language, fnd_api.g_miss_char) <> nvl(rr_old_rec.primary_language,fnd_api.g_miss_char)
691: then
692: l_primary_language := rr_old_rec.primary_language;
693: l_primary_language_n := p_primary_language;
694: end if;

Line 695: if nvl(p_secondary_language,fnd_api.g_miss_char) <> nvl(rr_old_rec.secondary_language, fnd_api.g_miss_char)

691: then
692: l_primary_language := rr_old_rec.primary_language;
693: l_primary_language_n := p_primary_language;
694: end if;
695: if nvl(p_secondary_language,fnd_api.g_miss_char) <> nvl(rr_old_rec.secondary_language, fnd_api.g_miss_char)
696: then
697: l_secondary_language := rr_old_rec.secondary_language;
698: l_secondary_language_n := p_secondary_language;
699: end if;

Line 700: if nvl(p_support_site_id,fnd_api.g_miss_num) <> nvl(rr_old_rec.support_site_id,fnd_api.g_miss_num)

696: then
697: l_secondary_language := rr_old_rec.secondary_language;
698: l_secondary_language_n := p_secondary_language;
699: end if;
700: if nvl(p_support_site_id,fnd_api.g_miss_num) <> nvl(rr_old_rec.support_site_id,fnd_api.g_miss_num)
701: then
702: l_support_site_id := rr_old_rec.support_site_id;
703: l_support_site_id_n := p_support_site_id ;
704: end if;

Line 705: if nvl(p_ies_agent_login, fnd_api.g_miss_char)<> nvl(rr_old_rec.ies_agent_login, fnd_api.g_miss_char)

701: then
702: l_support_site_id := rr_old_rec.support_site_id;
703: l_support_site_id_n := p_support_site_id ;
704: end if;
705: if nvl(p_ies_agent_login, fnd_api.g_miss_char)<> nvl(rr_old_rec.ies_agent_login, fnd_api.g_miss_char)
706: then
707: l_ies_agent_login := rr_old_rec.ies_agent_login;
708: l_ies_agent_login_n := p_ies_agent_login ;
709: end if;

Line 710: if nvl(p_server_group_id ,fnd_api.g_miss_num) <> nvl(rr_old_rec.server_group_id, fnd_api.g_miss_num)

706: then
707: l_ies_agent_login := rr_old_rec.ies_agent_login;
708: l_ies_agent_login_n := p_ies_agent_login ;
709: end if;
710: if nvl(p_server_group_id ,fnd_api.g_miss_num) <> nvl(rr_old_rec.server_group_id, fnd_api.g_miss_num)
711: then
712: l_server_group_id := rr_old_rec.server_group_id;
713: l_server_group_id_n := p_server_group_id ;
714: end if;

Line 725: if nvl(p_cost_center,fnd_api.g_miss_char) <> nvl(rr_old_rec.cost_center, fnd_api.g_miss_char)

721: then
722: l_assigned_to_group_id := rr_old_rec.assigned_to_group_id;
723: l_assigned_to_group_id_n := p_assigned_to_group_id;
724: end if;
725: if nvl(p_cost_center,fnd_api.g_miss_char) <> nvl(rr_old_rec.cost_center, fnd_api.g_miss_char)
726: then
727: l_cost_center := rr_old_rec.cost_center;
728: l_cost_center_n := p_cost_center ;
729: end if;

Line 730: if nvl(p_charge_to_cost_center,fnd_api.g_miss_char) <> nvl(rr_old_rec.charge_to_cost_center, fnd_api.g_miss_char)

726: then
727: l_cost_center := rr_old_rec.cost_center;
728: l_cost_center_n := p_cost_center ;
729: end if;
730: if nvl(p_charge_to_cost_center,fnd_api.g_miss_char) <> nvl(rr_old_rec.charge_to_cost_center, fnd_api.g_miss_char)
731: then
732: l_charge_to_cost_center := rr_old_rec.charge_to_cost_center;
733: l_charge_to_cost_center_n := p_charge_to_cost_center ;
734: end if;

Line 735: if nvl(p_comp_currency_code,fnd_api.g_miss_char) <> nvl(rr_old_rec.compensation_currency_code,fnd_api.g_miss_char)

731: then
732: l_charge_to_cost_center := rr_old_rec.charge_to_cost_center;
733: l_charge_to_cost_center_n := p_charge_to_cost_center ;
734: end if;
735: if nvl(p_comp_currency_code,fnd_api.g_miss_char) <> nvl(rr_old_rec.compensation_currency_code,fnd_api.g_miss_char)
736: then
737: l_comp_currency_code := rr_old_rec.compensation_currency_code;
738: l_comp_currency_code_n := p_comp_currency_code ;
739: end if;

Line 740: if nvl(p_commissionable_flag,fnd_api.g_miss_char) <> nvl(rr_old_rec.commissionable_flag , fnd_api.g_miss_char)

736: then
737: l_comp_currency_code := rr_old_rec.compensation_currency_code;
738: l_comp_currency_code_n := p_comp_currency_code ;
739: end if;
740: if nvl(p_commissionable_flag,fnd_api.g_miss_char) <> nvl(rr_old_rec.commissionable_flag , fnd_api.g_miss_char)
741: then
742: l_commissionable_flag := rr_old_rec.commissionable_flag;
743: l_commissionable_flag_n := p_commissionable_flag ;
744: end if;

Line 745: if nvl(p_hold_reason_code,fnd_api.g_miss_char) <> nvl(rr_old_rec.hold_reason_code, fnd_api.g_miss_char)

741: then
742: l_commissionable_flag := rr_old_rec.commissionable_flag;
743: l_commissionable_flag_n := p_commissionable_flag ;
744: end if;
745: if nvl(p_hold_reason_code,fnd_api.g_miss_char) <> nvl(rr_old_rec.hold_reason_code, fnd_api.g_miss_char)
746: then
747: l_hold_reason_code := rr_old_rec.hold_reason_code;
748: l_hold_reason_code_n := p_hold_reason_code ;
749: end if;

Line 750: if nvl(p_hold_payment,fnd_api.g_miss_char) <> nvl(rr_old_rec.hold_payment, fnd_api.g_miss_char)

746: then
747: l_hold_reason_code := rr_old_rec.hold_reason_code;
748: l_hold_reason_code_n := p_hold_reason_code ;
749: end if;
750: if nvl(p_hold_payment,fnd_api.g_miss_char) <> nvl(rr_old_rec.hold_payment, fnd_api.g_miss_char)
751: then
752: l_hold_payment:= rr_old_rec.hold_payment;
753: l_hold_payment_n := p_hold_payment ;
754: end if;

Line 780: if nvl(p_user_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.user_id, fnd_api.g_miss_num)

776: then
777: l_object_version_number := rr_old_rec.object_version_number;
778: l_object_version_number_n := p_object_version_number;
779: end if;
780: if nvl(p_user_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.user_id, fnd_api.g_miss_num)
781: then
782: l_user_id_o := rr_old_rec.user_id;
783: l_user_id_n := p_user_id;
784: end if;

Line 859: IF fnd_api.to_boolean (p_commit)

855:
856:
857:
858:
859: IF fnd_api.to_boolean (p_commit)
860: THEN
861: COMMIT WORK;
862: END IF;
863:

Line 868: WHEN fnd_api.g_exc_unexpected_error

864: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
865:
866:
867: EXCEPTION
868: WHEN fnd_api.g_exc_unexpected_error
869: THEN
870: ROLLBACK TO resource_extn_audit;
871: x_return_status := fnd_api.g_ret_sts_unexp_error;
872: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');

Line 871: x_return_status := fnd_api.g_ret_sts_unexp_error;

867: EXCEPTION
868: WHEN fnd_api.g_exc_unexpected_error
869: THEN
870: ROLLBACK TO resource_extn_audit;
871: x_return_status := fnd_api.g_ret_sts_unexp_error;
872: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
873: FND_MSG_PUB.add;
874: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
875: WHEN OTHERS

Line 878: x_return_status := fnd_api.g_ret_sts_unexp_error;

874: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
875: WHEN OTHERS
876: THEN
877: ROLLBACK TO resource_extn_audit;
878: x_return_status := fnd_api.g_ret_sts_unexp_error;
879: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
880: FND_MSG_PUB.add;
881: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
882:

Line 1178: x_return_status := fnd_api.g_ret_sts_success;

1174:
1175: --Standard Start of API SAVEPOINT
1176: SAVEPOINT RESOURCE_EXTN_AUDIT;
1177:
1178: x_return_status := fnd_api.g_ret_sts_success;
1179:
1180: --Standard Call to check API compatibility
1181: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1182: THEN

Line 1181: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

1177:
1178: x_return_status := fnd_api.g_ret_sts_success;
1179:
1180: --Standard Call to check API compatibility
1181: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1182: THEN
1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1184: END IF;
1185:

Line 1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1179:
1180: --Standard Call to check API compatibility
1181: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1182: THEN
1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1184: END IF;
1185:
1186: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1187: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 1187: IF FND_API.To_boolean(P_INIT_MSG_LIST)

1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1184: END IF;
1185:
1186: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1187: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1188: THEN
1189: FND_MSG_PUB.Initialize;
1190: END IF;
1191:

Line 1201: if nvl(p_category,fnd_api.g_miss_char) <> NVL(rr_old_rec.category,fnd_api.g_miss_char)

1197: open rr_old_cur(p_resource_id);
1198: FETCH rr_old_cur into rr_old_rec;
1199: close rr_old_cur;
1200:
1201: if nvl(p_category,fnd_api.g_miss_char) <> NVL(rr_old_rec.category,fnd_api.g_miss_char)
1202: then
1203: l_category := rr_old_rec.category;
1204: l_category_n := p_category;
1205: end if;

Line 1206: if nvl(p_resource_number,fnd_api.g_miss_char) <> nvl(rr_old_rec.resource_number, fnd_api.g_miss_char)

1202: then
1203: l_category := rr_old_rec.category;
1204: l_category_n := p_category;
1205: end if;
1206: if nvl(p_resource_number,fnd_api.g_miss_char) <> nvl(rr_old_rec.resource_number, fnd_api.g_miss_char)
1207: then
1208: l_resource_number := rr_old_rec.resource_number;
1209: l_resource_number_n:= p_resource_number;
1210: end if;

Line 1236: if nvl(p_end_date_active,fnd_api.g_miss_date)<> nvl(rr_old_rec.end_date_active,fnd_api.g_miss_date)

1232: then
1233: l_start_date_active := rr_old_rec.start_date_active;
1234: l_start_date_active_n := p_start_date_active ;
1235: end if;
1236: if nvl(p_end_date_active,fnd_api.g_miss_date)<> nvl(rr_old_rec.end_date_active,fnd_api.g_miss_date)
1237: then
1238: l_end_date_active := rr_old_rec.end_date_active;
1239: l_end_date_active_n := p_end_date_active ;
1240: end if;

Line 1251: if nvl(p_primary_language, fnd_api.g_miss_char) <> nvl(rr_old_rec.primary_language,fnd_api.g_miss_char)

1247: then
1248: l_cost_per_hr := rr_old_rec.cost_per_hr;
1249: l_cost_per_hr_n := p_cost_per_hr ;
1250: end if;
1251: if nvl(p_primary_language, fnd_api.g_miss_char) <> nvl(rr_old_rec.primary_language,fnd_api.g_miss_char)
1252: then
1253: l_primary_language := rr_old_rec.primary_language;
1254: l_primary_language_n := p_primary_language;
1255: end if;

Line 1256: if nvl(p_secondary_language,fnd_api.g_miss_char) <> nvl(rr_old_rec.secondary_language, fnd_api.g_miss_char)

1252: then
1253: l_primary_language := rr_old_rec.primary_language;
1254: l_primary_language_n := p_primary_language;
1255: end if;
1256: if nvl(p_secondary_language,fnd_api.g_miss_char) <> nvl(rr_old_rec.secondary_language, fnd_api.g_miss_char)
1257: then
1258: l_secondary_language := rr_old_rec.secondary_language;
1259: l_secondary_language_n := p_secondary_language;
1260: end if;

Line 1261: if nvl(p_support_site_id,fnd_api.g_miss_num) <> nvl(rr_old_rec.support_site_id,fnd_api.g_miss_num)

1257: then
1258: l_secondary_language := rr_old_rec.secondary_language;
1259: l_secondary_language_n := p_secondary_language;
1260: end if;
1261: if nvl(p_support_site_id,fnd_api.g_miss_num) <> nvl(rr_old_rec.support_site_id,fnd_api.g_miss_num)
1262: then
1263: l_support_site_id := rr_old_rec.support_site_id;
1264: l_support_site_id_n := p_support_site_id ;
1265: end if;

Line 1266: if nvl(p_ies_agent_login, fnd_api.g_miss_char)<> nvl(rr_old_rec.ies_agent_login, fnd_api.g_miss_char)

1262: then
1263: l_support_site_id := rr_old_rec.support_site_id;
1264: l_support_site_id_n := p_support_site_id ;
1265: end if;
1266: if nvl(p_ies_agent_login, fnd_api.g_miss_char)<> nvl(rr_old_rec.ies_agent_login, fnd_api.g_miss_char)
1267: then
1268: l_ies_agent_login := rr_old_rec.ies_agent_login;
1269: l_ies_agent_login_n := p_ies_agent_login ;
1270: end if;

Line 1271: if nvl(p_server_group_id ,fnd_api.g_miss_num) <> nvl(rr_old_rec.server_group_id, fnd_api.g_miss_num)

1267: then
1268: l_ies_agent_login := rr_old_rec.ies_agent_login;
1269: l_ies_agent_login_n := p_ies_agent_login ;
1270: end if;
1271: if nvl(p_server_group_id ,fnd_api.g_miss_num) <> nvl(rr_old_rec.server_group_id, fnd_api.g_miss_num)
1272: then
1273: l_server_group_id := rr_old_rec.server_group_id;
1274: l_server_group_id_n := p_server_group_id ;
1275: end if;

Line 1286: if nvl(p_cost_center,fnd_api.g_miss_char) <> nvl(rr_old_rec.cost_center, fnd_api.g_miss_char)

1282: then
1283: l_assigned_to_group_id := rr_old_rec.assigned_to_group_id;
1284: l_assigned_to_group_id_n := p_assigned_to_group_id;
1285: end if;
1286: if nvl(p_cost_center,fnd_api.g_miss_char) <> nvl(rr_old_rec.cost_center, fnd_api.g_miss_char)
1287: then
1288: l_cost_center := rr_old_rec.cost_center;
1289: l_cost_center_n := p_cost_center ;
1290: end if;

Line 1291: if nvl(p_charge_to_cost_center,fnd_api.g_miss_char) <> nvl(rr_old_rec.charge_to_cost_center, fnd_api.g_miss_char)

1287: then
1288: l_cost_center := rr_old_rec.cost_center;
1289: l_cost_center_n := p_cost_center ;
1290: end if;
1291: if nvl(p_charge_to_cost_center,fnd_api.g_miss_char) <> nvl(rr_old_rec.charge_to_cost_center, fnd_api.g_miss_char)
1292: then
1293: l_charge_to_cost_center := rr_old_rec.charge_to_cost_center;
1294: l_charge_to_cost_center_n := p_charge_to_cost_center ;
1295: end if;

Line 1296: if nvl(p_comp_currency_code,fnd_api.g_miss_char) <> nvl(rr_old_rec.compensation_currency_code,fnd_api.g_miss_char)

1292: then
1293: l_charge_to_cost_center := rr_old_rec.charge_to_cost_center;
1294: l_charge_to_cost_center_n := p_charge_to_cost_center ;
1295: end if;
1296: if nvl(p_comp_currency_code,fnd_api.g_miss_char) <> nvl(rr_old_rec.compensation_currency_code,fnd_api.g_miss_char)
1297: then
1298: l_comp_currency_code := rr_old_rec.compensation_currency_code;
1299: l_comp_currency_code_n := p_comp_currency_code ;
1300: end if;

Line 1301: if nvl(p_commissionable_flag,fnd_api.g_miss_char) <> nvl(rr_old_rec.commissionable_flag , fnd_api.g_miss_char)

1297: then
1298: l_comp_currency_code := rr_old_rec.compensation_currency_code;
1299: l_comp_currency_code_n := p_comp_currency_code ;
1300: end if;
1301: if nvl(p_commissionable_flag,fnd_api.g_miss_char) <> nvl(rr_old_rec.commissionable_flag , fnd_api.g_miss_char)
1302: then
1303: l_commissionable_flag := rr_old_rec.commissionable_flag;
1304: l_commissionable_flag_n := p_commissionable_flag ;
1305: end if;

Line 1306: if nvl(p_hold_reason_code,fnd_api.g_miss_char) <> nvl(rr_old_rec.hold_reason_code, fnd_api.g_miss_char)

1302: then
1303: l_commissionable_flag := rr_old_rec.commissionable_flag;
1304: l_commissionable_flag_n := p_commissionable_flag ;
1305: end if;
1306: if nvl(p_hold_reason_code,fnd_api.g_miss_char) <> nvl(rr_old_rec.hold_reason_code, fnd_api.g_miss_char)
1307: then
1308: l_hold_reason_code := rr_old_rec.hold_reason_code;
1309: l_hold_reason_code_n := p_hold_reason_code ;
1310: end if;

Line 1311: if nvl(p_hold_payment,fnd_api.g_miss_char) <> nvl(rr_old_rec.hold_payment, fnd_api.g_miss_char)

1307: then
1308: l_hold_reason_code := rr_old_rec.hold_reason_code;
1309: l_hold_reason_code_n := p_hold_reason_code ;
1310: end if;
1311: if nvl(p_hold_payment,fnd_api.g_miss_char) <> nvl(rr_old_rec.hold_payment, fnd_api.g_miss_char)
1312: then
1313: l_hold_payment:= rr_old_rec.hold_payment;
1314: l_hold_payment_n := p_hold_payment ;
1315: end if;

Line 1341: if nvl(p_user_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.user_id, fnd_api.g_miss_num)

1337: then
1338: l_object_version_number := rr_old_rec.object_version_number;
1339: l_object_version_number_n := p_object_version_number;
1340: end if;
1341: if nvl(p_user_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.user_id, fnd_api.g_miss_num)
1342: then
1343: l_user_id_o := rr_old_rec.user_id;
1344: l_user_id_n := p_user_id;
1345: end if;

Line 1347: if nvl(p_resource_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.resource_name, fnd_api.g_miss_char)

1343: l_user_id_o := rr_old_rec.user_id;
1344: l_user_id_n := p_user_id;
1345: end if;
1346:
1347: if nvl(p_resource_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.resource_name, fnd_api.g_miss_char)
1348: then
1349: l_resource_name := rr_old_rec.resource_name;
1350: l_resource_name_n := p_resource_name;
1351: end if;

Line 1353: if nvl(p_source_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_name, fnd_api.g_miss_char)

1349: l_resource_name := rr_old_rec.resource_name;
1350: l_resource_name_n := p_resource_name;
1351: end if;
1352:
1353: if nvl(p_source_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_name, fnd_api.g_miss_char)
1354: then
1355: l_source_name := rr_old_rec.source_name;
1356: l_source_name_n := p_source_name;
1357: end if;

Line 1359: if nvl(p_source_job_title, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_job_title, fnd_api.g_miss_char)

1355: l_source_name := rr_old_rec.source_name;
1356: l_source_name_n := p_source_name;
1357: end if;
1358:
1359: if nvl(p_source_job_title, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_job_title, fnd_api.g_miss_char)
1360: then
1361: l_source_job_title := rr_old_rec.source_job_title;
1362: l_source_job_title_n := p_source_job_title;
1363: end if;

Line 1365: if nvl(p_source_email, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_email, fnd_api.g_miss_char)

1361: l_source_job_title := rr_old_rec.source_job_title;
1362: l_source_job_title_n := p_source_job_title;
1363: end if;
1364:
1365: if nvl(p_source_email, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_email, fnd_api.g_miss_char)
1366: then
1367: l_source_email := rr_old_rec.source_email;
1368: l_source_email_n := p_source_email;
1369: end if;

Line 1371: if nvl(p_source_number, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_number, fnd_api.g_miss_char)

1367: l_source_email := rr_old_rec.source_email;
1368: l_source_email_n := p_source_email;
1369: end if;
1370:
1371: if nvl(p_source_number, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_number, fnd_api.g_miss_char)
1372: then
1373: l_source_number := rr_old_rec.source_number;
1374: l_source_number_n := p_source_number;
1375: end if;

Line 1377: if nvl(p_source_phone, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_phone, fnd_api.g_miss_char)

1373: l_source_number := rr_old_rec.source_number;
1374: l_source_number_n := p_source_number;
1375: end if;
1376:
1377: if nvl(p_source_phone, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_phone, fnd_api.g_miss_char)
1378: then
1379: l_source_phone := rr_old_rec.source_phone;
1380: l_source_phone_n := p_source_phone;
1381: end if;

Line 1383: if nvl(p_source_org_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.source_org_id, fnd_api.g_miss_num)

1379: l_source_phone := rr_old_rec.source_phone;
1380: l_source_phone_n := p_source_phone;
1381: end if;
1382:
1383: if nvl(p_source_org_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.source_org_id, fnd_api.g_miss_num)
1384: then
1385: l_source_org_id := rr_old_rec.source_org_id;
1386: l_source_org_id_n := p_source_org_id;
1387: end if;

Line 1389: if nvl(p_source_org_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_org_name, fnd_api.g_miss_char)

1385: l_source_org_id := rr_old_rec.source_org_id;
1386: l_source_org_id_n := p_source_org_id;
1387: end if;
1388:
1389: if nvl(p_source_org_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_org_name, fnd_api.g_miss_char)
1390: then
1391: l_source_org_name := rr_old_rec.source_org_name;
1392: l_source_org_name_n := p_source_org_name;
1393: end if;

Line 1395: if nvl(p_source_address1, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_address1, fnd_api.g_miss_char)

1391: l_source_org_name := rr_old_rec.source_org_name;
1392: l_source_org_name_n := p_source_org_name;
1393: end if;
1394:
1395: if nvl(p_source_address1, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_address1, fnd_api.g_miss_char)
1396: then
1397: l_source_address1 := rr_old_rec.source_address1;
1398: l_source_address1_n := p_source_address1;
1399: end if;

Line 1401: if nvl(p_source_address2, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_address2, fnd_api.g_miss_char)

1397: l_source_address1 := rr_old_rec.source_address1;
1398: l_source_address1_n := p_source_address1;
1399: end if;
1400:
1401: if nvl(p_source_address2, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_address2, fnd_api.g_miss_char)
1402: then
1403: l_source_address2 := rr_old_rec.source_address2;
1404: l_source_address2_n := p_source_address2;
1405: end if;

Line 1407: if nvl(p_source_address3, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_address3, fnd_api.g_miss_char)

1403: l_source_address2 := rr_old_rec.source_address2;
1404: l_source_address2_n := p_source_address2;
1405: end if;
1406:
1407: if nvl(p_source_address3, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_address3, fnd_api.g_miss_char)
1408: then
1409: l_source_address3 := rr_old_rec.source_address3;
1410: l_source_address3_n := p_source_address3;
1411: end if;

Line 1413: if nvl(p_source_address4, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_address4, fnd_api.g_miss_char)

1409: l_source_address3 := rr_old_rec.source_address3;
1410: l_source_address3_n := p_source_address3;
1411: end if;
1412:
1413: if nvl(p_source_address4, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_address4, fnd_api.g_miss_char)
1414: then
1415: l_source_address4 := rr_old_rec.source_address4;
1416: l_source_address4_n := p_source_address4;
1417: end if;

Line 1419: if nvl(p_source_city, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_city, fnd_api.g_miss_char)

1415: l_source_address4 := rr_old_rec.source_address4;
1416: l_source_address4_n := p_source_address4;
1417: end if;
1418:
1419: if nvl(p_source_city, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_city, fnd_api.g_miss_char)
1420: then
1421: l_source_city := rr_old_rec.source_city;
1422: l_source_city_n := p_source_city;
1423: end if;

Line 1425: if nvl(p_source_postal_code, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_postal_code, fnd_api.g_miss_char)

1421: l_source_city := rr_old_rec.source_city;
1422: l_source_city_n := p_source_city;
1423: end if;
1424:
1425: if nvl(p_source_postal_code, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_postal_code, fnd_api.g_miss_char)
1426: then
1427: l_source_postal_code := rr_old_rec.source_postal_code;
1428: l_source_postal_code_n := p_source_postal_code;
1429: end if;

Line 1431: if nvl(p_source_state, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_state, fnd_api.g_miss_char)

1427: l_source_postal_code := rr_old_rec.source_postal_code;
1428: l_source_postal_code_n := p_source_postal_code;
1429: end if;
1430:
1431: if nvl(p_source_state, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_state, fnd_api.g_miss_char)
1432: then
1433: l_source_state := rr_old_rec.source_state;
1434: l_source_state_n := p_source_state;
1435: end if;

Line 1437: if nvl(p_source_province, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_province, fnd_api.g_miss_char)

1433: l_source_state := rr_old_rec.source_state;
1434: l_source_state_n := p_source_state;
1435: end if;
1436:
1437: if nvl(p_source_province, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_province, fnd_api.g_miss_char)
1438: then
1439: l_source_province := rr_old_rec.source_province;
1440: l_source_province_n := p_source_province;
1441: end if;

Line 1443: if nvl(p_source_county, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_county, fnd_api.g_miss_char)

1439: l_source_province := rr_old_rec.source_province;
1440: l_source_province_n := p_source_province;
1441: end if;
1442:
1443: if nvl(p_source_county, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_county, fnd_api.g_miss_char)
1444: then
1445: l_source_county := rr_old_rec.source_county;
1446: l_source_county_n := p_source_county;
1447: end if;

Line 1449: if nvl(p_source_country, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_country, fnd_api.g_miss_char)

1445: l_source_county := rr_old_rec.source_county;
1446: l_source_county_n := p_source_county;
1447: end if;
1448:
1449: if nvl(p_source_country, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_country, fnd_api.g_miss_char)
1450: then
1451: l_source_country := rr_old_rec.source_country;
1452: l_source_country_n := p_source_country;
1453: end if;

Line 1455: if nvl(p_source_mgr_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.source_mgr_id, fnd_api.g_miss_num)

1451: l_source_country := rr_old_rec.source_country;
1452: l_source_country_n := p_source_country;
1453: end if;
1454:
1455: if nvl(p_source_mgr_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.source_mgr_id, fnd_api.g_miss_num)
1456: then
1457: l_source_mgr_id := rr_old_rec.source_mgr_id;
1458: l_source_mgr_id_n := p_source_mgr_id;
1459: end if;

Line 1461: if nvl(p_source_mgr_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_mgr_name, fnd_api.g_miss_char)

1457: l_source_mgr_id := rr_old_rec.source_mgr_id;
1458: l_source_mgr_id_n := p_source_mgr_id;
1459: end if;
1460:
1461: if nvl(p_source_mgr_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_mgr_name, fnd_api.g_miss_char)
1462: then
1463: l_source_mgr_name := rr_old_rec.source_mgr_name;
1464: l_source_mgr_name_n := p_source_mgr_name;
1465: end if;

Line 1467: if nvl(p_source_business_grp_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.source_business_grp_id, fnd_api.g_miss_num)

1463: l_source_mgr_name := rr_old_rec.source_mgr_name;
1464: l_source_mgr_name_n := p_source_mgr_name;
1465: end if;
1466:
1467: if nvl(p_source_business_grp_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.source_business_grp_id, fnd_api.g_miss_num)
1468: then
1469: l_source_business_grp_id := rr_old_rec.source_business_grp_id;
1470: l_source_business_grp_id_n := p_source_business_grp_id;
1471: end if;

Line 1473: if nvl(p_source_business_grp_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_business_grp_name, fnd_api.g_miss_char)

1469: l_source_business_grp_id := rr_old_rec.source_business_grp_id;
1470: l_source_business_grp_id_n := p_source_business_grp_id;
1471: end if;
1472:
1473: if nvl(p_source_business_grp_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_business_grp_name, fnd_api.g_miss_char)
1474: then
1475: l_source_business_grp_name := rr_old_rec.source_business_grp_name;
1476: l_source_business_grp_name_n := p_source_business_grp_name;
1477: end if;

Line 1479: if nvl(p_source_first_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_first_name, fnd_api.g_miss_char)

1475: l_source_business_grp_name := rr_old_rec.source_business_grp_name;
1476: l_source_business_grp_name_n := p_source_business_grp_name;
1477: end if;
1478:
1479: if nvl(p_source_first_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_first_name, fnd_api.g_miss_char)
1480: then
1481: l_source_first_name := rr_old_rec.source_first_name;
1482: l_source_first_name_n := p_source_first_name;
1483: end if;

Line 1485: if nvl(p_source_middle_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_middle_name, fnd_api.g_miss_char)

1481: l_source_first_name := rr_old_rec.source_first_name;
1482: l_source_first_name_n := p_source_first_name;
1483: end if;
1484:
1485: if nvl(p_source_middle_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_middle_name, fnd_api.g_miss_char)
1486: then
1487: l_source_middle_name := rr_old_rec.source_middle_name;
1488: l_source_middle_name_n := p_source_middle_name;
1489: end if;

Line 1491: if nvl(p_source_last_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_last_name, fnd_api.g_miss_char)

1487: l_source_middle_name := rr_old_rec.source_middle_name;
1488: l_source_middle_name_n := p_source_middle_name;
1489: end if;
1490:
1491: if nvl(p_source_last_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_last_name, fnd_api.g_miss_char)
1492: then
1493: l_source_last_name := rr_old_rec.source_last_name;
1494: l_source_last_name_n := p_source_last_name;
1495: end if;

Line 1497: if nvl(p_source_category, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_category, fnd_api.g_miss_char)

1493: l_source_last_name := rr_old_rec.source_last_name;
1494: l_source_last_name_n := p_source_last_name;
1495: end if;
1496:
1497: if nvl(p_source_category, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_category, fnd_api.g_miss_char)
1498: then
1499: l_source_category := rr_old_rec.source_category;
1500: l_source_category_n := p_source_category;
1501: end if;

Line 1503: if nvl(p_source_status, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_status, fnd_api.g_miss_char)

1499: l_source_category := rr_old_rec.source_category;
1500: l_source_category_n := p_source_category;
1501: end if;
1502:
1503: if nvl(p_source_status, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_status, fnd_api.g_miss_char)
1504: then
1505: l_source_status := rr_old_rec.source_status;
1506: l_source_status_n := p_source_status;
1507: end if;

Line 1509: if nvl(p_source_office, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_office, fnd_api.g_miss_char)

1505: l_source_status := rr_old_rec.source_status;
1506: l_source_status_n := p_source_status;
1507: end if;
1508:
1509: if nvl(p_source_office, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_office, fnd_api.g_miss_char)
1510: then
1511: l_source_office := rr_old_rec.source_office;
1512: l_source_office_n := p_source_office;
1513: end if;

Line 1515: if nvl(p_source_location, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_location, fnd_api.g_miss_char)

1511: l_source_office := rr_old_rec.source_office;
1512: l_source_office_n := p_source_office;
1513: end if;
1514:
1515: if nvl(p_source_location, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_location, fnd_api.g_miss_char)
1516: then
1517: l_source_location := rr_old_rec.source_location;
1518: l_source_location_n := p_source_location;
1519: end if;

Line 1521: if nvl(p_source_mailstop, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_mailstop, fnd_api.g_miss_char)

1517: l_source_location := rr_old_rec.source_location;
1518: l_source_location_n := p_source_location;
1519: end if;
1520:
1521: if nvl(p_source_mailstop, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_mailstop, fnd_api.g_miss_char)
1522: then
1523: l_source_mailstop := rr_old_rec.source_mailstop;
1524: l_source_mailstop_n := p_source_mailstop;
1525: end if;

Line 1527: if nvl(p_source_mobile_phone, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_mobile_phone, fnd_api.g_miss_char)

1523: l_source_mailstop := rr_old_rec.source_mailstop;
1524: l_source_mailstop_n := p_source_mailstop;
1525: end if;
1526:
1527: if nvl(p_source_mobile_phone, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_mobile_phone, fnd_api.g_miss_char)
1528: then
1529: l_source_mobile_phone := rr_old_rec.source_mobile_phone;
1530: l_source_mobile_phone_n := p_source_mobile_phone;
1531: end if;

Line 1533: if nvl(p_source_pager, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_pager, fnd_api.g_miss_char)

1529: l_source_mobile_phone := rr_old_rec.source_mobile_phone;
1530: l_source_mobile_phone_n := p_source_mobile_phone;
1531: end if;
1532:
1533: if nvl(p_source_pager, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_pager, fnd_api.g_miss_char)
1534: then
1535: l_source_pager := rr_old_rec.source_pager;
1536: l_source_pager_n := p_source_pager;
1537: end if;

Line 1539: if nvl(p_user_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.user_name, fnd_api.g_miss_char)

1535: l_source_pager := rr_old_rec.source_pager;
1536: l_source_pager_n := p_source_pager;
1537: end if;
1538:
1539: if nvl(p_user_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.user_name, fnd_api.g_miss_char)
1540: then
1541: l_user_name := rr_old_rec.user_name;
1542: l_user_name_n := p_user_name;
1543: end if;

Line 1545: if nvl(p_source_job_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.source_job_id, fnd_api.g_miss_num)

1541: l_user_name := rr_old_rec.user_name;
1542: l_user_name_n := p_user_name;
1543: end if;
1544:
1545: if nvl(p_source_job_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.source_job_id, fnd_api.g_miss_num)
1546: then
1547: l_source_job_id := rr_old_rec.source_job_id;
1548: l_source_job_id_n := p_source_job_id;
1549: end if;

Line 1551: if nvl(p_party_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.person_party_id, fnd_api.g_miss_num)

1547: l_source_job_id := rr_old_rec.source_job_id;
1548: l_source_job_id_n := p_source_job_id;
1549: end if;
1550:
1551: if nvl(p_party_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.person_party_id, fnd_api.g_miss_num)
1552: then
1553: l_party_id := rr_old_rec.person_party_id;
1554: l_party_id_n := p_party_id;
1555: end if;

Line 1701: IF fnd_api.to_boolean (p_commit)

1697: X_OLD_SOURCE_PAGER => l_source_pager
1698: );
1699:
1700:
1701: IF fnd_api.to_boolean (p_commit)
1702: THEN
1703: COMMIT WORK;
1704: END IF;
1705:

Line 1710: WHEN fnd_api.g_exc_unexpected_error

1706: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1707:
1708:
1709: EXCEPTION
1710: WHEN fnd_api.g_exc_unexpected_error
1711: THEN
1712: ROLLBACK TO resource_extn_audit;
1713: x_return_status := fnd_api.g_ret_sts_unexp_error;
1714: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');

Line 1713: x_return_status := fnd_api.g_ret_sts_unexp_error;

1709: EXCEPTION
1710: WHEN fnd_api.g_exc_unexpected_error
1711: THEN
1712: ROLLBACK TO resource_extn_audit;
1713: x_return_status := fnd_api.g_ret_sts_unexp_error;
1714: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
1715: FND_MSG_PUB.add;
1716: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1717: WHEN OTHERS

Line 1720: x_return_status := fnd_api.g_ret_sts_unexp_error;

1716: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1717: WHEN OTHERS
1718: THEN
1719: ROLLBACK TO resource_extn_audit;
1720: x_return_status := fnd_api.g_ret_sts_unexp_error;
1721: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
1722: FND_MSG_PUB.add;
1723: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1724:

Line 1888: x_return_status := fnd_api.g_ret_sts_success;

1884:
1885: --Standard Start of API SAVEPOINT
1886: SAVEPOINT RESOURCE_EXTN_AUDIT;
1887:
1888: x_return_status := fnd_api.g_ret_sts_success;
1889:
1890: --Standard Call to check API compatibility
1891: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1892: THEN

Line 1891: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

1887:
1888: x_return_status := fnd_api.g_ret_sts_success;
1889:
1890: --Standard Call to check API compatibility
1891: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1892: THEN
1893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1894: END IF;
1895:

Line 1893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1889:
1890: --Standard Call to check API compatibility
1891: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1892: THEN
1893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1894: END IF;
1895:
1896: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1897: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 1897: IF FND_API.To_boolean(P_INIT_MSG_LIST)

1893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1894: END IF;
1895:
1896: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1897: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1898: THEN
1899: FND_MSG_PUB.Initialize;
1900: END IF;
1901:

Line 2110: IF fnd_api.to_boolean (p_commit)

2106: X_OLD_SOURCE_PAGER => l_source_pager
2107: );
2108:
2109:
2110: IF fnd_api.to_boolean (p_commit)
2111: THEN
2112: COMMIT WORK;
2113: END IF;
2114:

Line 2119: WHEN fnd_api.g_exc_unexpected_error

2115: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2116:
2117:
2118: EXCEPTION
2119: WHEN fnd_api.g_exc_unexpected_error
2120: THEN
2121: ROLLBACK TO resource_extn_audit;
2122: x_return_status := fnd_api.g_ret_sts_unexp_error;
2123: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');

Line 2122: x_return_status := fnd_api.g_ret_sts_unexp_error;

2118: EXCEPTION
2119: WHEN fnd_api.g_exc_unexpected_error
2120: THEN
2121: ROLLBACK TO resource_extn_audit;
2122: x_return_status := fnd_api.g_ret_sts_unexp_error;
2123: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
2124: FND_MSG_PUB.add;
2125: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2126: WHEN OTHERS

Line 2129: x_return_status := fnd_api.g_ret_sts_unexp_error;

2125: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2126: WHEN OTHERS
2127: THEN
2128: ROLLBACK TO resource_extn_audit;
2129: x_return_status := fnd_api.g_ret_sts_unexp_error;
2130: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
2131: FND_MSG_PUB.add;
2132: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2133: