DBA Data[Home] [Help]

APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_USEC_OCCURS_ALL

Line 839: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;

835: Who When What
836:
837: ********************************************************************************************** */
838: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
839: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;
840:
841: /* Private Procedures for create_uso_facility */
842: PROCEDURE trim_values ( p_uso_fclt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_rec_type ) AS
843: BEGIN

Line 897: CURSOR c_uso_id (cp_occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%TYPE,cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

893: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
894: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
895: l_c_message VARCHAR2(30);
896:
897: CURSOR c_uso_id (cp_occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%TYPE,cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
898: SELECT unit_section_occurrence_id
899: FROM igs_ps_usec_occurs_all
900: WHERE uoo_id = cp_n_uoo_id
901: AND occurrence_identifier = cp_occurrence_identifier;

Line 899: FROM igs_ps_usec_occurs_all

895: l_c_message VARCHAR2(30);
896:
897: CURSOR c_uso_id (cp_occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%TYPE,cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
898: SELECT unit_section_occurrence_id
899: FROM igs_ps_usec_occurs_all
900: WHERE uoo_id = cp_n_uoo_id
901: AND occurrence_identifier = cp_occurrence_identifier;
902:
903:

Line 6216: l_d_start_dt igs_ps_usec_occurs_all.start_date%TYPE;

6212:
6213: l_n_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE;
6214: l_n_uso_id igs_ps_uso_instrctrs.unit_section_occurrence_id%TYPE;
6215: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
6216: l_d_start_dt igs_ps_usec_occurs_all.start_date%TYPE;
6217: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;
6218: l_insert_status BOOLEAN;
6219: l_delete_status BOOLEAN;
6220: l_message_name VARCHAR2(30);

Line 6217: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;

6213: l_n_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE;
6214: l_n_uso_id igs_ps_uso_instrctrs.unit_section_occurrence_id%TYPE;
6215: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
6216: l_d_start_dt igs_ps_usec_occurs_all.start_date%TYPE;
6217: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;
6218: l_insert_status BOOLEAN;
6219: l_delete_status BOOLEAN;
6220: l_message_name VARCHAR2(30);
6221:

Line 6328: CURSOR c_uoo_id (cp_n_uso_id IN igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

6324: Modified the two cursors c_tba_count,c_tba_uso_id
6325: ***********************************************************************************************/
6326:
6327:
6328: CURSOR c_uoo_id (cp_n_uso_id IN igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
6329: SELECT A.uoo_id
6330: FROM igs_ps_usec_occurs_all A
6331: WHERE A.unit_section_occurrence_id = cp_n_uso_id;
6332:

Line 6330: FROM igs_ps_usec_occurs_all A

6326:
6327:
6328: CURSOR c_uoo_id (cp_n_uso_id IN igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
6329: SELECT A.uoo_id
6330: FROM igs_ps_usec_occurs_all A
6331: WHERE A.unit_section_occurrence_id = cp_n_uso_id;
6332:
6333: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;
6334: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;

Line 6403: CURSOR c_unit_ver (cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

6399: END IF;
6400: END validate_derivation;
6401:
6402: PROCEDURE validate_db_cons(p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type) AS
6403: CURSOR c_unit_ver (cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
6404: SELECT a.unit_cd, a.version_number
6405: FROM igs_ps_unit_ofr_opt_all a, igs_ps_usec_occurs_all b
6406: WHERE a.uoo_id = b.uoo_id
6407: AND b.unit_section_occurrence_id = cp_n_uso_id;

Line 6405: FROM igs_ps_unit_ofr_opt_all a, igs_ps_usec_occurs_all b

6401:
6402: PROCEDURE validate_db_cons(p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type) AS
6403: CURSOR c_unit_ver (cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
6404: SELECT a.unit_cd, a.version_number
6405: FROM igs_ps_unit_ofr_opt_all a, igs_ps_usec_occurs_all b
6406: WHERE a.uoo_id = b.uoo_id
6407: AND b.unit_section_occurrence_id = cp_n_uso_id;
6408:
6409: rec_unit_ver c_unit_ver%ROWTYPE;

Line 6477: AND NOT EXISTS (SELECT 'X' FROM igs_ps_uso_instrctrs a,igs_ps_usec_occurs_all b

6473: SELECT 'X'
6474: FROM igs_ps_usec_tch_resp
6475: WHERE uoo_id =cp_uoo_id
6476: AND instructor_id=cp_ins_id
6477: AND NOT EXISTS (SELECT 'X' FROM igs_ps_uso_instrctrs a,igs_ps_usec_occurs_all b
6478: WHERE a.unit_section_occurrence_id=b.unit_section_occurrence_id
6479: AND b.uoo_id=cp_uoo_id
6480: AND a.instructor_id=cp_ins_id);
6481:

Line 6771: l_d_start_dt igs_ps_usec_occurs_all.start_date%TYPE;

6767: Who When What
6768: ***********************************************************************************************/
6769: l_n_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE;
6770: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
6771: l_d_start_dt igs_ps_usec_occurs_all.start_date%TYPE;
6772: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;
6773: l_message_name VARCHAR2(30);
6774:
6775:

Line 6772: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;

6768: ***********************************************************************************************/
6769: l_n_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE;
6770: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
6771: l_d_start_dt igs_ps_usec_occurs_all.start_date%TYPE;
6772: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;
6773: l_message_name VARCHAR2(30);
6774:
6775:
6776: -- for doing certain validation at unit section level while importing unit section occurrence of instructors