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_EN_SUSA_LGCY_PUB dependencies on IGS_AS_SU_SETATMPT

Line 20: l_desc_flex_name CONSTANT VARCHAR2(30) := 'IGS_AS_SU_SETATMPT_FLEX';

16: || Change History :
17: || Who When What
18: ------------------------------------------------------------------------------*/
19:
20: l_desc_flex_name CONSTANT VARCHAR2(30) := 'IGS_AS_SU_SETATMPT_FLEX';
21: l_valid_params BOOLEAN := TRUE;
22: l_msg_count NUMBER;
23: BEGIN
24:

Line 40: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'COURSE_CD',

36: FND_MSG_PUB.ADD;
37: l_valid_params := FALSE;
38: ELSE
39: BEGIN
40: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'COURSE_CD',
41: column_value => p_susa_rec.program_cd);
42: EXCEPTION
43: WHEN OTHERS THEN
44: -- Pop and set excep

Line 61: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'UNIT_SET_CD',

57: FND_MSG_PUB.ADD;
58: l_valid_params := FALSE;
59: ELSE
60: BEGIN
61: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'UNIT_SET_CD',
62: column_value => p_susa_rec.unit_set_cd);
63: EXCEPTION
64: WHEN OTHERS THEN
65: -- Pop and set excep

Line 85: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'STUDENT_CONFIRMED_IND',

81:
82: -- Student confirmed ind
83: IF p_susa_rec.student_confirmed_ind IS NOT NULL THEN
84: BEGIN
85: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'STUDENT_CONFIRMED_IND',
86: column_value => p_susa_rec.student_confirmed_ind);
87: EXCEPTION
88: WHEN OTHERS THEN
89: -- Pop and set excep

Line 102: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'PARENT_UNIT_SET_CD',

98:
99: -- Parent Unit set code
100: IF p_susa_rec.parent_unit_set_cd IS NOT NULL THEN
101: BEGIN
102: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'PARENT_UNIT_SET_CD',
103: column_value => p_susa_rec.parent_unit_set_cd);
104: EXCEPTION
105: WHEN OTHERS THEN
106: -- Pop and set excep

Line 119: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'PRIMARY_SET_IND',

115:
116: -- Primary set ind
117: IF p_susa_rec.primary_set_ind IS NOT NULL THEN
118: BEGIN
119: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'PRIMARY_SET_IND',
120: column_value => p_susa_rec.primary_set_ind);
121: EXCEPTION
122: WHEN OTHERS THEN
123: -- Pop and set excep

Line 136: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'VOLUNTARY_END_IND',

132:
133: -- Voluntary end ind
134: IF p_susa_rec.voluntary_end_ind IS NOT NULL THEN
135: BEGIN
136: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'VOLUNTARY_END_IND',
137: column_value => p_susa_rec.voluntary_end_ind);
138: EXCEPTION
139: WHEN OTHERS THEN
140: -- Pop and set excep

Line 153: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'OVERRIDE_TITLE',

149:
150: -- Override title
151: IF p_susa_rec.override_title IS NOT NULL THEN
152: BEGIN
153: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'OVERRIDE_TITLE',
154: column_value => p_susa_rec.override_title);
155: EXCEPTION
156: WHEN OTHERS THEN
157: -- Pop and set excep

Line 170: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'RQRMNTS_COMPLETE_IND',

166:
167: -- Requirements complete ind
168: IF p_susa_rec.rqrmnts_complete_ind IS NOT NULL THEN
169: BEGIN
170: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'RQRMNTS_COMPLETE_IND',
171: column_value => p_susa_rec.rqrmnts_complete_ind);
172: EXCEPTION
173: WHEN OTHERS THEN
174: -- Pop and set excep

Line 187: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'S_COMPLETED_SOURCE_TYPE',

183:
184: -- S Completed source type
185: IF p_susa_rec.s_completed_source_type IS NOT NULL THEN
186: BEGIN
187: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'S_COMPLETED_SOURCE_TYPE',
188: column_value => p_susa_rec.s_completed_source_type);
189: EXCEPTION
190: WHEN OTHERS THEN
191: -- Pop and set excep

Line 248: FUNCTION validate_db_cons(p_person_id IN igs_as_su_setatmpt.person_id%TYPE,

244: END validate_parameters;
245:
246:
247:
248: FUNCTION validate_db_cons(p_person_id IN igs_as_su_setatmpt.person_id%TYPE,
249: p_parent_seq_number IN igs_as_su_setatmpt.parent_sequence_number%TYPE,
250: p_susa_rec IN susa_rec_type
251: ) RETURN VARCHAR2 AS
252: /*----------------------------------------------------------------------------

Line 249: p_parent_seq_number IN igs_as_su_setatmpt.parent_sequence_number%TYPE,

245:
246:
247:
248: FUNCTION validate_db_cons(p_person_id IN igs_as_su_setatmpt.person_id%TYPE,
249: p_parent_seq_number IN igs_as_su_setatmpt.parent_sequence_number%TYPE,
250: p_susa_rec IN susa_rec_type
251: ) RETURN VARCHAR2 AS
252: /*----------------------------------------------------------------------------
253: || Created By : prraj

Line 290: IF NOT igs_as_su_setatmpt_pkg.get_pk_for_validation (x_person_id => p_person_id,

286:
287:
288: -- Parent Unit Set Attempt existence
289: IF p_susa_rec.parent_unit_set_cd IS NOT NULL THEN
290: IF NOT igs_as_su_setatmpt_pkg.get_pk_for_validation (x_person_id => p_person_id,
291: x_course_cd => p_susa_rec.program_cd,
292: x_unit_set_cd => p_susa_rec.parent_unit_set_cd,
293: x_sequence_number => p_parent_seq_number
294: ) THEN

Line 319: FUNCTION validate_unit_set_atmpt (p_person_id IN igs_as_su_setatmpt.person_id%TYPE,

315: END validate_db_cons;
316:
317:
318:
319: FUNCTION validate_unit_set_atmpt (p_person_id IN igs_as_su_setatmpt.person_id%TYPE,
320: p_sequence_number IN igs_as_su_setatmpt.sequence_number%TYPE,
321: p_parent_seq_number IN igs_as_su_setatmpt.parent_sequence_number%TYPE,
322: p_auth_person_id IN igs_as_su_setatmpt.authorised_person_id%TYPE,
323: p_susa_rec IN susa_rec_type

Line 320: p_sequence_number IN igs_as_su_setatmpt.sequence_number%TYPE,

316:
317:
318:
319: FUNCTION validate_unit_set_atmpt (p_person_id IN igs_as_su_setatmpt.person_id%TYPE,
320: p_sequence_number IN igs_as_su_setatmpt.sequence_number%TYPE,
321: p_parent_seq_number IN igs_as_su_setatmpt.parent_sequence_number%TYPE,
322: p_auth_person_id IN igs_as_su_setatmpt.authorised_person_id%TYPE,
323: p_susa_rec IN susa_rec_type
324: ) RETURN BOOLEAN AS

Line 321: p_parent_seq_number IN igs_as_su_setatmpt.parent_sequence_number%TYPE,

317:
318:
319: FUNCTION validate_unit_set_atmpt (p_person_id IN igs_as_su_setatmpt.person_id%TYPE,
320: p_sequence_number IN igs_as_su_setatmpt.sequence_number%TYPE,
321: p_parent_seq_number IN igs_as_su_setatmpt.parent_sequence_number%TYPE,
322: p_auth_person_id IN igs_as_su_setatmpt.authorised_person_id%TYPE,
323: p_susa_rec IN susa_rec_type
324: ) RETURN BOOLEAN AS
325: /*----------------------------------------------------------------------------

Line 322: p_auth_person_id IN igs_as_su_setatmpt.authorised_person_id%TYPE,

318:
319: FUNCTION validate_unit_set_atmpt (p_person_id IN igs_as_su_setatmpt.person_id%TYPE,
320: p_sequence_number IN igs_as_su_setatmpt.sequence_number%TYPE,
321: p_parent_seq_number IN igs_as_su_setatmpt.parent_sequence_number%TYPE,
322: p_auth_person_id IN igs_as_su_setatmpt.authorised_person_id%TYPE,
323: p_susa_rec IN susa_rec_type
324: ) RETURN BOOLEAN AS
325: /*----------------------------------------------------------------------------
326: || Created By : prraj

Line 607: igs_as_su_setatmpt_seq_num_s.NEXTVAL

603:
604: -- Cursor to fetch the sequence number
605: CURSOR c_susa_seq IS
606: SELECT
607: igs_as_su_setatmpt_seq_num_s.NEXTVAL
608: FROM dual;
609:
610: l_api_name CONSTANT VARCHAR2(30) := 'create_unit_set_atmpt';
611: l_api_version CONSTANT NUMBER := 1.0;

Line 616: l_person_id igs_as_su_setatmpt.person_id%TYPE;

612:
613: l_insert_flag BOOLEAN := TRUE;
614: l_ret_val VARCHAR2(1) := NULL;
615:
616: l_person_id igs_as_su_setatmpt.person_id%TYPE;
617: l_auth_person_id igs_as_su_setatmpt.authorised_person_id%TYPE;
618: l_parent_seq_number igs_as_su_setatmpt.parent_sequence_number%TYPE;
619: l_us_version_number igs_as_su_setatmpt.us_version_number%TYPE;
620: l_seqval igs_as_su_setatmpt.sequence_number%TYPE;

Line 617: l_auth_person_id igs_as_su_setatmpt.authorised_person_id%TYPE;

613: l_insert_flag BOOLEAN := TRUE;
614: l_ret_val VARCHAR2(1) := NULL;
615:
616: l_person_id igs_as_su_setatmpt.person_id%TYPE;
617: l_auth_person_id igs_as_su_setatmpt.authorised_person_id%TYPE;
618: l_parent_seq_number igs_as_su_setatmpt.parent_sequence_number%TYPE;
619: l_us_version_number igs_as_su_setatmpt.us_version_number%TYPE;
620: l_seqval igs_as_su_setatmpt.sequence_number%TYPE;
621: l_cal_type igs_as_su_setatmpt.catalog_cal_type%TYPE;

Line 618: l_parent_seq_number igs_as_su_setatmpt.parent_sequence_number%TYPE;

614: l_ret_val VARCHAR2(1) := NULL;
615:
616: l_person_id igs_as_su_setatmpt.person_id%TYPE;
617: l_auth_person_id igs_as_su_setatmpt.authorised_person_id%TYPE;
618: l_parent_seq_number igs_as_su_setatmpt.parent_sequence_number%TYPE;
619: l_us_version_number igs_as_su_setatmpt.us_version_number%TYPE;
620: l_seqval igs_as_su_setatmpt.sequence_number%TYPE;
621: l_cal_type igs_as_su_setatmpt.catalog_cal_type%TYPE;
622: l_ci_sequence_number igs_as_su_setatmpt.catalog_seq_num%TYPE;

Line 619: l_us_version_number igs_as_su_setatmpt.us_version_number%TYPE;

615:
616: l_person_id igs_as_su_setatmpt.person_id%TYPE;
617: l_auth_person_id igs_as_su_setatmpt.authorised_person_id%TYPE;
618: l_parent_seq_number igs_as_su_setatmpt.parent_sequence_number%TYPE;
619: l_us_version_number igs_as_su_setatmpt.us_version_number%TYPE;
620: l_seqval igs_as_su_setatmpt.sequence_number%TYPE;
621: l_cal_type igs_as_su_setatmpt.catalog_cal_type%TYPE;
622: l_ci_sequence_number igs_as_su_setatmpt.catalog_seq_num%TYPE;
623: l_cal_start_dt igs_ca_inst.start_dt%TYPE;

Line 620: l_seqval igs_as_su_setatmpt.sequence_number%TYPE;

616: l_person_id igs_as_su_setatmpt.person_id%TYPE;
617: l_auth_person_id igs_as_su_setatmpt.authorised_person_id%TYPE;
618: l_parent_seq_number igs_as_su_setatmpt.parent_sequence_number%TYPE;
619: l_us_version_number igs_as_su_setatmpt.us_version_number%TYPE;
620: l_seqval igs_as_su_setatmpt.sequence_number%TYPE;
621: l_cal_type igs_as_su_setatmpt.catalog_cal_type%TYPE;
622: l_ci_sequence_number igs_as_su_setatmpt.catalog_seq_num%TYPE;
623: l_cal_start_dt igs_ca_inst.start_dt%TYPE;
624: l_cal_end_dt igs_ca_inst.end_dt%TYPE;

Line 621: l_cal_type igs_as_su_setatmpt.catalog_cal_type%TYPE;

617: l_auth_person_id igs_as_su_setatmpt.authorised_person_id%TYPE;
618: l_parent_seq_number igs_as_su_setatmpt.parent_sequence_number%TYPE;
619: l_us_version_number igs_as_su_setatmpt.us_version_number%TYPE;
620: l_seqval igs_as_su_setatmpt.sequence_number%TYPE;
621: l_cal_type igs_as_su_setatmpt.catalog_cal_type%TYPE;
622: l_ci_sequence_number igs_as_su_setatmpt.catalog_seq_num%TYPE;
623: l_cal_start_dt igs_ca_inst.start_dt%TYPE;
624: l_cal_end_dt igs_ca_inst.end_dt%TYPE;
625: l_cal_return_status VARCHAR2(20);

Line 622: l_ci_sequence_number igs_as_su_setatmpt.catalog_seq_num%TYPE;

618: l_parent_seq_number igs_as_su_setatmpt.parent_sequence_number%TYPE;
619: l_us_version_number igs_as_su_setatmpt.us_version_number%TYPE;
620: l_seqval igs_as_su_setatmpt.sequence_number%TYPE;
621: l_cal_type igs_as_su_setatmpt.catalog_cal_type%TYPE;
622: l_ci_sequence_number igs_as_su_setatmpt.catalog_seq_num%TYPE;
623: l_cal_start_dt igs_ca_inst.start_dt%TYPE;
624: l_cal_end_dt igs_ca_inst.end_dt%TYPE;
625: l_cal_return_status VARCHAR2(20);
626:

Line 627: l_creation_date igs_as_su_setatmpt.creation_date%TYPE;

623: l_cal_start_dt igs_ca_inst.start_dt%TYPE;
624: l_cal_end_dt igs_ca_inst.end_dt%TYPE;
625: l_cal_return_status VARCHAR2(20);
626:
627: l_creation_date igs_as_su_setatmpt.creation_date%TYPE;
628: l_last_update_date igs_as_su_setatmpt.last_update_date%TYPE;
629: l_created_by igs_as_su_setatmpt.created_by%TYPE;
630: l_last_updated_by igs_as_su_setatmpt.last_updated_by%TYPE;
631: l_last_update_login igs_as_su_setatmpt.last_update_login%TYPE;

Line 628: l_last_update_date igs_as_su_setatmpt.last_update_date%TYPE;

624: l_cal_end_dt igs_ca_inst.end_dt%TYPE;
625: l_cal_return_status VARCHAR2(20);
626:
627: l_creation_date igs_as_su_setatmpt.creation_date%TYPE;
628: l_last_update_date igs_as_su_setatmpt.last_update_date%TYPE;
629: l_created_by igs_as_su_setatmpt.created_by%TYPE;
630: l_last_updated_by igs_as_su_setatmpt.last_updated_by%TYPE;
631: l_last_update_login igs_as_su_setatmpt.last_update_login%TYPE;
632:

Line 629: l_created_by igs_as_su_setatmpt.created_by%TYPE;

625: l_cal_return_status VARCHAR2(20);
626:
627: l_creation_date igs_as_su_setatmpt.creation_date%TYPE;
628: l_last_update_date igs_as_su_setatmpt.last_update_date%TYPE;
629: l_created_by igs_as_su_setatmpt.created_by%TYPE;
630: l_last_updated_by igs_as_su_setatmpt.last_updated_by%TYPE;
631: l_last_update_login igs_as_su_setatmpt.last_update_login%TYPE;
632:
633: l_request_id igs_as_su_setatmpt.request_id%TYPE;

Line 630: l_last_updated_by igs_as_su_setatmpt.last_updated_by%TYPE;

626:
627: l_creation_date igs_as_su_setatmpt.creation_date%TYPE;
628: l_last_update_date igs_as_su_setatmpt.last_update_date%TYPE;
629: l_created_by igs_as_su_setatmpt.created_by%TYPE;
630: l_last_updated_by igs_as_su_setatmpt.last_updated_by%TYPE;
631: l_last_update_login igs_as_su_setatmpt.last_update_login%TYPE;
632:
633: l_request_id igs_as_su_setatmpt.request_id%TYPE;
634: l_program_appl_id igs_as_su_setatmpt.program_application_id%TYPE;

Line 631: l_last_update_login igs_as_su_setatmpt.last_update_login%TYPE;

627: l_creation_date igs_as_su_setatmpt.creation_date%TYPE;
628: l_last_update_date igs_as_su_setatmpt.last_update_date%TYPE;
629: l_created_by igs_as_su_setatmpt.created_by%TYPE;
630: l_last_updated_by igs_as_su_setatmpt.last_updated_by%TYPE;
631: l_last_update_login igs_as_su_setatmpt.last_update_login%TYPE;
632:
633: l_request_id igs_as_su_setatmpt.request_id%TYPE;
634: l_program_appl_id igs_as_su_setatmpt.program_application_id%TYPE;
635: l_program_id igs_as_su_setatmpt.program_id%TYPE;

Line 633: l_request_id igs_as_su_setatmpt.request_id%TYPE;

629: l_created_by igs_as_su_setatmpt.created_by%TYPE;
630: l_last_updated_by igs_as_su_setatmpt.last_updated_by%TYPE;
631: l_last_update_login igs_as_su_setatmpt.last_update_login%TYPE;
632:
633: l_request_id igs_as_su_setatmpt.request_id%TYPE;
634: l_program_appl_id igs_as_su_setatmpt.program_application_id%TYPE;
635: l_program_id igs_as_su_setatmpt.program_id%TYPE;
636: l_program_update_date igs_as_su_setatmpt.program_update_date%TYPE;
637:

Line 634: l_program_appl_id igs_as_su_setatmpt.program_application_id%TYPE;

630: l_last_updated_by igs_as_su_setatmpt.last_updated_by%TYPE;
631: l_last_update_login igs_as_su_setatmpt.last_update_login%TYPE;
632:
633: l_request_id igs_as_su_setatmpt.request_id%TYPE;
634: l_program_appl_id igs_as_su_setatmpt.program_application_id%TYPE;
635: l_program_id igs_as_su_setatmpt.program_id%TYPE;
636: l_program_update_date igs_as_su_setatmpt.program_update_date%TYPE;
637:
638: BEGIN

Line 635: l_program_id igs_as_su_setatmpt.program_id%TYPE;

631: l_last_update_login igs_as_su_setatmpt.last_update_login%TYPE;
632:
633: l_request_id igs_as_su_setatmpt.request_id%TYPE;
634: l_program_appl_id igs_as_su_setatmpt.program_application_id%TYPE;
635: l_program_id igs_as_su_setatmpt.program_id%TYPE;
636: l_program_update_date igs_as_su_setatmpt.program_update_date%TYPE;
637:
638: BEGIN
639:

Line 636: l_program_update_date igs_as_su_setatmpt.program_update_date%TYPE;

632:
633: l_request_id igs_as_su_setatmpt.request_id%TYPE;
634: l_program_appl_id igs_as_su_setatmpt.program_application_id%TYPE;
635: l_program_id igs_as_su_setatmpt.program_id%TYPE;
636: l_program_update_date igs_as_su_setatmpt.program_update_date%TYPE;
637:
638: BEGIN
639:
640: -- Create a savepoint

Line 777: -- Perform direct insert on IGS_AS_SU_SETATMPT

773: END IF;
774: END IF;
775:
776:
777: -- Perform direct insert on IGS_AS_SU_SETATMPT
778: IF l_insert_flag THEN
779:
780: l_creation_date := SYSDATE;
781: l_created_by := FND_GLOBAL.USER_ID;

Line 819: INSERT INTO igs_as_su_setatmpt (

815: FETCH c_susa_seq INTO l_seqval;
816: CLOSE c_susa_seq;
817:
818:
819: INSERT INTO igs_as_su_setatmpt (
820: person_id,
821: course_cd,
822: unit_set_cd,
823: us_version_number,