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_UNIT_LGCY_PKG dependencies on IGS_CA_INST_ALL

Line 2359: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;

2355: l_message_name VARCHAR2(30);
2356:
2357: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
2358: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
2359: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
2360: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
2361: l_c_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE;
2362: l_n_unit_contact_id igs_pe_person_base_v.person_id%TYPE;
2363: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

Line 2360: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

2356:
2357: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
2358: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
2359: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
2360: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
2361: l_c_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE;
2362: l_n_unit_contact_id igs_pe_person_base_v.person_id%TYPE;
2363: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
2364: l_n_sup_uoo_id igs_ps_unit_ofr_opt_all.sup_uoo_id%TYPE;

Line 2940: l_d_sup_start_dt igs_ca_inst_all.start_dt%TYPE;

2936: sarakshi 22-Aug-2003 Bug#304509, defaulting the value of Not Multiple Unit Section Flag
2937: ********************************************************************************************* */
2938: l_c_sup_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
2939: l_n_sup_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
2940: l_d_sup_start_dt igs_ca_inst_all.start_dt%TYPE;
2941: l_d_sup_end_dt igs_ca_inst_all.end_dt%TYPE;
2942: l_c_message VARCHAR2(30);
2943:
2944: BEGIN

Line 2941: l_d_sup_end_dt igs_ca_inst_all.end_dt%TYPE;

2937: ********************************************************************************************* */
2938: l_c_sup_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
2939: l_n_sup_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
2940: l_d_sup_start_dt igs_ca_inst_all.start_dt%TYPE;
2941: l_d_sup_end_dt igs_ca_inst_all.end_dt%TYPE;
2942: l_c_message VARCHAR2(30);
2943:
2944: BEGIN
2945:

Line 5754: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;

5750: -- Carry out derivations and validate them
5751: PROCEDURE validate_derivations ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type ) AS
5752: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
5753: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
5754: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
5755: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
5756: l_c_message VARCHAR2(30);
5757: BEGIN
5758:

Line 5755: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

5751: PROCEDURE validate_derivations ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type ) AS
5752: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
5753: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
5754: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
5755: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
5756: l_c_message VARCHAR2(30);
5757: BEGIN
5758:
5759:

Line 6058: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;

6054: ********************************************************************************************** */
6055:
6056: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
6057: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
6058: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
6059: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
6060: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
6061: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;
6062: l_n_usec_occurs_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;

Line 6059: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

6055:
6056: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
6057: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
6058: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
6059: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
6060: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
6061: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;
6062: l_n_usec_occurs_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;
6063:

Line 7339: l_c_cal_type igs_ca_inst_all.cal_type%TYPE; -- Holds Calendar Type

7335:
7336: ********************************************************************************************** */
7337:
7338:
7339: l_c_cal_type igs_ca_inst_all.cal_type%TYPE; -- Holds Calendar Type
7340: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE; -- Holds Calendar Instance Sequence Number
7341: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE; -- Holds Unit Offering Options Identifier
7342: l_n_usec_ref_id igs_ps_usec_ref.unit_section_reference_id%TYPE; -- Holds Unit Section Reference Identifier
7343: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE; -- Holds the Unit Section Occurrence Identifier

Line 7340: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE; -- Holds Calendar Instance Sequence Number

7336: ********************************************************************************************** */
7337:
7338:
7339: l_c_cal_type igs_ca_inst_all.cal_type%TYPE; -- Holds Calendar Type
7340: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE; -- Holds Calendar Instance Sequence Number
7341: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE; -- Holds Unit Offering Options Identifier
7342: l_n_usec_ref_id igs_ps_usec_ref.unit_section_reference_id%TYPE; -- Holds Unit Section Reference Identifier
7343: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE; -- Holds the Unit Section Occurrence Identifier
7344:

Line 7454: l_d_start igs_ca_inst_all.start_dt%TYPE;

7450: SELECT A.unit_section_reference_id
7451: FROM igs_ps_usec_ref A
7452: WHERE A.uoo_id = cp_uoo_id;
7453:
7454: l_d_start igs_ca_inst_all.start_dt%TYPE;
7455: l_d_end igs_ca_inst_all.end_dt%TYPE;
7456: l_ret_status VARCHAR2(30);
7457:
7458: BEGIN

Line 7455: l_d_end igs_ca_inst_all.end_dt%TYPE;

7451: FROM igs_ps_usec_ref A
7452: WHERE A.uoo_id = cp_uoo_id;
7453:
7454: l_d_start igs_ca_inst_all.start_dt%TYPE;
7455: l_d_end igs_ca_inst_all.end_dt%TYPE;
7456: l_ret_status VARCHAR2(30);
7457:
7458: BEGIN
7459:

Line 8435: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;

8431: SELECT A.uoo_id
8432: FROM igs_ps_usec_occurs_all A
8433: WHERE A.unit_section_occurrence_id = cp_n_uso_id;
8434:
8435: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;
8436: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;
8437: l_d_start igs_ca_inst_all.start_dt%TYPE;
8438: l_d_end igs_ca_inst_all.end_dt%TYPE;
8439: l_c_ret_status VARCHAR2(30);

Line 8436: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;

8432: FROM igs_ps_usec_occurs_all A
8433: WHERE A.unit_section_occurrence_id = cp_n_uso_id;
8434:
8435: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;
8436: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;
8437: l_d_start igs_ca_inst_all.start_dt%TYPE;
8438: l_d_end igs_ca_inst_all.end_dt%TYPE;
8439: l_c_ret_status VARCHAR2(30);
8440: l_c_msg VARCHAR2(30);

Line 8437: l_d_start igs_ca_inst_all.start_dt%TYPE;

8433: WHERE A.unit_section_occurrence_id = cp_n_uso_id;
8434:
8435: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;
8436: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;
8437: l_d_start igs_ca_inst_all.start_dt%TYPE;
8438: l_d_end igs_ca_inst_all.end_dt%TYPE;
8439: l_c_ret_status VARCHAR2(30);
8440: l_c_msg VARCHAR2(30);
8441:

Line 8438: l_d_end igs_ca_inst_all.end_dt%TYPE;

8434:
8435: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;
8436: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;
8437: l_d_start igs_ca_inst_all.start_dt%TYPE;
8438: l_d_end igs_ca_inst_all.end_dt%TYPE;
8439: l_c_ret_status VARCHAR2(30);
8440: l_c_msg VARCHAR2(30);
8441:
8442: BEGIN