APPS.IGS_PE_PERS_DISABLTY_PKG dependencies on IGS_PE_PERS_DISABLTY_S

Line 522: cp_start_date igs_pe_pers_disablty.start_date%TYPE,

518: FROM igs_ad_disbl_type
519: WHERE disability_type = cp_disability_type;
520:
521: CURSOR none_cur (cp_person_id igs_pe_pers_disablty.person_id%TYPE,
522: cp_start_date igs_pe_pers_disablty.start_date%TYPE,
523: cp_end_date igs_pe_pers_disablty.end_date%TYPE,
524: cp_govt_disability_type igs_ad_disbl_type.govt_disability_type%TYPE)
525: IS
526: SELECT 1

Line 541: cp_start_date igs_pe_pers_disablty.start_date%TYPE,

537: );
538:
539:
540: CURSOR not_none_cur (cp_person_id igs_pe_pers_disablty.person_id%TYPE,
541: cp_start_date igs_pe_pers_disablty.start_date%TYPE,
542: cp_end_date igs_pe_pers_disablty.end_date%TYPE,
543: cp_govt_disability_type igs_ad_disbl_type.govt_disability_type%TYPE)
544: IS
545: SELECT 1

Line 915: SELECT igs_pe_pers_disablty_s.NEXTVAL

911: IGS_GE_MSG_STACK.ADD;
912: app_exception.raise_exception;
913: end if;
914:
915: SELECT igs_pe_pers_disablty_s.NEXTVAL
916: INTO x_IGS_PE_PERS_DISABLTY_ID
917: FROM dual;
918:
919: Before_DML(

Line 1378: update IGS_PE_PERS_DISABLTY set

1374: x_last_update_login=>X_LAST_UPDATE_LOGIN);
1375: IF (x_mode = 'S') THEN
1376: igs_sc_gen_001.set_ctx('R');
1377: END IF;
1378: update IGS_PE_PERS_DISABLTY set
1379: SPECIAL_ALLOW_CD = NEW_REFERENCES.SPECIAL_ALLOW_CD,
1380: SUPPORT_LEVEL_CD = NEW_REFERENCES.SUPPORT_LEVEL_CD,
1381: ATTRIBUTE_CATEGORY = NEW_REFERENCES.ATTRIBUTE_CATEGORY,
1382: ATTRIBUTE1 = NEW_REFERENCES.ATTRIBUTE1,