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_VAL_UV dependencies on IGS_PS_USEC_CPS

Line 1225: p_enrolled_cp OUT NOCOPY IGS_PS_USEC_CPS.enrolled_credit_points%TYPE,

1221:
1222:
1223: PROCEDURE get_cp_values(
1224: p_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE,
1225: p_enrolled_cp OUT NOCOPY IGS_PS_USEC_CPS.enrolled_credit_points%TYPE,
1226: p_billable_cp OUT NOCOPY IGS_PS_USEC_CPS.billing_hrs%TYPE,
1227: p_audit_cp OUT NOCOPY IGS_PS_USEC_CPS.billing_credit_points%TYPE) AS
1228: /***********************************************************************************************
1229: Created By : bdeviset

Line 1226: p_billable_cp OUT NOCOPY IGS_PS_USEC_CPS.billing_hrs%TYPE,

1222:
1223: PROCEDURE get_cp_values(
1224: p_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE,
1225: p_enrolled_cp OUT NOCOPY IGS_PS_USEC_CPS.enrolled_credit_points%TYPE,
1226: p_billable_cp OUT NOCOPY IGS_PS_USEC_CPS.billing_hrs%TYPE,
1227: p_audit_cp OUT NOCOPY IGS_PS_USEC_CPS.billing_credit_points%TYPE) AS
1228: /***********************************************************************************************
1229: Created By : bdeviset
1230: Date Created : 21-JUL-2004

Line 1227: p_audit_cp OUT NOCOPY IGS_PS_USEC_CPS.billing_credit_points%TYPE) AS

1223: PROCEDURE get_cp_values(
1224: p_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE,
1225: p_enrolled_cp OUT NOCOPY IGS_PS_USEC_CPS.enrolled_credit_points%TYPE,
1226: p_billable_cp OUT NOCOPY IGS_PS_USEC_CPS.billing_hrs%TYPE,
1227: p_audit_cp OUT NOCOPY IGS_PS_USEC_CPS.billing_credit_points%TYPE) AS
1228: /***********************************************************************************************
1229: Created By : bdeviset
1230: Date Created : 21-JUL-2004
1231: Purpose : gets Enrolled, Audit and Billable credit point values for the passed unit section.

Line 1240: l_uoo_enrolled_cp IGS_PS_USEC_CPS.enrolled_credit_points%TYPE;

1236:
1237: l_uv_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1238: l_uv_billing_cp IGS_PS_UNIT_VER.billing_hrs%TYPE;
1239: l_uv_audit_cp IGS_PS_UNIT_VER.billing_credit_points%TYPE;
1240: l_uoo_enrolled_cp IGS_PS_USEC_CPS.enrolled_credit_points%TYPE;
1241: l_uoo_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
1242: l_uoo_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
1243:
1244: -- fetches Enrolled, Audit and Billable credit point values from unit version table for given uoo_id

Line 1241: l_uoo_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;

1237: l_uv_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1238: l_uv_billing_cp IGS_PS_UNIT_VER.billing_hrs%TYPE;
1239: l_uv_audit_cp IGS_PS_UNIT_VER.billing_credit_points%TYPE;
1240: l_uoo_enrolled_cp IGS_PS_USEC_CPS.enrolled_credit_points%TYPE;
1241: l_uoo_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
1242: l_uoo_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
1243:
1244: -- fetches Enrolled, Audit and Billable credit point values from unit version table for given uoo_id
1245: CURSOR c_uv(cp_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE) IS

Line 1242: l_uoo_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;

1238: l_uv_billing_cp IGS_PS_UNIT_VER.billing_hrs%TYPE;
1239: l_uv_audit_cp IGS_PS_UNIT_VER.billing_credit_points%TYPE;
1240: l_uoo_enrolled_cp IGS_PS_USEC_CPS.enrolled_credit_points%TYPE;
1241: l_uoo_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
1242: l_uoo_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
1243:
1244: -- fetches Enrolled, Audit and Billable credit point values from unit version table for given uoo_id
1245: CURSOR c_uv(cp_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE) IS
1246: SELECT

Line 1265: IGS_PS_USEC_CPS us

1261: us.enrolled_credit_points,
1262: us.billing_hrs,
1263: us.billing_credit_points
1264: FROM
1265: IGS_PS_USEC_CPS us
1266: WHERE
1267: us.uoo_id = cp_uoo_id;
1268:
1269: BEGIN