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_UNITASS_ITEM

Line 12: -- nalkumar 19-May-2003 Bug# 2829291; Modified the call of IGS_AS_UNITASS_ITEM_PKG.INSERT_ROW;

8: --sarakshi 09-sep-2003 Enh#3052452,removed the local function crspl_ins_sub_unit_rel and its call
9: --vvutukur 05-Aug-2003 Enh#3045069.PSP Enh Build. Modified crspl_ins_unit_off_opt,CRSP_INS_UOP_UOO.
10: --vvutukur 24-May-2003 Enh#2831572.Financial Accounting Build. Modified procedure crsp_ins_unit_ver.
11: --
12: -- nalkumar 19-May-2003 Bug# 2829291; Modified the call of IGS_AS_UNITASS_ITEM_PKG.INSERT_ROW;
13: -- Modifications are as per 'Assessment Item Description' FD;
14: --
15: -- sarakshi 18-Apr-2003 Bug#2910695,modified procedure crspl_ins_unit_off_opt and CRSP_INS_UOP_UOO
16: -- sarakshi 05-Mar-2003 Bug#2768783, modified procedure crsp_ins_uop_uoo and crspl_ins_unit_off_opt,

Line 1548: p_unit_cd IN IGS_AS_UNITASS_ITEM.unit_cd%TYPE,

1544: END IF;
1545: END crspl_ins_unit_off_opt;
1546:
1547: PROCEDURE crspl_ins_unit_assmnt_item (
1548: p_unit_cd IN IGS_AS_UNITASS_ITEM.unit_cd%TYPE,
1549: p_version_number IN IGS_AS_UNITASS_ITEM.version_number%TYPE,
1550: p_cal_type IN IGS_AS_UNITASS_ITEM.cal_type%TYPE,
1551: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM.ci_sequence_number%TYPE )
1552: AS

Line 1549: p_version_number IN IGS_AS_UNITASS_ITEM.version_number%TYPE,

1545: END crspl_ins_unit_off_opt;
1546:
1547: PROCEDURE crspl_ins_unit_assmnt_item (
1548: p_unit_cd IN IGS_AS_UNITASS_ITEM.unit_cd%TYPE,
1549: p_version_number IN IGS_AS_UNITASS_ITEM.version_number%TYPE,
1550: p_cal_type IN IGS_AS_UNITASS_ITEM.cal_type%TYPE,
1551: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM.ci_sequence_number%TYPE )
1552: AS
1553: v_assessment_unit_rec IGS_AS_UNITASS_ITEM%ROWTYPE;

Line 1550: p_cal_type IN IGS_AS_UNITASS_ITEM.cal_type%TYPE,

1546:
1547: PROCEDURE crspl_ins_unit_assmnt_item (
1548: p_unit_cd IN IGS_AS_UNITASS_ITEM.unit_cd%TYPE,
1549: p_version_number IN IGS_AS_UNITASS_ITEM.version_number%TYPE,
1550: p_cal_type IN IGS_AS_UNITASS_ITEM.cal_type%TYPE,
1551: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM.ci_sequence_number%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;

Line 1551: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM.ci_sequence_number%TYPE )

1547: PROCEDURE crspl_ins_unit_assmnt_item (
1548: p_unit_cd IN IGS_AS_UNITASS_ITEM.unit_cd%TYPE,
1549: p_version_number IN IGS_AS_UNITASS_ITEM.version_number%TYPE,
1550: p_cal_type IN IGS_AS_UNITASS_ITEM.cal_type%TYPE,
1551: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM.ci_sequence_number%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:

Line 1553: v_assessment_unit_rec IGS_AS_UNITASS_ITEM%ROWTYPE;

1549: p_version_number IN IGS_AS_UNITASS_ITEM.version_number%TYPE,
1550: p_cal_type IN IGS_AS_UNITASS_ITEM.cal_type%TYPE,
1551: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM.ci_sequence_number%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,

Line 1554: v_new_sequence_number IGS_AS_UNITASS_ITEM.sequence_number%TYPE;

1550: p_cal_type IN IGS_AS_UNITASS_ITEM.cal_type%TYPE,
1551: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM.ci_sequence_number%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,

Line 1567: CURSOR c_unit_assessment_item(cp_unit_ass_item_group_id igs_as_unitass_item.unit_ass_item_group_id%TYPE) IS

1563: AND version_number=cp_version_number
1564: AND cal_type = cp_cal_type
1565: AND ci_sequence_number=cp_ci_sequence_number;
1566:
1567: CURSOR c_unit_assessment_item(cp_unit_ass_item_group_id igs_as_unitass_item.unit_ass_item_group_id%TYPE) IS
1568: SELECT *
1569: FROM IGS_AS_UNITASS_ITEM uai
1570: WHERE uai.unit_cd = p_unit_cd AND
1571: uai.version_number = p_version_number AND

Line 1569: FROM IGS_AS_UNITASS_ITEM uai

1565: AND ci_sequence_number=cp_ci_sequence_number;
1566:
1567: CURSOR c_unit_assessment_item(cp_unit_ass_item_group_id igs_as_unitass_item.unit_ass_item_group_id%TYPE) IS
1568: SELECT *
1569: FROM IGS_AS_UNITASS_ITEM uai
1570: WHERE uai.unit_cd = p_unit_cd AND
1571: uai.version_number = p_version_number AND
1572: uai.cal_type = p_cal_type AND
1573: uai.ci_sequence_number = p_ci_sequence_number AND

Line 1583: l_unit_ass_item_id igs_as_unitass_item_all.unit_ass_item_id%TYPE;

1579: WHERE gs.grading_schema_cd = cp_grad_schema_cd;
1580:
1581: l_message_name fnd_new_messages.message_name%TYPE;
1582: v_latest_gs_ver cur_latest_gs_ver%ROWTYPE;
1583: l_unit_ass_item_id igs_as_unitass_item_all.unit_ass_item_id%TYPE;
1584:
1585: BEGIN
1586: -- Assigning initial values to local variables which were being initialised using DEFAULT
1587: -- clause.Done as part of bug #2563596 to remove GSCC warning.

Line 1632: SELECT IGS_AS_UNITASS_ITEM_SEQ_NUM_S.nextval

1628: l_message_name) = TRUE) THEN
1629: --
1630: -- End of the latest version check of Grading Schema.
1631: --
1632: SELECT IGS_AS_UNITASS_ITEM_SEQ_NUM_S.nextval
1633: INTO v_new_sequence_number
1634: FROM dual;
1635: x_rowid := NULL;
1636: l_unit_ass_item_id := NULL;

Line 1638: IGS_AS_UNITASS_ITEM_PKG.INSERT_ROW(

1634: FROM dual;
1635: x_rowid := NULL;
1636: l_unit_ass_item_id := NULL;
1637:
1638: IGS_AS_UNITASS_ITEM_PKG.INSERT_ROW(
1639: X_ROWID => x_rowid,
1640: X_UNIT_CD => p_new_unit_cd,
1641: X_VERSION_NUMBER => p_new_version_number,
1642: X_CAL_TYPE => v_unit_assessment_item_rec.cal_type,

Line 2514: v_reference igs_as_unitass_item.reference%TYPE;

2510: v_exam_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2511: v_latest_gs_version igs_as_grd_schema.version_number%TYPE;
2512: v_unit_contact igs_ps_unit_ofr_opt.unit_contact%TYPE;
2513: v_assessment_type igs_as_assessmnt_typ.assessment_type%TYPE;
2514: v_reference igs_as_unitass_item.reference%TYPE;
2515: v_uai_seq_num igs_as_unitass_item.sequence_number%TYPE;
2516: l_org_id NUMBER(15);
2517: l_unit_ass_item_id igs_as_unitass_item_all.unit_ass_item_id%TYPE;
2518:

Line 2515: v_uai_seq_num igs_as_unitass_item.sequence_number%TYPE;

2511: v_latest_gs_version igs_as_grd_schema.version_number%TYPE;
2512: v_unit_contact igs_ps_unit_ofr_opt.unit_contact%TYPE;
2513: v_assessment_type igs_as_assessmnt_typ.assessment_type%TYPE;
2514: v_reference igs_as_unitass_item.reference%TYPE;
2515: v_uai_seq_num igs_as_unitass_item.sequence_number%TYPE;
2516: l_org_id NUMBER(15);
2517: l_unit_ass_item_id igs_as_unitass_item_all.unit_ass_item_id%TYPE;
2518:
2519:

Line 2517: l_unit_ass_item_id igs_as_unitass_item_all.unit_ass_item_id%TYPE;

2513: v_assessment_type igs_as_assessmnt_typ.assessment_type%TYPE;
2514: v_reference igs_as_unitass_item.reference%TYPE;
2515: v_uai_seq_num igs_as_unitass_item.sequence_number%TYPE;
2516: l_org_id NUMBER(15);
2517: l_unit_ass_item_id igs_as_unitass_item_all.unit_ass_item_id%TYPE;
2518:
2519:
2520: CURSOR c_uop_dest_rec IS
2521: SELECT 'x'

Line 2561: cp_unit_ass_item_group_id igs_as_unitass_item.unit_ass_item_group_id%TYPE) IS

2557: cp_unit_cd igs_ps_unit_ofr_pat.unit_cd%TYPE,
2558: cp_version_number igs_ps_unit_ofr_pat.version_number%TYPE,
2559: cp_source_cal_type igs_ps_unit_ofr_pat.cal_type%TYPE,
2560: cp_source_ci_sequence_number igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
2561: cp_unit_ass_item_group_id igs_as_unitass_item.unit_ass_item_group_id%TYPE) IS
2562: SELECT *
2563: FROM igs_as_unitass_item uai
2564: WHERE uai.logical_delete_dt IS NULL
2565: AND uai.unit_cd = cp_unit_cd

Line 2563: FROM igs_as_unitass_item uai

2559: cp_source_cal_type igs_ps_unit_ofr_pat.cal_type%TYPE,
2560: cp_source_ci_sequence_number igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
2561: cp_unit_ass_item_group_id igs_as_unitass_item.unit_ass_item_group_id%TYPE) IS
2562: SELECT *
2563: FROM igs_as_unitass_item uai
2564: WHERE uai.logical_delete_dt IS NULL
2565: AND uai.unit_cd = cp_unit_cd
2566: AND uai.version_number = cp_version_number
2567: AND uai.cal_type = cp_source_cal_type

Line 2595: SELECT IGS_AS_UNITASS_ITEM_SEQ_NUM_S.NEXTVAL

2591: SELECT IGS_PS_UNIT_OFR_OPT_UOO_ID_S.NEXTVAL
2592: FROM DUAL;
2593:
2594: CURSOR c_uai_seq_num IS
2595: SELECT IGS_AS_UNITASS_ITEM_SEQ_NUM_S.NEXTVAL
2596: FROM DUAL;
2597:
2598: CURSOR c_teach_date(cp_cal_type igs_ca_inst_all.cal_type%TYPE ,cp_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
2599: SELECT start_dt,end_dt

Line 3386: CURSOR cur_ass_item(cp_unit_cd igs_as_unitass_item_all.unit_cd%TYPE,

3382: AND group_name = cp_group_name;
3383: l_rowid1 VARCHAR2(25);
3384: l_unit_ass_item_group_id NUMBER;
3385:
3386: CURSOR cur_ass_item(cp_unit_cd igs_as_unitass_item_all.unit_cd%TYPE,
3387: cp_version_number igs_as_unitass_item_all.version_number%TYPE,
3388: cp_cal_type igs_as_unitass_item_all.cal_type%TYPE,
3389: cp_ci_sequence_number igs_as_unitass_item_all.ci_sequence_number%TYPE,
3390: cp_unit_ass_item_group_id igs_as_unitass_item_all.unit_ass_item_group_id%TYPE) IS

Line 3387: cp_version_number igs_as_unitass_item_all.version_number%TYPE,

3383: l_rowid1 VARCHAR2(25);
3384: l_unit_ass_item_group_id NUMBER;
3385:
3386: CURSOR cur_ass_item(cp_unit_cd igs_as_unitass_item_all.unit_cd%TYPE,
3387: cp_version_number igs_as_unitass_item_all.version_number%TYPE,
3388: cp_cal_type igs_as_unitass_item_all.cal_type%TYPE,
3389: cp_ci_sequence_number igs_as_unitass_item_all.ci_sequence_number%TYPE,
3390: cp_unit_ass_item_group_id igs_as_unitass_item_all.unit_ass_item_group_id%TYPE) IS
3391: SELECT 'X'

Line 3388: cp_cal_type igs_as_unitass_item_all.cal_type%TYPE,

3384: l_unit_ass_item_group_id NUMBER;
3385:
3386: CURSOR cur_ass_item(cp_unit_cd igs_as_unitass_item_all.unit_cd%TYPE,
3387: cp_version_number igs_as_unitass_item_all.version_number%TYPE,
3388: cp_cal_type igs_as_unitass_item_all.cal_type%TYPE,
3389: cp_ci_sequence_number igs_as_unitass_item_all.ci_sequence_number%TYPE,
3390: cp_unit_ass_item_group_id igs_as_unitass_item_all.unit_ass_item_group_id%TYPE) IS
3391: SELECT 'X'
3392: FROM igs_as_unitass_item_all

Line 3389: cp_ci_sequence_number igs_as_unitass_item_all.ci_sequence_number%TYPE,

3385:
3386: CURSOR cur_ass_item(cp_unit_cd igs_as_unitass_item_all.unit_cd%TYPE,
3387: cp_version_number igs_as_unitass_item_all.version_number%TYPE,
3388: cp_cal_type igs_as_unitass_item_all.cal_type%TYPE,
3389: cp_ci_sequence_number igs_as_unitass_item_all.ci_sequence_number%TYPE,
3390: cp_unit_ass_item_group_id igs_as_unitass_item_all.unit_ass_item_group_id%TYPE) IS
3391: SELECT 'X'
3392: FROM igs_as_unitass_item_all
3393: WHERE unit_cd = cp_unit_cd

Line 3390: cp_unit_ass_item_group_id igs_as_unitass_item_all.unit_ass_item_group_id%TYPE) IS

3386: CURSOR cur_ass_item(cp_unit_cd igs_as_unitass_item_all.unit_cd%TYPE,
3387: cp_version_number igs_as_unitass_item_all.version_number%TYPE,
3388: cp_cal_type igs_as_unitass_item_all.cal_type%TYPE,
3389: cp_ci_sequence_number igs_as_unitass_item_all.ci_sequence_number%TYPE,
3390: cp_unit_ass_item_group_id igs_as_unitass_item_all.unit_ass_item_group_id%TYPE) IS
3391: SELECT 'X'
3392: FROM igs_as_unitass_item_all
3393: WHERE unit_cd = cp_unit_cd
3394: AND version_number = cp_version_number

Line 3392: FROM igs_as_unitass_item_all

3388: cp_cal_type igs_as_unitass_item_all.cal_type%TYPE,
3389: cp_ci_sequence_number igs_as_unitass_item_all.ci_sequence_number%TYPE,
3390: cp_unit_ass_item_group_id igs_as_unitass_item_all.unit_ass_item_group_id%TYPE) IS
3391: SELECT 'X'
3392: FROM igs_as_unitass_item_all
3393: WHERE unit_cd = cp_unit_cd
3394: AND version_number = cp_version_number
3395: AND cal_type = cp_cal_type
3396: AND ci_sequence_number = cp_ci_sequence_number

Line 3433: -- IGS_AS_UNITASS_ITEM record

3429: BEGIN
3430: v_uai_fetched_cnt := v_uai_fetched_cnt +1;
3431: -- all of the below conditions must be true for the
3432: -- insert to proceed, else don't insert this particular
3433: -- IGS_AS_UNITASS_ITEM record
3434:
3435: -- Validate reference is valid in destination pattern's UAI records
3436: v_reference := v_uai_rec.reference;
3437:

Line 3504: igs_as_unitass_item_pkg.insert_row(

3500: -- Perform insert uai record
3501: x_rowid := NULL;
3502: l_unit_ass_item_id := NULL;
3503:
3504: igs_as_unitass_item_pkg.insert_row(
3505: x_rowid => x_rowid,
3506: x_unit_cd => p_unit_cd,
3507: x_version_number => p_version_number,
3508: x_cal_type => p_cal_type,