APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_AS_US_AI_GROUP

Line 1987: FROM igs_as_us_ai_group

1983: -- Check for Update
1984: FUNCTION check_insert_update ( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) RETURN VARCHAR2 IS
1985: CURSOR c_us_ai_group(cp_group_name VARCHAR2 ,cp_n_uoo_id NUMBER) IS
1986: SELECT 'X'
1987: FROM igs_as_us_ai_group
1988: WHERE group_name = cp_group_name
1989: AND uoo_id = cp_n_uoo_id;
1990:
1991: c_us_ai_group_rec c_us_ai_group%ROWTYPE;

Line 2064: FROM igs_as_us_ai_group

2060: PROCEDURE Assign_default( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,p_insert_update VARCHAR2 ) AS
2061:
2062: CURSOR c_us_ai_group(cp_group_name VARCHAR2 ,cp_n_uoo_id NUMBER) IS
2063: SELECT *
2064: FROM igs_as_us_ai_group
2065: WHERE group_name = cp_group_name
2066: AND uoo_id = cp_n_uoo_id;
2067:
2068: c_us_ai_group_rec c_us_ai_group%ROWTYPE;

Line 2122: IF igs_as_us_ai_group_pkg.get_uk_for_validation (x_uoo_id => l_n_uoo_id,

2118: PROCEDURE validate_db_cons ( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,p_insert_update VARCHAR2 ) AS
2119: BEGIN
2120: IF (p_insert_update = 'I') THEN
2121: /* Unique Key Validation */
2122: IF igs_as_us_ai_group_pkg.get_uk_for_validation (x_uoo_id => l_n_uoo_id,
2123: x_group_name => p_as_us_ai_group_rec.group_name) THEN
2124: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'USEC_ASSMNT', 'LEGACY_TOKENS', FALSE);
2125: p_as_us_ai_group_rec.status := 'W';
2126: RETURN;

Line 2314: INSERT INTO igs_as_us_ai_group

2310:
2311: IF p_as_us_ai_group_rec.status = 'S' THEN
2312: IF l_insert_update = 'I' THEN
2313: /* Insert Record */
2314: INSERT INTO igs_as_us_ai_group
2315: (us_ass_item_group_id,
2316: uoo_id,
2317: group_name,
2318: midterm_formula_code,

Line 2331: (igs_as_us_ai_group_s.NEXTVAL,

2327: last_update_date,
2328: last_update_login
2329: )
2330: VALUES
2331: (igs_as_us_ai_group_s.NEXTVAL,
2332: l_n_uoo_id,
2333: p_as_us_ai_group_rec.group_name,
2334: p_as_us_ai_group_rec.midterm_formula_code,
2335: p_as_us_ai_group_rec.midterm_formula_qty,

Line 2355: UPDATE igs_as_us_ai_group

2351: p_as_us_ai_group_rec.unit_class||'Group name:'||p_as_us_ai_group_rec.group_name);
2352: END IF;
2353:
2354: ELSE --update
2355: UPDATE igs_as_us_ai_group
2356: SET midterm_formula_code=p_as_us_ai_group_rec.midterm_formula_code,
2357: midterm_formula_qty=p_as_us_ai_group_rec.midterm_formula_qty,
2358: midterm_weight_qty=p_as_us_ai_group_rec.midterm_weight_qty,
2359: final_formula_code=p_as_us_ai_group_rec.final_formula_code,

Line 2450: FROM igs_as_us_ai_group

2446: l_c_message VARCHAR2(30);
2447:
2448: CURSOR c_uaig_id(cp_uoo_id NUMBER,cp_group_name VARCHAR2) IS
2449: SELECT us_ass_item_group_id
2450: FROM igs_as_us_ai_group
2451: WHERE uoo_id = cp_uoo_id
2452: AND group_name = cp_group_name;
2453:
2454: BEGIN

Line 2764: IF NOT igs_as_us_ai_group_pkg.get_pk_for_validation ( l_n_us_ass_item_group_id ) THEN

2760: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
2761: p_unitass_item_rec.status := 'E';
2762: END IF;
2763:
2764: IF NOT igs_as_us_ai_group_pkg.get_pk_for_validation ( l_n_us_ass_item_group_id ) THEN
2765: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'USEC_ASSMNT', 'LEGACY_TOKENS', FALSE);
2766: p_unitass_item_rec.status := 'E';
2767: END IF;
2768: