APPS.IGS_PE_PERSON_SS_PKG dependencies on IGS_AD_EMP_DTL

Line 970: FROM igs_ad_emp_dtl

966: served ,
967: station,
968: reason_for_leaving,
969: employed_by_party_id
970: FROM igs_ad_emp_dtl
971: WHERE employment_history_id = p_employment_history_id;
972: BEGIN
973: -- Standard Start of API savepoint
974: SAVEPOINT Update_Employment;

Line 992: -- If mode='INSERT' call igs_ad_emp_dtl_pkg.INSERT_ROW

988:
989: FND_MSG_PUB.initialize;
990:
991: -- API body
992: -- If mode='INSERT' call igs_ad_emp_dtl_pkg.INSERT_ROW
993: -- If mode='UPDATE': retrieve current row values to be passed to the procedure and call igs_ad_emp_dtl_pkg.UPDATE_ROW
994: -- If mode='DELETE' call igs_ad_emp_dtl_pkg.DELETE_ROW
995:
996: IF p_start_dt IS NOT NULL AND p_end_dt IS NOT NULL THEN

Line 993: -- If mode='UPDATE': retrieve current row values to be passed to the procedure and call igs_ad_emp_dtl_pkg.UPDATE_ROW

989: FND_MSG_PUB.initialize;
990:
991: -- API body
992: -- If mode='INSERT' call igs_ad_emp_dtl_pkg.INSERT_ROW
993: -- If mode='UPDATE': retrieve current row values to be passed to the procedure and call igs_ad_emp_dtl_pkg.UPDATE_ROW
994: -- If mode='DELETE' call igs_ad_emp_dtl_pkg.DELETE_ROW
995:
996: IF p_start_dt IS NOT NULL AND p_end_dt IS NOT NULL THEN
997: IF p_start_dt > p_end_dt THEN

Line 994: -- If mode='DELETE' call igs_ad_emp_dtl_pkg.DELETE_ROW

990:
991: -- API body
992: -- If mode='INSERT' call igs_ad_emp_dtl_pkg.INSERT_ROW
993: -- If mode='UPDATE': retrieve current row values to be passed to the procedure and call igs_ad_emp_dtl_pkg.UPDATE_ROW
994: -- If mode='DELETE' call igs_ad_emp_dtl_pkg.DELETE_ROW
995:
996: IF p_start_dt IS NOT NULL AND p_end_dt IS NOT NULL THEN
997: IF p_start_dt > p_end_dt THEN
998: FND_MESSAGE.SET_NAME ('IGS','IGS_GE_INVALID_DATE');

Line 1007: igs_ad_emp_dtl_pkg.update_row(

1003:
1004: IF p_mode='UPDATE' THEN
1005: FOR c_rowid_rec IN c_rowid LOOP
1006: l_rowid := c_rowid_rec.row_id;
1007: igs_ad_emp_dtl_pkg.update_row(
1008: x_rowid => l_rowid,
1009: x_employment_history_id => l_employment_history_id,
1010: x_person_id => p_person_id,
1011: x_start_dt => p_start_dt,

Line 1039: igs_ad_emp_dtl_pkg.insert_row(

1035: raise FND_API.G_EXC_ERROR;
1036: END IF;
1037: END LOOP;
1038: ELSIF p_mode='INSERT' THEN
1039: igs_ad_emp_dtl_pkg.insert_row(
1040: x_rowid => l_rowid,
1041: x_employment_history_id => l_employment_history_id,
1042: x_person_id => p_person_id,
1043: x_start_dt => p_start_dt,

Line 1072: igs_ad_emp_dtl_pkg.delete_row(

1068: END IF;
1069: ELSIF p_mode='DELETE' THEN
1070: FOR c_rowid_rec IN c_rowid LOOP
1071: l_rowid := c_rowid_rec.row_id;
1072: igs_ad_emp_dtl_pkg.delete_row(
1073: x_rowid => l_rowid);
1074: END LOOP;
1075: END IF;
1076: x_id := l_employment_history_id;