APPS.IGS_PS_UNIT_VER_PKG dependencies on IGS_GE_REF_CD_TYPE

Line 3279: CURSOR c_igs_ge_ref_cd_type IS

3275: p_c_unit_cd igs_ps_unit_ver.unit_cd%TYPE,
3276: p_n_version_number igs_ps_unit_ver.version_number%TYPE,
3277: p_c_message_name OUT NOCOPY VARCHAR2
3278: ) AS
3279: CURSOR c_igs_ge_ref_cd_type IS
3280: SELECT reference_cd_type
3281: FROM igs_ge_ref_cd_type
3282: WHERE mandatory_flag ='Y'
3283: AND unit_flag ='Y'

Line 3281: FROM igs_ge_ref_cd_type

3277: p_c_message_name OUT NOCOPY VARCHAR2
3278: ) AS
3279: CURSOR c_igs_ge_ref_cd_type IS
3280: SELECT reference_cd_type
3281: FROM igs_ge_ref_cd_type
3282: WHERE mandatory_flag ='Y'
3283: AND unit_flag ='Y'
3284: AND restricted_flag ='Y'
3285: AND closed_ind = 'N';

Line 3297: FOR cur_igs_ge_ref_cd_type IN c_igs_ge_ref_cd_type

3293:
3294: l_c_rowid VARCHAR2(30);
3295:
3296: BEGIN
3297: FOR cur_igs_ge_ref_cd_type IN c_igs_ge_ref_cd_type
3298: LOOP
3299: FOR cur_igs_ge_ref_cd IN c_igs_ge_ref_cd(cur_igs_ge_ref_cd_type.reference_cd_type)
3300: LOOP
3301: -- insert a value in igs_ps_unit_ref_cd for every value of unit_cd and version_number having

Line 3299: FOR cur_igs_ge_ref_cd IN c_igs_ge_ref_cd(cur_igs_ge_ref_cd_type.reference_cd_type)

3295:
3296: BEGIN
3297: FOR cur_igs_ge_ref_cd_type IN c_igs_ge_ref_cd_type
3298: LOOP
3299: FOR cur_igs_ge_ref_cd IN c_igs_ge_ref_cd(cur_igs_ge_ref_cd_type.reference_cd_type)
3300: LOOP
3301: -- insert a value in igs_ps_unit_ref_cd for every value of unit_cd and version_number having
3302: -- a applicable unit defined as mandatory and a default reference code
3303: BEGIN

Line 3307: x_reference_cd_type => cur_igs_ge_ref_cd_type.reference_cd_type,

3303: BEGIN
3304: l_c_rowid:=NULL;
3305: igs_ps_unit_ref_cd_pkg.insert_row(x_rowid => l_c_rowid,
3306: x_unit_cd => p_c_unit_cd,
3307: x_reference_cd_type => cur_igs_ge_ref_cd_type.reference_cd_type,
3308: x_version_number => p_n_version_number,
3309: x_reference_cd => cur_igs_ge_ref_cd.reference_cd,
3310: x_description => cur_igs_ge_ref_cd.description,
3311: x_mode => 'R');