APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_TCH_RESP_OVRD_ALL

Line 1417: FROM igs_ps_tch_resp_ovrd_all

1413: p_org_unit_cd VARCHAR2,
1414: p_ou_start_dt DATE
1415: ) IS
1416: SELECT *
1417: FROM igs_ps_tch_resp_ovrd_all
1418: WHERE unit_cd = p_unit_cd
1419: AND version_number= p_version_number
1420: AND cal_type=p_cal_type
1421: AND ci_sequence_number=p_ci_sequence_number

Line 1494: FROM igs_ps_tch_resp_ovrd_all

1490: p_org_unit_cd VARCHAR2,
1491: p_ou_start_dt DATE
1492: ) IS
1493: SELECT 'X'
1494: FROM igs_ps_tch_resp_ovrd_all
1495: WHERE unit_cd = p_unit_cd
1496: AND version_number= p_version_number
1497: AND cal_type=p_cal_type
1498: AND ci_sequence_number=p_ci_sequence_number

Line 1750: INSERT INTO igs_ps_tch_resp_ovrd_all

1746: IF p_usec_teach_resp_ovrd_tbl(I).status = 'S' THEN
1747: IF l_insert_update = 'I' THEN
1748: /* Insert Record */
1749:
1750: INSERT INTO igs_ps_tch_resp_ovrd_all
1751: (unit_cd,
1752: version_number,
1753: cal_type,
1754: ci_sequence_number,

Line 1809: UPDATE igs_ps_tch_resp_ovrd_all

1805: p_usec_teach_resp_ovrd_tbl(I).ou_start_dt);
1806: FETCH c_tch_rsp_ovrd INTO c_tch_rsp_ovrd_rec;
1807: CLOSE c_tch_rsp_ovrd;
1808:
1809: UPDATE igs_ps_tch_resp_ovrd_all
1810: SET percentage = p_usec_teach_resp_ovrd_tbl(I).percentage,
1811: last_updated_by = g_n_user_id,
1812: last_update_date = SYSDATE,
1813: last_update_login = g_n_login_id