APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_UNITREQREF_CD

Line 7612: IF igs_ps_unitreqref_cd_pkg.get_uk_for_validation(p_ref_cd_rec.unit_cd,

7608: p_ref_cd_rec.status := 'W';
7609: RETURN;
7610: END IF;
7611: ELSE -- else Unit requirement reference code
7612: IF igs_ps_unitreqref_cd_pkg.get_uk_for_validation(p_ref_cd_rec.unit_cd,
7613: p_ref_cd_rec.version_number,
7614: p_ref_cd_rec.reference_cd_type,
7615: p_ref_cd_rec.reference_cd
7616: ) THEN

Line 8042: INSERT INTO igs_ps_unitreqref_cd (

8038: ||p_tab_ref_cd(i).version_number||' '||'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||
8039: 'reference_cd:'||p_tab_ref_cd(i).reference_cd||' '||'gen_ref_flag:'||p_tab_ref_cd(i).gen_ref_flag);
8040: END IF;
8041: ELSE -- else unit requirements reference code
8042: INSERT INTO igs_ps_unitreqref_cd (
8043: unit_req_ref_cd_id,
8044: unit_cd,
8045: version_number,
8046: reference_cd_type,

Line 8055: igs_ps_unitreqref_cd_s.NEXTVAL,

8051: last_update_login,
8052: reference_code,
8053: reference_code_desc
8054: ) VALUES (
8055: igs_ps_unitreqref_cd_s.NEXTVAL,
8056: p_tab_ref_cd(i).unit_cd,
8057: p_tab_ref_cd(i).version_number,
8058: p_tab_ref_cd(i).reference_cd_type,
8059: SYSDATE,

Line 8068: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_unitreqref_cd',

8064: p_tab_ref_cd(i).reference_cd,
8065: p_tab_ref_cd(i).description
8066: );
8067: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8068: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_unitreqref_cd',
8069: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8070: ||p_tab_ref_cd(i).version_number||' '||'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||
8071: 'reference_cd:'||p_tab_ref_cd(i).reference_cd||' '||'gen_ref_flag:'||p_tab_ref_cd(i).gen_ref_flag);
8072: END IF;