APPS.IGS_AD_IMP_006 dependencies on IGS_AD_EMP_DTL

Line 26: pkpatel 23-Feb-2006 Bug 4937960 (Used the table HZ_EMPLOYMENT_HISTORY directly instead of the view IGS_AD_EMP_DTL)

22: npalanis 14-JUN-2002 Bug - 2409967
23: the cursor check is put inside the check for error code.
24: gmaheswa 10-NOV-2003 Bug - 3223043 HZ.K impact changes
25: gmaheswa 15-DEC-2003 Bug 3316838 Removed code related to date overlap under same employer or employer party number.
26: pkpatel 23-Feb-2006 Bug 4937960 (Used the table HZ_EMPLOYMENT_HISTORY directly instead of the view IGS_AD_EMP_DTL)
27: skpandey 16-May-2006 Bug - 5205911 added comments column to IGS_AD_EMP_INT_ALL
28: */
29: --1
30:

Line 519: --signature of Igs_Ad_Emp_Dtl_Pkg is changed and columns branch,military rank,served,station are obsoleted

515: -- Validate the values of PERSON_EMP_REC.
516: validate_emp_dtls(PERSON_EMP_REC,l_employer_party_id,l_error_code);
517:
518: IF l_error_code IS NULL THEN
519: --signature of Igs_Ad_Emp_Dtl_Pkg is changed and columns branch,military rank,served,station are obsoleted
520: Igs_Ad_Emp_Dtl_Pkg.INSERT_ROW (
521: X_ROWID => l_RowId,
522: x_employment_history_id => l_Employment_History_Id,
523: x_PERSON_ID => PERSON_EMP_REC.person_id,

Line 520: Igs_Ad_Emp_Dtl_Pkg.INSERT_ROW (

516: validate_emp_dtls(PERSON_EMP_REC,l_employer_party_id,l_error_code);
517:
518: IF l_error_code IS NULL THEN
519: --signature of Igs_Ad_Emp_Dtl_Pkg is changed and columns branch,military rank,served,station are obsoleted
520: Igs_Ad_Emp_Dtl_Pkg.INSERT_ROW (
521: X_ROWID => l_RowId,
522: x_employment_history_id => l_Employment_History_Id,
523: x_PERSON_ID => PERSON_EMP_REC.person_id,
524: x_START_DT => PERSON_EMP_REC.Start_Date,

Line 706: cp_start_date igs_ad_emp_dtl.start_dt%TYPE) IS

702: DECLARE
703: CURSOR chk_dup_emp_dtls(cp_employer VARCHAR2,
704: cp_employer_party_number VARCHAR2,
705: cp_person_id NUMBER,
706: cp_start_date igs_ad_emp_dtl.start_dt%TYPE) IS
707: SELECT heh.rowid row_id,
708: heh.employment_history_id,
709: heh.party_id person_id,
710: heh.begin_date start_dt,

Line 760: igs_ad_emp_dtl_pkg.update_row (

756: BEGIN
757: -- Validate the values of person_emp_rec.
758: validate_emp_dtls(PERSON_EMP_REC,l_employer_party_id,l_error_code);
759: IF l_error_code IS NULL THEN -- nsidana Bug 3541735 : Corrected the check from not null --> null.
760: igs_ad_emp_dtl_pkg.update_row (
761: x_rowid => dup_emp_dtlsc_rec.row_id,
762: x_employment_history_id => dup_emp_dtlsc_rec.employment_history_id,
763: x_person_id => NVL(person_emp_rec.person_id,dup_emp_dtlsc_rec.person_id),
764: x_start_dt => NVL(person_emp_rec.start_date,dup_emp_dtlsc_rec.start_dt),

Line 863: igs_ad_emp_dtl_pkg.update_row (

859: BEGIN
860: -- Validate the values of person_emp_rec.
861: validate_emp_dtls(PERSON_EMP_REC,l_employer_party_id,l_error_code);
862: IF l_error_code IS NULL THEN -- nsidana Bug 3541735 : Corrected the check from not null --> null.
863: igs_ad_emp_dtl_pkg.update_row (
864: x_rowid => dup_emp_dtlsc_rec.row_id,
865: x_employment_history_id => dup_emp_dtlsc_rec.employment_history_id,
866: x_person_id => NVL(person_emp_rec.person_id,dup_emp_dtlsc_rec.person_id),
867: x_start_dt => NVL(person_emp_rec.start_date,dup_emp_dtlsc_rec.start_dt),