APPS.IGS_OR_ORG_ALT_IDS_PKG dependencies on IGS_OR_CWLK_DTL

Line 744: CURSOR cur_get_rowid(cp_org_alt_id_typ igs_or_cwlk_dtl.alt_id_type%TYPE, cp_alt_id_val igs_or_cwlk_dtl.alt_id_value%TYPE, cp_rowid ROWID) IS

740: skpandey 28-MAR-2006 Bug#:3634881, RECORD ALREADY EXISTS WHEN INSERTING A NEW ORG ALTERNATE ID, DUPLICATE AT INST
741: (reverse chronological order - newest change first)
742: ***************************************************************/
743: --Check Duplicate record and then delete
744: CURSOR cur_get_rowid(cp_org_alt_id_typ igs_or_cwlk_dtl.alt_id_type%TYPE, cp_alt_id_val igs_or_cwlk_dtl.alt_id_value%TYPE, cp_rowid ROWID) IS
745: SELECT rowid
746: FROM igs_or_cwlk_dtl
747: WHERE alt_id_type = cp_org_alt_id_typ
748: AND alt_id_value = cp_alt_id_val

Line 746: FROM igs_or_cwlk_dtl

742: ***************************************************************/
743: --Check Duplicate record and then delete
744: CURSOR cur_get_rowid(cp_org_alt_id_typ igs_or_cwlk_dtl.alt_id_type%TYPE, cp_alt_id_val igs_or_cwlk_dtl.alt_id_value%TYPE, cp_rowid ROWID) IS
745: SELECT rowid
746: FROM igs_or_cwlk_dtl
747: WHERE alt_id_type = cp_org_alt_id_typ
748: AND alt_id_value = cp_alt_id_val
749: AND NOT EXISTS ( SELECT 1
750: FROM igs_or_org_alt_ids

Line 777: igs_or_cwlk_dtl_pkg.delete_row(x_rowid => l_row_id);

773: p_action => 'DELETE',
774: x_rowid => X_ROWID
775: );
776: IF l_row_id IS NOT NULL THEN
777: igs_or_cwlk_dtl_pkg.delete_row(x_rowid => l_row_id);
778: END IF;
779:
780: END DELETE_ROW;
781: