APPS.IGS_PE_PERS_ENCUMB_PKG dependencies on IGS_FI_ENCMB_TYPE

Line 112: CURSOR system_type_cur(cp_encumbrance_type igs_fi_encmb_type.encumbrance_type%TYPE) IS

108: WHERE ovr.elgb_override_id =hovr.elgb_override_id AND
109: ovr.person_id = new_references.person_id AND new_references.start_dt = hovr.start_date
110: AND new_references.encumbrance_type = hovr.hold_type;
111:
112: CURSOR system_type_cur(cp_encumbrance_type igs_fi_encmb_type.encumbrance_type%TYPE) IS
113: SELECT s_encumbrance_cat
114: FROM igs_fi_encmb_type
115: WHERE encumbrance_type = cp_encumbrance_type;
116:

Line 114: FROM igs_fi_encmb_type

110: AND new_references.encumbrance_type = hovr.hold_type;
111:
112: CURSOR system_type_cur(cp_encumbrance_type igs_fi_encmb_type.encumbrance_type%TYPE) IS
113: SELECT s_encumbrance_cat
114: FROM igs_fi_encmb_type
115: WHERE encumbrance_type = cp_encumbrance_type;
116:
117: system_type_rec system_type_cur%ROWTYPE;
118:

Line 486: IF NOT IGS_FI_ENCMB_TYPE_PKG.Get_PK_For_Validation (

482: IF (((old_references.encumbrance_type = new_references.encumbrance_type )) OR
483: ((new_references.encumbrance_type IS NULL))) THEN
484: NULL;
485: ELSE
486: IF NOT IGS_FI_ENCMB_TYPE_PKG.Get_PK_For_Validation (
487: new_references.encumbrance_type ) THEN
488: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
489: IGS_GE_MSG_STACK.ADD;
490: App_Exception.Raise_Exception;

Line 620: PROCEDURE GET_FK_IGS_FI_ENCMB_TYPE (

616: END IF;
617: Close cur_rowid;
618: END GET_FK_IGS_CA_INST;
619:
620: PROCEDURE GET_FK_IGS_FI_ENCMB_TYPE (
621: x_encumbrance_type IN VARCHAR2
622: ) AS
623:
624: CURSOR cur_rowid IS

Line 644: END GET_FK_IGS_FI_ENCMB_TYPE;

640: RETURN;
641: END IF;
642: Close cur_rowid;
643:
644: END GET_FK_IGS_FI_ENCMB_TYPE;
645:
646: PROCEDURE GET_FK_IGS_PE_PERSON (
647: x_person_id IN NUMBER
648: ) AS

Line 828: CURSOR system_type_cur(cp_encumbrance_type igs_fi_encmb_type.encumbrance_type%TYPE) IS

824: WHERE person_id = x_person_id
825: AND encumbrance_type = x_encumbrance_type
826: AND start_dt = cp_start_dt;
827:
828: CURSOR system_type_cur(cp_encumbrance_type igs_fi_encmb_type.encumbrance_type%TYPE) IS
829: SELECT s_encumbrance_cat
830: FROM igs_fi_encmb_type
831: WHERE encumbrance_type = cp_encumbrance_type;
832: system_type_rec system_type_cur%ROWTYPE;

Line 830: FROM igs_fi_encmb_type

826: AND start_dt = cp_start_dt;
827:
828: CURSOR system_type_cur(cp_encumbrance_type igs_fi_encmb_type.encumbrance_type%TYPE) IS
829: SELECT s_encumbrance_cat
830: FROM igs_fi_encmb_type
831: WHERE encumbrance_type = cp_encumbrance_type;
832: system_type_rec system_type_cur%ROWTYPE;
833:
834: X_LAST_UPDATE_DATE DATE;

Line 1031: CURSOR system_type_cur(cp_encumbrance_type igs_fi_encmb_type.encumbrance_type%TYPE) IS

1027: ) AS
1028: X_LAST_UPDATE_DATE DATE;
1029: X_LAST_UPDATED_BY NUMBER;
1030: X_LAST_UPDATE_LOGIN NUMBER;
1031: CURSOR system_type_cur(cp_encumbrance_type igs_fi_encmb_type.encumbrance_type%TYPE) IS
1032: SELECT s_encumbrance_cat
1033: FROM igs_fi_encmb_type
1034: WHERE encumbrance_type = cp_encumbrance_type;
1035: system_type_rec system_type_cur%ROWTYPE;

Line 1033: FROM igs_fi_encmb_type

1029: X_LAST_UPDATED_BY NUMBER;
1030: X_LAST_UPDATE_LOGIN NUMBER;
1031: CURSOR system_type_cur(cp_encumbrance_type igs_fi_encmb_type.encumbrance_type%TYPE) IS
1032: SELECT s_encumbrance_cat
1033: FROM igs_fi_encmb_type
1034: WHERE encumbrance_type = cp_encumbrance_type;
1035: system_type_rec system_type_cur%ROWTYPE;
1036:
1037: BEGIN

Line 1149: CURSOR system_type_cur(cp_encumbrance_type igs_fi_encmb_type.encumbrance_type%TYPE) IS

1145: WHERE person_id = x_person_id
1146: AND encumbrance_type = x_encumbrance_type
1147: AND start_dt = cp_start_dt ;
1148:
1149: CURSOR system_type_cur(cp_encumbrance_type igs_fi_encmb_type.encumbrance_type%TYPE) IS
1150: SELECT s_encumbrance_cat
1151: FROM igs_fi_encmb_type
1152: WHERE encumbrance_type = cp_encumbrance_type;
1153: system_type_rec system_type_cur%ROWTYPE;

Line 1151: FROM igs_fi_encmb_type

1147: AND start_dt = cp_start_dt ;
1148:
1149: CURSOR system_type_cur(cp_encumbrance_type igs_fi_encmb_type.encumbrance_type%TYPE) IS
1150: SELECT s_encumbrance_cat
1151: FROM igs_fi_encmb_type
1152: WHERE encumbrance_type = cp_encumbrance_type;
1153: system_type_rec system_type_cur%ROWTYPE;
1154: l_start_dt igs_pe_pers_encumb.start_dt%TYPE;
1155: BEGIN