DBA Data[Home] [Help]

APPS.IGS_PS_VAL_TRO dependencies on IGS_PS_TCH_RESP_OVRD

Line 15: -- This module validates the IGS_PS_TCH_RESP_OVRD table such that

11: p_unit_class IN VARCHAR2 ,
12: p_message_name OUT NOCOPY VARCHAR2 )
13: RETURN BOOLEAN AS
14: BEGIN -- crsp_val_tro_perc
15: -- This module validates the IGS_PS_TCH_RESP_OVRD table such that
16: -- the sum of percentages for a IGS_PS_UNIT offering option total 100%.
17: DECLARE
18: v_sum_percentages IGS_PS_TCH_RESP_OVRD.percentage%TYPE;
19: CURSOR c_tro IS

Line 18: v_sum_percentages IGS_PS_TCH_RESP_OVRD.percentage%TYPE;

14: BEGIN -- crsp_val_tro_perc
15: -- This module validates the IGS_PS_TCH_RESP_OVRD table such that
16: -- the sum of percentages for a IGS_PS_UNIT offering option total 100%.
17: DECLARE
18: v_sum_percentages IGS_PS_TCH_RESP_OVRD.percentage%TYPE;
19: CURSOR c_tro IS
20: SELECT SUM(tro.percentage)
21: FROM IGS_PS_TCH_RESP_OVRD tro
22: WHERE tro.unit_cd = p_unit_cd AND

Line 21: FROM IGS_PS_TCH_RESP_OVRD tro

17: DECLARE
18: v_sum_percentages IGS_PS_TCH_RESP_OVRD.percentage%TYPE;
19: CURSOR c_tro IS
20: SELECT SUM(tro.percentage)
21: FROM IGS_PS_TCH_RESP_OVRD tro
22: WHERE tro.unit_cd = p_unit_cd AND
23: tro.version_number = p_version_number AND
24: tro.cal_type = p_cal_type AND
25: tro.ci_sequence_number = p_ci_sequence_number AND