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_PE_SET_REM_HOLDS dependencies on IGS_CA_INST

Line 128: l_cal_type igs_ca_inst.cal_type%TYPE ;

124: --gmaheswa 29-OCT-2003 Bug 3198795 Introducing DYNAMIC PERSON ID group functionality
125: --asbala 5-JAN-2003 3338759, Changes mentioned along with bug no. in corresponding places
126: --skpandey 02-FEB-2006 Bug#4937960: Changed call to igs_get_dynamic_sql to get_dynamic_sql as a part of literal fix
127: -------------------------------------------------------------------
128: l_cal_type igs_ca_inst.cal_type%TYPE ;
129: l_seq_num igs_ca_inst.sequence_number%TYPE ;
130: l_start_date igs_ca_inst.start_dt%TYPE ;
131: l_rowid igs_pe_prsid_grp_mem.row_id%TYPE;
132: l_message_name VARCHAR2(30) ;

Line 129: l_seq_num igs_ca_inst.sequence_number%TYPE ;

125: --asbala 5-JAN-2003 3338759, Changes mentioned along with bug no. in corresponding places
126: --skpandey 02-FEB-2006 Bug#4937960: Changed call to igs_get_dynamic_sql to get_dynamic_sql as a part of literal fix
127: -------------------------------------------------------------------
128: l_cal_type igs_ca_inst.cal_type%TYPE ;
129: l_seq_num igs_ca_inst.sequence_number%TYPE ;
130: l_start_date igs_ca_inst.start_dt%TYPE ;
131: l_rowid igs_pe_prsid_grp_mem.row_id%TYPE;
132: l_message_name VARCHAR2(30) ;
133: l_message_string VARCHAR2(900) ;

Line 130: l_start_date igs_ca_inst.start_dt%TYPE ;

126: --skpandey 02-FEB-2006 Bug#4937960: Changed call to igs_get_dynamic_sql to get_dynamic_sql as a part of literal fix
127: -------------------------------------------------------------------
128: l_cal_type igs_ca_inst.cal_type%TYPE ;
129: l_seq_num igs_ca_inst.sequence_number%TYPE ;
130: l_start_date igs_ca_inst.start_dt%TYPE ;
131: l_rowid igs_pe_prsid_grp_mem.row_id%TYPE;
132: l_message_name VARCHAR2(30) ;
133: l_message_string VARCHAR2(900) ;
134: l_msg_str_0 VARCHAR2(1000) ;

Line 378: l_cal_type igs_ca_inst.cal_type%TYPE ;

374: --skpandey 12-JAN-2006 Bug#4937960
375: -- Changed c_igs_pe_pers_encumb Cursor definition to optimize query
376: --skpandey 02-FEB-2006 Bug#4937960: Changed call to igs_get_dynamic_sql to get_dynamic_sql as a part of literal fix
377: -------------------------------------------------------------------
378: l_cal_type igs_ca_inst.cal_type%TYPE ;
379: l_seq_num igs_ca_inst.sequence_number%TYPE ;
380: l_start_date igs_ca_inst.start_dt%TYPE ;
381: l_expiry_date igs_ca_inst.start_dt%TYPE ;
382: l_rowid igs_pe_prsid_grp_mem.row_id%TYPE;

Line 379: l_seq_num igs_ca_inst.sequence_number%TYPE ;

375: -- Changed c_igs_pe_pers_encumb Cursor definition to optimize query
376: --skpandey 02-FEB-2006 Bug#4937960: Changed call to igs_get_dynamic_sql to get_dynamic_sql as a part of literal fix
377: -------------------------------------------------------------------
378: l_cal_type igs_ca_inst.cal_type%TYPE ;
379: l_seq_num igs_ca_inst.sequence_number%TYPE ;
380: l_start_date igs_ca_inst.start_dt%TYPE ;
381: l_expiry_date igs_ca_inst.start_dt%TYPE ;
382: l_rowid igs_pe_prsid_grp_mem.row_id%TYPE;
383: l_message_name VARCHAR2(30);

Line 380: l_start_date igs_ca_inst.start_dt%TYPE ;

376: --skpandey 02-FEB-2006 Bug#4937960: Changed call to igs_get_dynamic_sql to get_dynamic_sql as a part of literal fix
377: -------------------------------------------------------------------
378: l_cal_type igs_ca_inst.cal_type%TYPE ;
379: l_seq_num igs_ca_inst.sequence_number%TYPE ;
380: l_start_date igs_ca_inst.start_dt%TYPE ;
381: l_expiry_date igs_ca_inst.start_dt%TYPE ;
382: l_rowid igs_pe_prsid_grp_mem.row_id%TYPE;
383: l_message_name VARCHAR2(30);
384: l_message_string VARCHAR2(900);

Line 381: l_expiry_date igs_ca_inst.start_dt%TYPE ;

377: -------------------------------------------------------------------
378: l_cal_type igs_ca_inst.cal_type%TYPE ;
379: l_seq_num igs_ca_inst.sequence_number%TYPE ;
380: l_start_date igs_ca_inst.start_dt%TYPE ;
381: l_expiry_date igs_ca_inst.start_dt%TYPE ;
382: l_rowid igs_pe_prsid_grp_mem.row_id%TYPE;
383: l_message_name VARCHAR2(30);
384: l_message_string VARCHAR2(900);
385: l_msg_str_0 VARCHAR2(1000);