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_CA_INST

Line 296: p_source_cal_type igs_ca_inst.cal_type%type ;

292: --shtatiko 3-FEB-2003 Bug# 2550411, Added code to log information wherever needed to make
293: -- log file more informative.
294: -------------------------------------------------------------------------------------------
295:
296: p_source_cal_type igs_ca_inst.cal_type%type ;
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);

Line 297: p_source_sequence_number igs_ca_inst.sequence_number%type;

293: -- log file more informative.
294: -------------------------------------------------------------------------------------------
295:
296: p_source_cal_type igs_ca_inst.cal_type%type ;
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;

Line 298: p_dest_cal_type igs_ca_inst.cal_type%type;

294: -------------------------------------------------------------------------------------------
295:
296: p_source_cal_type igs_ca_inst.cal_type%type ;
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;

Line 299: p_dest_sequence_number igs_ca_inst.sequence_number%type;

295:
296: p_source_cal_type igs_ca_inst.cal_type%type ;
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;

Line 302: gv_cal_instance_rec igs_ca_inst%ROWTYPE;

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;
306: gv_message VARCHAR2(255);

Line 303: gv_start_dt igs_ca_inst.start_dt%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;
306: gv_message VARCHAR2(255);
307: gv_rec_inserted_cnt NUMBER(4);

Line 304: gv_end_dt igs_ca_inst.end_dt%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;
306: gv_message VARCHAR2(255);
307: gv_rec_inserted_cnt NUMBER(4);
308: v_uop_identifier VARCHAR2(255);

Line 328: CURSOR gc_cal_instance_exists(cp_cal_type igs_ca_inst.cal_type%TYPE,

324: SELECT 'x'
325: FROM igs_ca_type
326: WHERE cal_type = p_source_cal_type;
327:
328: CURSOR gc_cal_instance_exists(cp_cal_type igs_ca_inst.cal_type%TYPE,
329: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS
330: SELECT *
331: FROM igs_ca_inst
332: WHERE cal_type = cp_cal_type

Line 329: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS

325: FROM igs_ca_type
326: WHERE cal_type = p_source_cal_type;
327:
328: CURSOR gc_cal_instance_exists(cp_cal_type igs_ca_inst.cal_type%TYPE,
329: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS
330: SELECT *
331: FROM igs_ca_inst
332: WHERE cal_type = cp_cal_type
333: AND sequence_number = cp_sequence_number;

Line 331: FROM igs_ca_inst

327:
328: CURSOR gc_cal_instance_exists(cp_cal_type igs_ca_inst.cal_type%TYPE,
329: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS
330: SELECT *
331: FROM igs_ca_inst
332: WHERE cal_type = cp_cal_type
333: AND sequence_number = cp_sequence_number;
334:
335: CURSOR gc_unit_offering_pattern IS

Line 379: l_start_dt igs_ca_inst.start_dt%TYPE;

375: x_rowid VARCHAR2(25);
376: INVALID EXCEPTION;
377: VALID EXCEPTION;
378:
379: l_start_dt igs_ca_inst.start_dt%TYPE;
380: l_end_dt igs_ca_inst.end_dt%TYPE;
381:
382: BEGIN
383:

Line 380: l_end_dt igs_ca_inst.end_dt%TYPE;

376: INVALID EXCEPTION;
377: VALID EXCEPTION;
378:
379: l_start_dt igs_ca_inst.start_dt%TYPE;
380: l_end_dt igs_ca_inst.end_dt%TYPE;
381:
382: BEGIN
383:
384: igs_ge_gen_003.set_org_id(p_org_id);