APPS.IGS_PE_PERS_DISABLTY_PKG dependencies on IGS_AD_DISBL_TYPE

Line 311: ELSIF NOT Igs_Ad_Disbl_Type_Pkg.Get_PK_For_Validation (

307:
308: IF (((old_references.disability_type = new_references.disability_type)) OR
309: ((new_references.disability_type IS NULL))) THEN
310: NULL;
311: ELSIF NOT Igs_Ad_Disbl_Type_Pkg.Get_PK_For_Validation (
312: new_references.disability_type ,
313: 'N'
314: ) THEN
315: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');

Line 461: PROCEDURE Get_FK_Igs_Ad_Disbl_Type (

457: Close cur_rowid;
458:
459: END Get_FK_Igs_Pe_Person;
460:
461: PROCEDURE Get_FK_Igs_Ad_Disbl_Type (
462: x_disability_type IN VARCHAR2
463: ) AS
464:
465: /*************************************************************

Line 496: END Get_FK_Igs_Ad_Disbl_Type;

492: Return;
493: END IF;
494: Close cur_rowid;
495:
496: END Get_FK_Igs_Ad_Disbl_Type;
497:
498: PROCEDURE beforerowinsertupdate(p_inserting BOOLEAN,p_updating BOOLEAN) AS
499: /*
500: || Created By : pkpatel

Line 514: l_govt_disability_type igs_ad_disbl_type.govt_disability_type%TYPE;

510: */
511: l_default_end_date DATE := TO_DATE('4712/12/31','YYYY/MM/DD');
512: l_default_start_date DATE := TO_DATE('1000/01/01','YYYY/MM/DD');
513: l_count NUMBER ;
514: l_govt_disability_type igs_ad_disbl_type.govt_disability_type%TYPE;
515:
516: CURSOR govt_disability_type_cur(cp_disability_type igs_ad_disbl_type.disability_type%TYPE) IS
517: SELECT govt_disability_type
518: FROM igs_ad_disbl_type

Line 516: CURSOR govt_disability_type_cur(cp_disability_type igs_ad_disbl_type.disability_type%TYPE) IS

512: l_default_start_date DATE := TO_DATE('1000/01/01','YYYY/MM/DD');
513: l_count NUMBER ;
514: l_govt_disability_type igs_ad_disbl_type.govt_disability_type%TYPE;
515:
516: CURSOR govt_disability_type_cur(cp_disability_type igs_ad_disbl_type.disability_type%TYPE) IS
517: SELECT govt_disability_type
518: FROM igs_ad_disbl_type
519: WHERE disability_type = cp_disability_type;
520:

Line 518: FROM igs_ad_disbl_type

514: l_govt_disability_type igs_ad_disbl_type.govt_disability_type%TYPE;
515:
516: CURSOR govt_disability_type_cur(cp_disability_type igs_ad_disbl_type.disability_type%TYPE) IS
517: SELECT govt_disability_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,

Line 524: cp_govt_disability_type igs_ad_disbl_type.govt_disability_type%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
527: FROM igs_pe_pers_disablty pdi,
528: igs_ad_disbl_type dit

Line 528: igs_ad_disbl_type dit

524: cp_govt_disability_type igs_ad_disbl_type.govt_disability_type%TYPE)
525: IS
526: SELECT 1
527: FROM igs_pe_pers_disablty pdi,
528: igs_ad_disbl_type dit
529: WHERE person_id = cp_person_id
530: AND dit.disability_type = pdi.disability_type
531: AND dit.govt_disability_type = cp_govt_disability_type
532: AND (

Line 543: cp_govt_disability_type igs_ad_disbl_type.govt_disability_type%TYPE)

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
546: FROM igs_pe_pers_disablty pdi,
547: igs_ad_disbl_type dit

Line 547: igs_ad_disbl_type dit

543: cp_govt_disability_type igs_ad_disbl_type.govt_disability_type%TYPE)
544: IS
545: SELECT 1
546: FROM igs_pe_pers_disablty pdi,
547: igs_ad_disbl_type dit
548: WHERE person_id = cp_person_id
549: AND dit.disability_type = pdi.disability_type
550: AND dit.govt_disability_type <> cp_govt_disability_type
551: AND (