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_006 dependencies on IGS_PS_UNIT_OFR_OPT

Line 83: v_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

79: p_unit_class IN VARCHAR2 )
80: RETURN NUMBER AS
81: BEGIN
82: DECLARE
83: v_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
84: -- this cursor used when primary key is passed
85: CURSOR c_uoo IS
86: SELECT IGS_PS_UNIT_OFR_OPT.uoo_id
87: FROM IGS_PS_UNIT_OFR_OPT

Line 86: SELECT IGS_PS_UNIT_OFR_OPT.uoo_id

82: DECLARE
83: v_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
84: -- this cursor used when primary key is passed
85: CURSOR c_uoo IS
86: SELECT IGS_PS_UNIT_OFR_OPT.uoo_id
87: FROM IGS_PS_UNIT_OFR_OPT
88: WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = p_unit_cd AND
89: IGS_PS_UNIT_OFR_OPT.version_number = p_version_number AND
90: IGS_PS_UNIT_OFR_OPT.cal_type = p_cal_type AND

Line 87: FROM IGS_PS_UNIT_OFR_OPT

83: v_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
84: -- this cursor used when primary key is passed
85: CURSOR c_uoo IS
86: SELECT IGS_PS_UNIT_OFR_OPT.uoo_id
87: FROM IGS_PS_UNIT_OFR_OPT
88: WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = p_unit_cd AND
89: IGS_PS_UNIT_OFR_OPT.version_number = p_version_number AND
90: IGS_PS_UNIT_OFR_OPT.cal_type = p_cal_type AND
91: IGS_PS_UNIT_OFR_OPT.ci_sequence_number = p_ci_sequence_number AND

Line 88: WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = p_unit_cd AND

84: -- this cursor used when primary key is passed
85: CURSOR c_uoo IS
86: SELECT IGS_PS_UNIT_OFR_OPT.uoo_id
87: FROM IGS_PS_UNIT_OFR_OPT
88: WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = p_unit_cd AND
89: IGS_PS_UNIT_OFR_OPT.version_number = p_version_number AND
90: IGS_PS_UNIT_OFR_OPT.cal_type = p_cal_type AND
91: IGS_PS_UNIT_OFR_OPT.ci_sequence_number = p_ci_sequence_number AND
92: IGS_PS_UNIT_OFR_OPT.location_cd = p_location_cd AND

Line 89: IGS_PS_UNIT_OFR_OPT.version_number = p_version_number AND

85: CURSOR c_uoo IS
86: SELECT IGS_PS_UNIT_OFR_OPT.uoo_id
87: FROM IGS_PS_UNIT_OFR_OPT
88: WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = p_unit_cd AND
89: IGS_PS_UNIT_OFR_OPT.version_number = p_version_number AND
90: IGS_PS_UNIT_OFR_OPT.cal_type = p_cal_type AND
91: IGS_PS_UNIT_OFR_OPT.ci_sequence_number = p_ci_sequence_number AND
92: IGS_PS_UNIT_OFR_OPT.location_cd = p_location_cd AND
93: IGS_PS_UNIT_OFR_OPT.unit_class = p_unit_class;

Line 90: IGS_PS_UNIT_OFR_OPT.cal_type = p_cal_type AND

86: SELECT IGS_PS_UNIT_OFR_OPT.uoo_id
87: FROM IGS_PS_UNIT_OFR_OPT
88: WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = p_unit_cd AND
89: IGS_PS_UNIT_OFR_OPT.version_number = p_version_number AND
90: IGS_PS_UNIT_OFR_OPT.cal_type = p_cal_type AND
91: IGS_PS_UNIT_OFR_OPT.ci_sequence_number = p_ci_sequence_number AND
92: IGS_PS_UNIT_OFR_OPT.location_cd = p_location_cd AND
93: IGS_PS_UNIT_OFR_OPT.unit_class = p_unit_class;
94: BEGIN

Line 91: IGS_PS_UNIT_OFR_OPT.ci_sequence_number = p_ci_sequence_number AND

87: FROM IGS_PS_UNIT_OFR_OPT
88: WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = p_unit_cd AND
89: IGS_PS_UNIT_OFR_OPT.version_number = p_version_number AND
90: IGS_PS_UNIT_OFR_OPT.cal_type = p_cal_type AND
91: IGS_PS_UNIT_OFR_OPT.ci_sequence_number = p_ci_sequence_number AND
92: IGS_PS_UNIT_OFR_OPT.location_cd = p_location_cd AND
93: IGS_PS_UNIT_OFR_OPT.unit_class = p_unit_class;
94: BEGIN
95: -- This module returns the IGS_PS_UNIT offering option ID for the specified

Line 92: IGS_PS_UNIT_OFR_OPT.location_cd = p_location_cd AND

88: WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = p_unit_cd AND
89: IGS_PS_UNIT_OFR_OPT.version_number = p_version_number AND
90: IGS_PS_UNIT_OFR_OPT.cal_type = p_cal_type AND
91: IGS_PS_UNIT_OFR_OPT.ci_sequence_number = p_ci_sequence_number AND
92: IGS_PS_UNIT_OFR_OPT.location_cd = p_location_cd AND
93: IGS_PS_UNIT_OFR_OPT.unit_class = p_unit_class;
94: BEGIN
95: -- This module returns the IGS_PS_UNIT offering option ID for the specified
96: -- IGS_PS_UNIT offering option.

Line 93: IGS_PS_UNIT_OFR_OPT.unit_class = p_unit_class;

89: IGS_PS_UNIT_OFR_OPT.version_number = p_version_number AND
90: IGS_PS_UNIT_OFR_OPT.cal_type = p_cal_type AND
91: IGS_PS_UNIT_OFR_OPT.ci_sequence_number = p_ci_sequence_number AND
92: IGS_PS_UNIT_OFR_OPT.location_cd = p_location_cd AND
93: IGS_PS_UNIT_OFR_OPT.unit_class = p_unit_class;
94: BEGIN
95: -- This module returns the IGS_PS_UNIT offering option ID for the specified
96: -- IGS_PS_UNIT offering option.
97: OPEN c_uoo;

Line 120: gv_unit_offering_option_rec IGS_PS_UNIT_OFR_OPT%ROWTYPE;

116: AS
117: BEGIN
118: DECLARE
119: lv_param_values VARCHAR2(1080);
120: gv_unit_offering_option_rec IGS_PS_UNIT_OFR_OPT%ROWTYPE;
121: -- this cursor used when primary key is passed
122: CURSOR c_unit_offering_option_prim(
123: cp_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE,
124: cp_version_number IGS_PS_UNIT_OFR_OPT.version_number%TYPE,

Line 123: cp_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE,

119: lv_param_values VARCHAR2(1080);
120: gv_unit_offering_option_rec IGS_PS_UNIT_OFR_OPT%ROWTYPE;
121: -- this cursor used when primary key is passed
122: CURSOR c_unit_offering_option_prim(
123: cp_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE,
124: cp_version_number IGS_PS_UNIT_OFR_OPT.version_number%TYPE,
125: cp_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
126: cp_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
127: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,

Line 124: cp_version_number IGS_PS_UNIT_OFR_OPT.version_number%TYPE,

120: gv_unit_offering_option_rec IGS_PS_UNIT_OFR_OPT%ROWTYPE;
121: -- this cursor used when primary key is passed
122: CURSOR c_unit_offering_option_prim(
123: cp_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE,
124: cp_version_number IGS_PS_UNIT_OFR_OPT.version_number%TYPE,
125: cp_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
126: cp_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
127: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
128: cp_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE) IS

Line 125: cp_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,

121: -- this cursor used when primary key is passed
122: CURSOR c_unit_offering_option_prim(
123: cp_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE,
124: cp_version_number IGS_PS_UNIT_OFR_OPT.version_number%TYPE,
125: cp_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
126: cp_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
127: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
128: cp_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE) IS
129: SELECT IGS_PS_UNIT_OFR_OPT.uoo_id

Line 126: cp_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,

122: CURSOR c_unit_offering_option_prim(
123: cp_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE,
124: cp_version_number IGS_PS_UNIT_OFR_OPT.version_number%TYPE,
125: cp_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
126: cp_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
127: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
128: cp_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE) IS
129: SELECT IGS_PS_UNIT_OFR_OPT.uoo_id
130: FROM IGS_PS_UNIT_OFR_OPT

Line 127: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,

123: cp_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE,
124: cp_version_number IGS_PS_UNIT_OFR_OPT.version_number%TYPE,
125: cp_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
126: cp_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
127: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
128: cp_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE) IS
129: SELECT IGS_PS_UNIT_OFR_OPT.uoo_id
130: FROM IGS_PS_UNIT_OFR_OPT
131: WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = cp_unit_cd AND

Line 128: cp_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE) IS

124: cp_version_number IGS_PS_UNIT_OFR_OPT.version_number%TYPE,
125: cp_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
126: cp_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
127: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
128: cp_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE) IS
129: SELECT IGS_PS_UNIT_OFR_OPT.uoo_id
130: FROM IGS_PS_UNIT_OFR_OPT
131: WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = cp_unit_cd AND
132: IGS_PS_UNIT_OFR_OPT.version_number = cp_version_number AND

Line 129: SELECT IGS_PS_UNIT_OFR_OPT.uoo_id

125: cp_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
126: cp_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
127: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
128: cp_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE) IS
129: SELECT IGS_PS_UNIT_OFR_OPT.uoo_id
130: FROM IGS_PS_UNIT_OFR_OPT
131: WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = cp_unit_cd AND
132: IGS_PS_UNIT_OFR_OPT.version_number = cp_version_number AND
133: IGS_PS_UNIT_OFR_OPT.cal_type= cp_cal_type AND

Line 130: FROM IGS_PS_UNIT_OFR_OPT

126: cp_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
127: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
128: cp_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE) IS
129: SELECT IGS_PS_UNIT_OFR_OPT.uoo_id
130: FROM IGS_PS_UNIT_OFR_OPT
131: WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = cp_unit_cd AND
132: IGS_PS_UNIT_OFR_OPT.version_number = cp_version_number AND
133: IGS_PS_UNIT_OFR_OPT.cal_type= cp_cal_type AND
134: IGS_PS_UNIT_OFR_OPT.ci_sequence_number = cp_ci_sequence_number AND

Line 131: WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = cp_unit_cd AND

127: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
128: cp_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE) IS
129: SELECT IGS_PS_UNIT_OFR_OPT.uoo_id
130: FROM IGS_PS_UNIT_OFR_OPT
131: WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = cp_unit_cd AND
132: IGS_PS_UNIT_OFR_OPT.version_number = cp_version_number AND
133: IGS_PS_UNIT_OFR_OPT.cal_type= cp_cal_type AND
134: IGS_PS_UNIT_OFR_OPT.ci_sequence_number = cp_ci_sequence_number AND
135: IGS_PS_UNIT_OFR_OPT.location_cd = cp_location_cd AND

Line 132: IGS_PS_UNIT_OFR_OPT.version_number = cp_version_number AND

128: cp_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE) IS
129: SELECT IGS_PS_UNIT_OFR_OPT.uoo_id
130: FROM IGS_PS_UNIT_OFR_OPT
131: WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = cp_unit_cd AND
132: IGS_PS_UNIT_OFR_OPT.version_number = cp_version_number AND
133: IGS_PS_UNIT_OFR_OPT.cal_type= cp_cal_type AND
134: IGS_PS_UNIT_OFR_OPT.ci_sequence_number = cp_ci_sequence_number AND
135: IGS_PS_UNIT_OFR_OPT.location_cd = cp_location_cd AND
136: IGS_PS_UNIT_OFR_OPT.unit_class = cp_unit_class;

Line 133: IGS_PS_UNIT_OFR_OPT.cal_type= cp_cal_type AND

129: SELECT IGS_PS_UNIT_OFR_OPT.uoo_id
130: FROM IGS_PS_UNIT_OFR_OPT
131: WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = cp_unit_cd AND
132: IGS_PS_UNIT_OFR_OPT.version_number = cp_version_number AND
133: IGS_PS_UNIT_OFR_OPT.cal_type= cp_cal_type AND
134: IGS_PS_UNIT_OFR_OPT.ci_sequence_number = cp_ci_sequence_number AND
135: IGS_PS_UNIT_OFR_OPT.location_cd = cp_location_cd AND
136: IGS_PS_UNIT_OFR_OPT.unit_class = cp_unit_class;
137: -- this cursor is used when unique key is passed

Line 134: IGS_PS_UNIT_OFR_OPT.ci_sequence_number = cp_ci_sequence_number AND

130: FROM IGS_PS_UNIT_OFR_OPT
131: WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = cp_unit_cd AND
132: IGS_PS_UNIT_OFR_OPT.version_number = cp_version_number AND
133: IGS_PS_UNIT_OFR_OPT.cal_type= cp_cal_type AND
134: IGS_PS_UNIT_OFR_OPT.ci_sequence_number = cp_ci_sequence_number AND
135: IGS_PS_UNIT_OFR_OPT.location_cd = cp_location_cd AND
136: IGS_PS_UNIT_OFR_OPT.unit_class = cp_unit_class;
137: -- this cursor is used when unique key is passed
138: CURSOR c_unit_offering_option_uniq(

Line 135: IGS_PS_UNIT_OFR_OPT.location_cd = cp_location_cd AND

131: WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = cp_unit_cd AND
132: IGS_PS_UNIT_OFR_OPT.version_number = cp_version_number AND
133: IGS_PS_UNIT_OFR_OPT.cal_type= cp_cal_type AND
134: IGS_PS_UNIT_OFR_OPT.ci_sequence_number = cp_ci_sequence_number AND
135: IGS_PS_UNIT_OFR_OPT.location_cd = cp_location_cd AND
136: IGS_PS_UNIT_OFR_OPT.unit_class = cp_unit_class;
137: -- this cursor is used when unique key is passed
138: CURSOR c_unit_offering_option_uniq(
139: cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS

Line 136: IGS_PS_UNIT_OFR_OPT.unit_class = cp_unit_class;

132: IGS_PS_UNIT_OFR_OPT.version_number = cp_version_number AND
133: IGS_PS_UNIT_OFR_OPT.cal_type= cp_cal_type AND
134: IGS_PS_UNIT_OFR_OPT.ci_sequence_number = cp_ci_sequence_number AND
135: IGS_PS_UNIT_OFR_OPT.location_cd = cp_location_cd AND
136: IGS_PS_UNIT_OFR_OPT.unit_class = cp_unit_class;
137: -- this cursor is used when unique key is passed
138: CURSOR c_unit_offering_option_uniq(
139: cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
140: SELECT *

Line 139: cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS

135: IGS_PS_UNIT_OFR_OPT.location_cd = cp_location_cd AND
136: IGS_PS_UNIT_OFR_OPT.unit_class = cp_unit_class;
137: -- this cursor is used when unique key is passed
138: CURSOR c_unit_offering_option_uniq(
139: cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
140: SELECT *
141: FROM IGS_PS_UNIT_OFR_OPT
142: WHERE IGS_PS_UNIT_OFR_OPT.uoo_id = cp_uoo_id;
143: BEGIN

Line 141: FROM IGS_PS_UNIT_OFR_OPT

137: -- this cursor is used when unique key is passed
138: CURSOR c_unit_offering_option_uniq(
139: cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
140: SELECT *
141: FROM IGS_PS_UNIT_OFR_OPT
142: WHERE IGS_PS_UNIT_OFR_OPT.uoo_id = cp_uoo_id;
143: BEGIN
144: -- This module returns IGS_PS_UNIT_OFR_OPT primary key
145: -- or unique key depending on the parameters

Line 142: WHERE IGS_PS_UNIT_OFR_OPT.uoo_id = cp_uoo_id;

138: CURSOR c_unit_offering_option_uniq(
139: cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
140: SELECT *
141: FROM IGS_PS_UNIT_OFR_OPT
142: WHERE IGS_PS_UNIT_OFR_OPT.uoo_id = cp_uoo_id;
143: BEGIN
144: -- This module returns IGS_PS_UNIT_OFR_OPT primary key
145: -- or unique key depending on the parameters
146: IF (p_unit_cd IS NOT NULL) THEN

Line 144: -- This module returns IGS_PS_UNIT_OFR_OPT primary key

140: SELECT *
141: FROM IGS_PS_UNIT_OFR_OPT
142: WHERE IGS_PS_UNIT_OFR_OPT.uoo_id = cp_uoo_id;
143: BEGIN
144: -- This module returns IGS_PS_UNIT_OFR_OPT primary key
145: -- or unique key depending on the parameters
146: IF (p_unit_cd IS NOT NULL) THEN
147: OPEN c_unit_offering_option_prim(p_unit_cd,
148: p_version_number,

Line 301: gv_uoo_rec igs_ps_unit_ofr_opt%ROWTYPE;

297: p_source_sequence_number igs_ca_inst.sequence_number%type;
298: p_dest_cal_type igs_ca_inst.cal_type%type;
299: p_dest_sequence_number igs_ca_inst.sequence_number%type;
300: gv_check VARCHAR2(1);
301: gv_uoo_rec igs_ps_unit_ofr_opt%ROWTYPE;
302: gv_cal_instance_rec igs_ca_inst%ROWTYPE;
303: gv_start_dt igs_ca_inst.start_dt%TYPE;
304: gv_end_dt igs_ca_inst.end_dt%TYPE;
305: gv_uv_rec igs_ps_unit_ver%ROWTYPE;

Line 570: -- insert IGS_PS_UNIT_OFR_OPT and IGS_AS_UNITASS_ITEM records for

566: END IF;
567: CLOSE gc_check_uop_exists;
568:
569: --Enhancement bug no 1800179
570: -- insert IGS_PS_UNIT_OFR_OPT and IGS_AS_UNITASS_ITEM records for
571: -- the IGS_PS_UNIT_OFR_PAT record
572: IF (igs_ps_gen_008.crsp_ins_uop_uoo( gv_uop_rec.unit_cd,
573: gv_uop_rec.version_number,
574: p_dest_cal_type,