APPS.IGS_PS_GEN_001 dependencies on IGS_PS_NSUS_RTN_DTL

Line 2320: CURSOR c_rtn_us_dtl(cp_non_std_usec_rtn_id igs_ps_nsus_rtn_dtl.non_std_usec_rtn_id%TYPE) IS

2316: AND a.uoo_id = b.uoo_id
2317: AND b.non_std_usec_ind = 'Y'
2318: AND a.definition_code IN ('UNIT_SECTION','UNIT_SECTION_FEE_TYPE');
2319:
2320: CURSOR c_rtn_us_dtl(cp_non_std_usec_rtn_id igs_ps_nsus_rtn_dtl.non_std_usec_rtn_id%TYPE) IS
2321: SELECT *
2322: FROM igs_ps_nsus_rtn_dtl
2323: WHERE non_std_usec_rtn_id = cp_non_std_usec_rtn_id;
2324:

Line 2322: FROM igs_ps_nsus_rtn_dtl

2318: AND a.definition_code IN ('UNIT_SECTION','UNIT_SECTION_FEE_TYPE');
2319:
2320: CURSOR c_rtn_us_dtl(cp_non_std_usec_rtn_id igs_ps_nsus_rtn_dtl.non_std_usec_rtn_id%TYPE) IS
2321: SELECT *
2322: FROM igs_ps_nsus_rtn_dtl
2323: WHERE non_std_usec_rtn_id = cp_non_std_usec_rtn_id;
2324:
2325: CURSOR usec_fac(cp_unit_section_occurrence_id igs_ps_uso_facility.unit_section_occurrence_id%TYPE) IS
2326: SELECT *

Line 4129: CURSOR c_rtn_us_dtl_new(cp_non_std_usec_rtn_id igs_ps_nsus_rtn_dtl.non_std_usec_rtn_id%TYPE,

4125: END IF;
4126:
4127: FOR c_rtn_us_dtl_rec IN c_rtn_us_dtl (c_rtn_us_rec.non_std_usec_rtn_id) LOOP
4128: DECLARE
4129: CURSOR c_rtn_us_dtl_new(cp_non_std_usec_rtn_id igs_ps_nsus_rtn_dtl.non_std_usec_rtn_id%TYPE,
4130: cp_offset_value igs_ps_nsus_rtn_dtl.offset_value%TYPE) IS
4131: SELECT 'X'
4132: FROM igs_ps_nsus_rtn_dtl
4133: WHERE non_std_usec_rtn_id = cp_non_std_usec_rtn_id

Line 4130: cp_offset_value igs_ps_nsus_rtn_dtl.offset_value%TYPE) IS

4126:
4127: FOR c_rtn_us_dtl_rec IN c_rtn_us_dtl (c_rtn_us_rec.non_std_usec_rtn_id) LOOP
4128: DECLARE
4129: CURSOR c_rtn_us_dtl_new(cp_non_std_usec_rtn_id igs_ps_nsus_rtn_dtl.non_std_usec_rtn_id%TYPE,
4130: cp_offset_value igs_ps_nsus_rtn_dtl.offset_value%TYPE) IS
4131: SELECT 'X'
4132: FROM igs_ps_nsus_rtn_dtl
4133: WHERE non_std_usec_rtn_id = cp_non_std_usec_rtn_id
4134: AND offset_value = cp_offset_value;

Line 4132: FROM igs_ps_nsus_rtn_dtl

4128: DECLARE
4129: CURSOR c_rtn_us_dtl_new(cp_non_std_usec_rtn_id igs_ps_nsus_rtn_dtl.non_std_usec_rtn_id%TYPE,
4130: cp_offset_value igs_ps_nsus_rtn_dtl.offset_value%TYPE) IS
4131: SELECT 'X'
4132: FROM igs_ps_nsus_rtn_dtl
4133: WHERE non_std_usec_rtn_id = cp_non_std_usec_rtn_id
4134: AND offset_value = cp_offset_value;
4135:
4136: l_c_var VARCHAR2(1);

Line 4138: l_non_std_usec_rtn_dtl_id igs_ps_nsus_rtn_dtl.non_std_usec_rtn_dtl_id%TYPE;

4134: AND offset_value = cp_offset_value;
4135:
4136: l_c_var VARCHAR2(1);
4137: lv_rowid VARCHAR2(25);
4138: l_non_std_usec_rtn_dtl_id igs_ps_nsus_rtn_dtl.non_std_usec_rtn_dtl_id%TYPE;
4139: l_offset_date DATE;
4140: BEGIN
4141: OPEN c_rtn_us_new(l_non_std_usec_rtn_id,c_rtn_us_dtl_rec.offset_value);
4142: FETCH c_rtn_us_new INTO l_c_var;

Line 4152: igs_ps_nsus_rtn_dtl_pkg.insert_row(

4148: p_c_round_method => c_rtn_us_rec.round_method,
4149: p_c_incl_wkend_duration => c_rtn_us_rec.incl_wkend_duration_flag,
4150: p_n_offset_value => c_rtn_us_dtl_rec.offset_value);
4151:
4152: igs_ps_nsus_rtn_dtl_pkg.insert_row(
4153: x_rowid => lv_rowid,
4154: x_non_std_usec_rtn_dtl_id => l_non_std_usec_rtn_dtl_id,
4155: x_non_std_usec_rtn_id => l_non_std_usec_rtn_id,
4156: x_offset_value => c_rtn_us_dtl_rec.offset_value,