eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_USO_FACILITY

Line 954: IF igs_ps_uso_facility_pkg.get_uk_for_validation (

950: PROCEDURE validate_db_cons ( p_uso_fclt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_rec_type ) AS
951: BEGIN
952:
953: /* Validate UK Constraints */
954: IF igs_ps_uso_facility_pkg.get_uk_for_validation (
955: x_unit_section_occurrence_id => l_n_uso_id,
956: x_facility_code => p_uso_fclt_rec.facility_code
957: ) THEN
958: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'FACILITY', 'LEGACY_TOKENS', FALSE);

Line 1062: INSERT INTO igs_ps_uso_facility

1058: END IF;
1059:
1060: IF p_usec_occurs_facility_tbl(I).status = 'S' THEN
1061: /* Insert record */
1062: INSERT INTO igs_ps_uso_facility
1063: (uso_facility_id,
1064: unit_section_occurrence_id,
1065: facility_code,
1066: created_by,

Line 1073: (IGS_PS_USO_FACILITY_S.nextval,

1069: last_update_date,
1070: last_update_login
1071: )
1072: VALUES
1073: (IGS_PS_USO_FACILITY_S.nextval,
1074: l_n_uso_id,
1075: p_usec_occurs_facility_tbl(I).facility_code,
1076: g_n_user_id,
1077: SYSDATE,