DBA Data[Home] [Help]

APPS.IGS_EN_PLAN_UTILS dependencies on IGS_EN_CPD_EXT

Line 657: l_deny_warn igs_en_cpd_ext.notification_flag%TYPE;

653: FROM igs_ca_teach_to_load_v
654: WHERE teach_cal_type = cp_cal_type
655: AND teach_ci_sequence_number = cp_seq_num
656: AND rownum < 3;
657: l_deny_warn igs_en_cpd_ext.notification_flag%TYPE;
658: l_counter NUMBER;
659: l_ret_all_uoo_ids VARCHAR2(100);
660: l_ret_sub_uoo_ids VARCHAR2(100);
661: l_ret_nonsub_uoo_ids VARCHAR2(100);

Line 1464: l_denywarn igs_en_cpd_ext.notification_flag%TYPE;

1460: l_sup_us BOOLEAN; -- indicates whether the unit section is superior or not
1461: l_sub_found BOOLEAN; -- indicates whether the superior unit section has subordinate or not.
1462: l_sub_units VARCHAR2(500); -- Stores the list of subordinate unit section getting dropped.
1463: l_msg VARCHAR2(30);
1464: l_denywarn igs_en_cpd_ext.notification_flag%TYPE;
1465:
1466:
1467: -- Procedure to call the delete row for SUA
1468: PROCEDURE sua_delete (p_person_id IN NUMBER,