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_GEN_008 dependencies on IGS_AS_UNIT_AI_GRP

Line 1556: CURSOR cur_unit_ass_group(cp_unit_cd igs_as_unit_ai_grp.unit_cd%TYPE,

1552: AS
1553: v_assessment_unit_rec IGS_AS_UNITASS_ITEM%ROWTYPE;
1554: v_new_sequence_number IGS_AS_UNITASS_ITEM.sequence_number%TYPE;
1555:
1556: CURSOR cur_unit_ass_group(cp_unit_cd igs_as_unit_ai_grp.unit_cd%TYPE,
1557: cp_version_number igs_as_unit_ai_grp.version_number%TYPE,
1558: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,
1559: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE) IS
1560: SELECT *

Line 1557: cp_version_number igs_as_unit_ai_grp.version_number%TYPE,

1553: v_assessment_unit_rec IGS_AS_UNITASS_ITEM%ROWTYPE;
1554: v_new_sequence_number IGS_AS_UNITASS_ITEM.sequence_number%TYPE;
1555:
1556: CURSOR cur_unit_ass_group(cp_unit_cd igs_as_unit_ai_grp.unit_cd%TYPE,
1557: cp_version_number igs_as_unit_ai_grp.version_number%TYPE,
1558: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,
1559: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE) IS
1560: SELECT *
1561: FROM igs_as_unit_ai_grp

Line 1558: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,

1554: v_new_sequence_number IGS_AS_UNITASS_ITEM.sequence_number%TYPE;
1555:
1556: CURSOR cur_unit_ass_group(cp_unit_cd igs_as_unit_ai_grp.unit_cd%TYPE,
1557: cp_version_number igs_as_unit_ai_grp.version_number%TYPE,
1558: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,
1559: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE) IS
1560: SELECT *
1561: FROM igs_as_unit_ai_grp
1562: WHERE unit_cd=cp_unit_cd

Line 1559: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE) IS

1555:
1556: CURSOR cur_unit_ass_group(cp_unit_cd igs_as_unit_ai_grp.unit_cd%TYPE,
1557: cp_version_number igs_as_unit_ai_grp.version_number%TYPE,
1558: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,
1559: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE) IS
1560: SELECT *
1561: FROM igs_as_unit_ai_grp
1562: WHERE unit_cd=cp_unit_cd
1563: AND version_number=cp_version_number

Line 1561: FROM igs_as_unit_ai_grp

1557: cp_version_number igs_as_unit_ai_grp.version_number%TYPE,
1558: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,
1559: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE) IS
1560: SELECT *
1561: FROM igs_as_unit_ai_grp
1562: WHERE unit_cd=cp_unit_cd
1563: AND version_number=cp_version_number
1564: AND cal_type = cp_cal_type
1565: AND ci_sequence_number=cp_ci_sequence_number;

Line 1598: igs_as_unit_ai_grp_pkg.insert_row(

1594: BEGIN
1595: l_rowid :=NULL;
1596: l_unit_ass_item_group_id := NULL;
1597:
1598: igs_as_unit_ai_grp_pkg.insert_row(
1599: x_rowid => l_rowid,
1600: x_unit_ass_item_group_id => l_unit_ass_item_group_id,
1601: x_unit_cd => p_new_unit_cd,
1602: x_version_number => p_new_version_number,

Line 2544: CURSOR cur_unit_ass_group(cp_unit_cd igs_as_unit_ai_grp.unit_cd%TYPE,

2540: FROM igs_as_grd_schema gs
2541: WHERE gs.grading_schema_cd = cp_grad_schema_cd;
2542:
2543:
2544: CURSOR cur_unit_ass_group(cp_unit_cd igs_as_unit_ai_grp.unit_cd%TYPE,
2545: cp_version_number igs_as_unit_ai_grp.version_number%TYPE,
2546: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,
2547: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE) IS
2548: SELECT *

Line 2545: cp_version_number igs_as_unit_ai_grp.version_number%TYPE,

2541: WHERE gs.grading_schema_cd = cp_grad_schema_cd;
2542:
2543:
2544: CURSOR cur_unit_ass_group(cp_unit_cd igs_as_unit_ai_grp.unit_cd%TYPE,
2545: cp_version_number igs_as_unit_ai_grp.version_number%TYPE,
2546: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,
2547: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE) IS
2548: SELECT *
2549: FROM igs_as_unit_ai_grp

Line 2546: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,

2542:
2543:
2544: CURSOR cur_unit_ass_group(cp_unit_cd igs_as_unit_ai_grp.unit_cd%TYPE,
2545: cp_version_number igs_as_unit_ai_grp.version_number%TYPE,
2546: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,
2547: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE) IS
2548: SELECT *
2549: FROM igs_as_unit_ai_grp
2550: WHERE unit_cd=cp_unit_cd

Line 2547: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE) IS

2543:
2544: CURSOR cur_unit_ass_group(cp_unit_cd igs_as_unit_ai_grp.unit_cd%TYPE,
2545: cp_version_number igs_as_unit_ai_grp.version_number%TYPE,
2546: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,
2547: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE) IS
2548: SELECT *
2549: FROM igs_as_unit_ai_grp
2550: WHERE unit_cd=cp_unit_cd
2551: AND version_number=cp_version_number

Line 2549: FROM igs_as_unit_ai_grp

2545: cp_version_number igs_as_unit_ai_grp.version_number%TYPE,
2546: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,
2547: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE) IS
2548: SELECT *
2549: FROM igs_as_unit_ai_grp
2550: WHERE unit_cd=cp_unit_cd
2551: AND version_number=cp_version_number
2552: AND cal_type = cp_cal_type
2553: AND ci_sequence_number=cp_ci_sequence_number;

Line 3371: CURSOR cur_unitassgrp_new (cp_unit_cd igs_as_unit_ai_grp.unit_cd%TYPE,

3367: /**** Roll Over the Unit Assessment items ******/
3368: --select the unit assessment items group
3369: FOR cur_unit_ass_group_rec IN cur_unit_ass_group(p_unit_cd,p_version_number,p_source_cal_type,p_source_ci_sequence_number) LOOP
3370: DECLARE
3371: CURSOR cur_unitassgrp_new (cp_unit_cd igs_as_unit_ai_grp.unit_cd%TYPE,
3372: cp_version_number igs_as_unit_ai_grp.version_number%TYPE,
3373: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,
3374: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE,
3375: cp_group_name igs_as_unit_ai_grp.group_name%TYPE) IS

Line 3372: cp_version_number igs_as_unit_ai_grp.version_number%TYPE,

3368: --select the unit assessment items group
3369: FOR cur_unit_ass_group_rec IN cur_unit_ass_group(p_unit_cd,p_version_number,p_source_cal_type,p_source_ci_sequence_number) LOOP
3370: DECLARE
3371: CURSOR cur_unitassgrp_new (cp_unit_cd igs_as_unit_ai_grp.unit_cd%TYPE,
3372: cp_version_number igs_as_unit_ai_grp.version_number%TYPE,
3373: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,
3374: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE,
3375: cp_group_name igs_as_unit_ai_grp.group_name%TYPE) IS
3376: SELECT unit_ass_item_group_id

Line 3373: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,

3369: FOR cur_unit_ass_group_rec IN cur_unit_ass_group(p_unit_cd,p_version_number,p_source_cal_type,p_source_ci_sequence_number) LOOP
3370: DECLARE
3371: CURSOR cur_unitassgrp_new (cp_unit_cd igs_as_unit_ai_grp.unit_cd%TYPE,
3372: cp_version_number igs_as_unit_ai_grp.version_number%TYPE,
3373: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,
3374: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE,
3375: cp_group_name igs_as_unit_ai_grp.group_name%TYPE) IS
3376: SELECT unit_ass_item_group_id
3377: FROM igs_as_unit_ai_grp

Line 3374: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE,

3370: DECLARE
3371: CURSOR cur_unitassgrp_new (cp_unit_cd igs_as_unit_ai_grp.unit_cd%TYPE,
3372: cp_version_number igs_as_unit_ai_grp.version_number%TYPE,
3373: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,
3374: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE,
3375: cp_group_name igs_as_unit_ai_grp.group_name%TYPE) IS
3376: SELECT unit_ass_item_group_id
3377: FROM igs_as_unit_ai_grp
3378: WHERE unit_cd = cp_unit_cd

Line 3375: cp_group_name igs_as_unit_ai_grp.group_name%TYPE) IS

3371: CURSOR cur_unitassgrp_new (cp_unit_cd igs_as_unit_ai_grp.unit_cd%TYPE,
3372: cp_version_number igs_as_unit_ai_grp.version_number%TYPE,
3373: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,
3374: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE,
3375: cp_group_name igs_as_unit_ai_grp.group_name%TYPE) IS
3376: SELECT unit_ass_item_group_id
3377: FROM igs_as_unit_ai_grp
3378: WHERE unit_cd = cp_unit_cd
3379: AND version_number = cp_version_number

Line 3377: FROM igs_as_unit_ai_grp

3373: cp_cal_type igs_as_unit_ai_grp.cal_type%TYPE,
3374: cp_ci_sequence_number igs_as_unit_ai_grp.ci_sequence_number%TYPE,
3375: cp_group_name igs_as_unit_ai_grp.group_name%TYPE) IS
3376: SELECT unit_ass_item_group_id
3377: FROM igs_as_unit_ai_grp
3378: WHERE unit_cd = cp_unit_cd
3379: AND version_number = cp_version_number
3380: AND cal_type = cp_cal_type
3381: AND ci_sequence_number= cp_ci_sequence_number

Line 3406: igs_as_unit_ai_grp_pkg.insert_row(

3402:
3403: OPEN cur_unitassgrp_new(p_unit_cd,p_version_number,p_cal_type,p_dest_ci_sequence_number,cur_unit_ass_group_rec.group_name);
3404: FETCH cur_unitassgrp_new INTO l_unit_ass_item_group_id;
3405: IF cur_unitassgrp_new%NOTFOUND THEN
3406: igs_as_unit_ai_grp_pkg.insert_row(
3407: x_rowid => l_rowid1,
3408: x_unit_ass_item_group_id => l_unit_ass_item_group_id,
3409: x_unit_cd => p_unit_cd,
3410: x_version_number => p_version_number,