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_AS_GEN_006 dependencies on IGS_AS_ITEM_ASSESSOR

Line 872: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,

868: END;
869: END assp_ins_admin_grds;
870:
871: PROCEDURE assp_ins_aia(
872: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
873: p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,
874: p_ass_assessor_type IN IGS_AS_ITEM_ASSESSOR.ASS_ASSESSOR_TYPE%TYPE ,
875: p_primary_assessor_ind IN IGS_AS_ITEM_ASSESSOR.primary_assessor_ind%TYPE ,
876: p_item_limit IN IGS_AS_ITEM_ASSESSOR.item_limit%TYPE ,

Line 873: p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,

869: END assp_ins_admin_grds;
870:
871: PROCEDURE assp_ins_aia(
872: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
873: p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,
874: p_ass_assessor_type IN IGS_AS_ITEM_ASSESSOR.ASS_ASSESSOR_TYPE%TYPE ,
875: p_primary_assessor_ind IN IGS_AS_ITEM_ASSESSOR.primary_assessor_ind%TYPE ,
876: p_item_limit IN IGS_AS_ITEM_ASSESSOR.item_limit%TYPE ,
877: p_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,

Line 874: p_ass_assessor_type IN IGS_AS_ITEM_ASSESSOR.ASS_ASSESSOR_TYPE%TYPE ,

870:
871: PROCEDURE assp_ins_aia(
872: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
873: p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,
874: p_ass_assessor_type IN IGS_AS_ITEM_ASSESSOR.ASS_ASSESSOR_TYPE%TYPE ,
875: p_primary_assessor_ind IN IGS_AS_ITEM_ASSESSOR.primary_assessor_ind%TYPE ,
876: p_item_limit IN IGS_AS_ITEM_ASSESSOR.item_limit%TYPE ,
877: p_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
878: p_unit_mode IN IGS_AS_ITEM_ASSESSOR.UNIT_MODE%TYPE ,

Line 875: p_primary_assessor_ind IN IGS_AS_ITEM_ASSESSOR.primary_assessor_ind%TYPE ,

871: PROCEDURE assp_ins_aia(
872: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
873: p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,
874: p_ass_assessor_type IN IGS_AS_ITEM_ASSESSOR.ASS_ASSESSOR_TYPE%TYPE ,
875: p_primary_assessor_ind IN IGS_AS_ITEM_ASSESSOR.primary_assessor_ind%TYPE ,
876: p_item_limit IN IGS_AS_ITEM_ASSESSOR.item_limit%TYPE ,
877: p_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
878: p_unit_mode IN IGS_AS_ITEM_ASSESSOR.UNIT_MODE%TYPE ,
879: p_unit_class IN IGS_AS_ITEM_ASSESSOR.UNIT_CLASS%TYPE ,

Line 876: p_item_limit IN IGS_AS_ITEM_ASSESSOR.item_limit%TYPE ,

872: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
873: p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,
874: p_ass_assessor_type IN IGS_AS_ITEM_ASSESSOR.ASS_ASSESSOR_TYPE%TYPE ,
875: p_primary_assessor_ind IN IGS_AS_ITEM_ASSESSOR.primary_assessor_ind%TYPE ,
876: p_item_limit IN IGS_AS_ITEM_ASSESSOR.item_limit%TYPE ,
877: p_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
878: p_unit_mode IN IGS_AS_ITEM_ASSESSOR.UNIT_MODE%TYPE ,
879: p_unit_class IN IGS_AS_ITEM_ASSESSOR.UNIT_CLASS%TYPE ,
880: p_comments IN IGS_AS_ITEM_ASSESSOR.comments%TYPE )

Line 877: p_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,

873: p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,
874: p_ass_assessor_type IN IGS_AS_ITEM_ASSESSOR.ASS_ASSESSOR_TYPE%TYPE ,
875: p_primary_assessor_ind IN IGS_AS_ITEM_ASSESSOR.primary_assessor_ind%TYPE ,
876: p_item_limit IN IGS_AS_ITEM_ASSESSOR.item_limit%TYPE ,
877: p_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
878: p_unit_mode IN IGS_AS_ITEM_ASSESSOR.UNIT_MODE%TYPE ,
879: p_unit_class IN IGS_AS_ITEM_ASSESSOR.UNIT_CLASS%TYPE ,
880: p_comments IN IGS_AS_ITEM_ASSESSOR.comments%TYPE )
881: IS

Line 878: p_unit_mode IN IGS_AS_ITEM_ASSESSOR.UNIT_MODE%TYPE ,

874: p_ass_assessor_type IN IGS_AS_ITEM_ASSESSOR.ASS_ASSESSOR_TYPE%TYPE ,
875: p_primary_assessor_ind IN IGS_AS_ITEM_ASSESSOR.primary_assessor_ind%TYPE ,
876: p_item_limit IN IGS_AS_ITEM_ASSESSOR.item_limit%TYPE ,
877: p_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
878: p_unit_mode IN IGS_AS_ITEM_ASSESSOR.UNIT_MODE%TYPE ,
879: p_unit_class IN IGS_AS_ITEM_ASSESSOR.UNIT_CLASS%TYPE ,
880: p_comments IN IGS_AS_ITEM_ASSESSOR.comments%TYPE )
881: IS
882: V_SEQUeNCE_NUMBER number;

Line 879: p_unit_class IN IGS_AS_ITEM_ASSESSOR.UNIT_CLASS%TYPE ,

875: p_primary_assessor_ind IN IGS_AS_ITEM_ASSESSOR.primary_assessor_ind%TYPE ,
876: p_item_limit IN IGS_AS_ITEM_ASSESSOR.item_limit%TYPE ,
877: p_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
878: p_unit_mode IN IGS_AS_ITEM_ASSESSOR.UNIT_MODE%TYPE ,
879: p_unit_class IN IGS_AS_ITEM_ASSESSOR.UNIT_CLASS%TYPE ,
880: p_comments IN IGS_AS_ITEM_ASSESSOR.comments%TYPE )
881: IS
882: V_SEQUeNCE_NUMBER number;
883: BEGIN -- assp_ins_aia

Line 880: p_comments IN IGS_AS_ITEM_ASSESSOR.comments%TYPE )

876: p_item_limit IN IGS_AS_ITEM_ASSESSOR.item_limit%TYPE ,
877: p_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
878: p_unit_mode IN IGS_AS_ITEM_ASSESSOR.UNIT_MODE%TYPE ,
879: p_unit_class IN IGS_AS_ITEM_ASSESSOR.UNIT_CLASS%TYPE ,
880: p_comments IN IGS_AS_ITEM_ASSESSOR.comments%TYPE )
881: IS
882: V_SEQUeNCE_NUMBER number;
883: BEGIN -- assp_ins_aia
884: -- Insert a record into the IGS_AS_ITEM_ASSESSOR table

Line 884: -- Insert a record into the IGS_AS_ITEM_ASSESSOR table

880: p_comments IN IGS_AS_ITEM_ASSESSOR.comments%TYPE )
881: IS
882: V_SEQUeNCE_NUMBER number;
883: BEGIN -- assp_ins_aia
884: -- Insert a record into the IGS_AS_ITEM_ASSESSOR table
885: --DECLARE
886: --BEGIN
887: select IGS_AS_ITEM_ASSESSOR_SEQ_NUM_S.NEXTVAL into V_SEQUENCE_NUMBER FROM DUAL;
888: x_rowid := NULL ;

Line 887: select IGS_AS_ITEM_ASSESSOR_SEQ_NUM_S.NEXTVAL into V_SEQUENCE_NUMBER FROM DUAL;

883: BEGIN -- assp_ins_aia
884: -- Insert a record into the IGS_AS_ITEM_ASSESSOR table
885: --DECLARE
886: --BEGIN
887: select IGS_AS_ITEM_ASSESSOR_SEQ_NUM_S.NEXTVAL into V_SEQUENCE_NUMBER FROM DUAL;
888: x_rowid := NULL ;
889: IGS_AS_ITEM_ASSESSOR_PKG.INSERT_ROW(
890: X_ROWID => x_rowid,
891: X_ASS_ID => p_ass_id,

Line 889: IGS_AS_ITEM_ASSESSOR_PKG.INSERT_ROW(

885: --DECLARE
886: --BEGIN
887: select IGS_AS_ITEM_ASSESSOR_SEQ_NUM_S.NEXTVAL into V_SEQUENCE_NUMBER FROM DUAL;
888: x_rowid := NULL ;
889: IGS_AS_ITEM_ASSESSOR_PKG.INSERT_ROW(
890: X_ROWID => x_rowid,
891: X_ASS_ID => p_ass_id,
892: X_PERSON_ID => p_person_id,
893: X_SEQUENCE_NUMBER => V_SEQUENCE_NUMBER,

Line 912: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,

908: IGS_GE_MSG_STACK.ADD;
909: App_Exception.Raise_Exception;
910: END assp_ins_aia;
911: PROCEDURE assp_ins_aia_default(
912: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
913: p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE ,
914: p_version_number IN IGS_PS_UNIT_VER_ALL.version_number%TYPE )
915: IS
916: BEGIN -- assp_ins_aia_default

Line 917: -- Insert a default record into the IGS_AS_ITEM_ASSESSOR table

913: p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE ,
914: p_version_number IN IGS_PS_UNIT_VER_ALL.version_number%TYPE )
915: IS
916: BEGIN -- assp_ins_aia_default
917: -- Insert a default record into the IGS_AS_ITEM_ASSESSOR table
918: DECLARE
919: cst_yes CONSTANT CHAR := 'Y';
920: cst_no CONSTANT CHAR := 'N';
921: cst_unit_coord CONSTANT VARCHAR2(20) := 'unit CO-ORDINATOR.';

Line 923: cp_ass_id IGS_AS_ITEM_ASSESSOR.ass_id%TYPE) IS

919: cst_yes CONSTANT CHAR := 'Y';
920: cst_no CONSTANT CHAR := 'N';
921: cst_unit_coord CONSTANT VARCHAR2(20) := 'unit CO-ORDINATOR.';
922: CURSOR c_aia(
923: cp_ass_id IGS_AS_ITEM_ASSESSOR.ass_id%TYPE) IS
924: SELECT COUNT(*)
925: FROM IGS_AS_ITEM_ASSESSOR
926: WHERE ass_id = cp_ass_id;
927: CURSOR c_uv(

Line 925: FROM IGS_AS_ITEM_ASSESSOR

921: cst_unit_coord CONSTANT VARCHAR2(20) := 'unit CO-ORDINATOR.';
922: CURSOR c_aia(
923: cp_ass_id IGS_AS_ITEM_ASSESSOR.ass_id%TYPE) IS
924: SELECT COUNT(*)
925: FROM IGS_AS_ITEM_ASSESSOR
926: WHERE ass_id = cp_ass_id;
927: CURSOR c_uv(
928: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
929: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS

Line 942: v_ass_id IGS_AS_ITEM_ASSESSOR.ass_id%TYPE;

938: closed_ind = cst_no;
939: v_aia_count NUMBER;
940: v_uv_rec c_uv%ROWTYPE;
941: v_asst_rec c_asst%ROWTYPE;
942: v_ass_id IGS_AS_ITEM_ASSESSOR.ass_id%TYPE;
943: v_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE;
944: v_version_number IGS_PS_UNIT_VER.version_number%TYPE;
945: BEGIN
946: -- Initialise all the variables