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_USEC_CATEGORY

Line 1227: IF igs_ps_usec_category_pkg.get_uk_for_validation (

1223: PROCEDURE validate_db_cons ( p_usec_cat_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cat_rec_type ) AS
1224: BEGIN
1225:
1226: /* Validate UK Constraints */
1227: IF igs_ps_usec_category_pkg.get_uk_for_validation (
1228: x_uoo_id => l_n_uoo_id,
1229: x_unit_cat => p_usec_cat_rec.unit_cat
1230: ) THEN
1231: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'CATEGORY', 'LEGACY_TOKENS', FALSE);

Line 1329: INSERT INTO igs_ps_usec_category

1325: END IF;
1326:
1327: IF p_usec_cat_tbl(I).status = 'S' THEN
1328: /* Insert record */
1329: INSERT INTO igs_ps_usec_category
1330: (usec_cat_id,
1331: uoo_id,
1332: unit_cat,
1333: created_by,

Line 1340: (igs_ps_usec_category_s.nextval,

1336: last_update_date,
1337: last_update_login
1338: )
1339: VALUES
1340: (igs_ps_usec_category_s.nextval,
1341: l_n_uoo_id,
1342: p_usec_cat_tbl(I).unit_cat,
1343: g_n_user_id,
1344: SYSDATE,