APPS.IGS_EN_VAL_DR dependencies on IGS_EN_DCNT_REASONCD

Line 12: -- This module validates that the IGS_EN_DCNT_REASONCD.sys_dflt_ind can

8: p_message_name OUT NOCOPY VARCHAR2)
9: RETURN BOOLEAN AS
10:
11: BEGIN -- enrp_val_dr_sysdflt
12: -- This module validates that the IGS_EN_DCNT_REASONCD.sys_dflt_ind can
13: -- only be set to
14: -- 'Y' when IGS_EN_DCNT_REASONCD.s_discontinuation_reason_type is not set.
15: DECLARE
16: BEGIN

Line 14: -- 'Y' when IGS_EN_DCNT_REASONCD.s_discontinuation_reason_type is not set.

10:
11: BEGIN -- enrp_val_dr_sysdflt
12: -- This module validates that the IGS_EN_DCNT_REASONCD.sys_dflt_ind can
13: -- only be set to
14: -- 'Y' when IGS_EN_DCNT_REASONCD.s_discontinuation_reason_type is not set.
15: DECLARE
16: BEGIN
17: -- Set the default message number
18: p_message_name := null;

Line 88: -- for at least one IGS_EN_DCNT_REASONCD mapped to a

84: RETURN BOOLEAN AS
85:
86: BEGIN -- enrp_val_dr_sysdflt2
87: -- This module validates that the system default indicator has to be set
88: -- for at least one IGS_EN_DCNT_REASONCD mapped to a
89: -- s_discontinuation_reason_type. This routine will be called when all
90: -- records are posted to the database.
91: DECLARE
92: v_dr_count NUMBER;

Line 95: FROM IGS_EN_DCNT_REASONCD dr

91: DECLARE
92: v_dr_count NUMBER;
93: CURSOR c_dr IS
94: SELECT COUNT(*)
95: FROM IGS_EN_DCNT_REASONCD dr
96: WHERE dr.s_discontinuation_reason_type = p_s_discontin_reason_type AND
97: dr.closed_ind = 'N' AND
98: dr.sys_dflt_ind = 'Y';
99: BEGIN

Line 135: -- for more than one IGS_EN_DCNT_REASONCD maped to a

131: RETURN BOOLEAN AS
132:
133: BEGIN -- enrp_val_dr_sysdflt1
134: -- This module validates that the system default indicator is not set
135: -- for more than one IGS_EN_DCNT_REASONCD maped to a
136: -- s_discontinuation_reason_type. This routine will be called when all
137: -- records are posted to the database.
138: DECLARE
139: v_dr_count NUMBER;

Line 142: FROM IGS_EN_DCNT_REASONCD dr

138: DECLARE
139: v_dr_count NUMBER;
140: CURSOR c_dr IS
141: SELECT COUNT(*)
142: FROM IGS_EN_DCNT_REASONCD dr
143: WHERE dr.s_discontinuation_reason_type = p_s_discontin_reason_type AND
144: dr.closed_ind = 'N' AND
145: dr.sys_dflt_ind = 'Y';
146: BEGIN

Line 187: FROM igs_en_dcnt_reasoncd_v

183: -- This function has been changed to fix Bug# 2053999
184: --
185: CURSOR cur_c1 IS
186: SELECT count(*) cnt
187: FROM igs_en_dcnt_reasoncd_v
188: WHERE dcnt_unit_ind = 'Y'
189: AND dflt_ind = 'Y'
190: AND closed_ind = 'N';
191: --modified cursor for perf bug 3712579

Line 194: FROM igs_en_dcnt_reasoncd

190: AND closed_ind = 'N';
191: --modified cursor for perf bug 3712579
192: CURSOR cur_c2 IS
193: SELECT count(*) cnt
194: FROM igs_en_dcnt_reasoncd
195: WHERE dcnt_program_ind = 'Y'
196: AND dflt_ind = 'Y'
197: AND closed_ind = 'N';
198: