APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_US_REQ_REF_CD

Line 7694: IF igs_ps_us_req_ref_cd_pkg.get_uk_for_validation(l_n_usec_ref_id,p_ref_cd_rec.reference_cd_type,p_ref_cd_rec.reference_cd) THEN

7690: p_ref_cd_rec.status := 'W';
7691: RETURN;
7692: END IF;
7693: ELSE -- else Unit Section requirement reference code
7694: IF igs_ps_us_req_ref_cd_pkg.get_uk_for_validation(l_n_usec_ref_id,p_ref_cd_rec.reference_cd_type,p_ref_cd_rec.reference_cd) THEN
7695: fnd_message.set_name('IGS','IGS_PS_LGCY_USEC_REQ_REF');
7696: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS',fnd_message.get,NULL, FALSE);
7697: p_ref_cd_rec.status := 'W';
7698: RETURN;

Line 7801: --For IGS_PS_US_REQ_REF_CD record

7797: AND ur.reference_code = p_ref_cd_rec.reference_cd
7798: AND ur.reference_code_type=rc.reference_cd_type;
7799:
7800:
7801: --For IGS_PS_US_REQ_REF_CD record
7802: CURSOR c_req IS
7803: SELECT rc.restricted_flag,urr.reference_code_desc
7804: FROM igs_ps_us_req_ref_cd urr,igs_ge_ref_cd_type_all rc
7805: WHERE urr.unit_section_reference_id = l_n_usec_ref_id

Line 7804: FROM igs_ps_us_req_ref_cd urr,igs_ge_ref_cd_type_all rc

7800:
7801: --For IGS_PS_US_REQ_REF_CD record
7802: CURSOR c_req IS
7803: SELECT rc.restricted_flag,urr.reference_code_desc
7804: FROM igs_ps_us_req_ref_cd urr,igs_ge_ref_cd_type_all rc
7805: WHERE urr.unit_section_reference_id = l_n_usec_ref_id
7806: AND urr.reference_cd_type = p_ref_cd_rec.reference_cd_type
7807: AND urr.reference_code = p_ref_cd_rec.reference_cd
7808: AND urr.reference_cd_type=rc.reference_cd_type;

Line 8138: INSERT INTO igs_ps_us_req_ref_cd (

8134: END IF;
8135: ELSE -- else unit section requirements reference code
8136: IF l_insert_update = 'I' THEN
8137:
8138: INSERT INTO igs_ps_us_req_ref_cd (
8139: unit_section_req_ref_cd_id,
8140: unit_section_reference_id,
8141: reference_cd_type,
8142: creation_date,

Line 8150: igs_ps_us_req_ref_cd_s.NEXTVAL,

8146: last_update_login,
8147: reference_code,
8148: reference_code_desc
8149: ) VALUES (
8150: igs_ps_us_req_ref_cd_s.NEXTVAL,
8151: l_n_usec_ref_id,
8152: p_tab_ref_cd(i).reference_cd_type,
8153: SYSDATE,
8154: g_n_user_id,

Line 8162: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_us_req_ref_cd',

8158: p_tab_ref_cd(i).reference_cd,
8159: p_tab_ref_cd(i).description
8160: );
8161: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8162: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_us_req_ref_cd',
8163: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8164: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
8165: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||
8166: 'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||'reference_cd:'||p_tab_ref_cd(i).reference_cd||

Line 8171: UPDATE igs_ps_us_req_ref_cd SET reference_code_desc=p_tab_ref_cd(i).description,last_updated_by=g_n_user_id,

8167: ' '||'gen_ref_flag:'||p_tab_ref_cd(i).gen_ref_flag);
8168: END IF;
8169: ELSE
8170:
8171: UPDATE igs_ps_us_req_ref_cd SET reference_code_desc=p_tab_ref_cd(i).description,last_updated_by=g_n_user_id,
8172: last_update_date=SYSDATE WHERE unit_section_reference_id=l_n_usec_ref_id AND
8173: reference_cd_type=p_tab_ref_cd(i).reference_cd_type AND reference_code=p_tab_ref_cd(i).reference_cd;
8174:
8175: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 8176: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_updated_igs_ps_us_req_ref_cd',

8172: last_update_date=SYSDATE WHERE unit_section_reference_id=l_n_usec_ref_id AND
8173: reference_cd_type=p_tab_ref_cd(i).reference_cd_type AND reference_code=p_tab_ref_cd(i).reference_cd;
8174:
8175: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8176: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_updated_igs_ps_us_req_ref_cd',
8177: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8178: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
8179: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||
8180: 'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||'reference_cd:'||p_tab_ref_cd(i).reference_cd||