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_GE_DATE

Line 171: l_start_date := IGS_GE_DATE.IGSDATE(SUBSTR(p_term,12,10));

167:
168: IF p_term IS NOT NULL THEN
169: l_cal_type := TRIM(SUBSTR(p_term,1,10)) ;
170: l_seq_num := FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(p_term,-6)) ; --3338759: To get the 6-digit sequence number
171: l_start_date := IGS_GE_DATE.IGSDATE(SUBSTR(p_term,12,10));
172: ELSE
173: l_start_date := IGS_GE_DATE.IGSDATE(p_start_dt) ; /** Character to date conversion **/
174: END IF;
175:

Line 173: l_start_date := IGS_GE_DATE.IGSDATE(p_start_dt) ; / Character to date conversion /

169: l_cal_type := TRIM(SUBSTR(p_term,1,10)) ;
170: l_seq_num := FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(p_term,-6)) ; --3338759: To get the 6-digit sequence number
171: l_start_date := IGS_GE_DATE.IGSDATE(SUBSTR(p_term,12,10));
172: ELSE
173: l_start_date := IGS_GE_DATE.IGSDATE(p_start_dt) ; /** Character to date conversion **/
174: END IF;
175:
176: -- logs all the parameters
177: log_messages(RPAD(lookup_desc('IGS_PE_HOLDS','PERS_ID_GROUP'),20)||':',p_pid_group);

Line 187: log_messages(RPAD(lookup_desc('IGS_PE_HOLDS','START_DT'),20)||':',IGS_GE_DATE.IGSCHARDT(l_start_date));

183: log_messages(RPAD(lookup_desc('IGS_PE_HOLDS','CAL_TYPE'),20)||':',l_cal_type);
184: log_messages(RPAD(lookup_desc('IGS_PE_HOLDS','SEQ_NUM'),20)||':',l_seq_num);
185: END IF;
186:
187: log_messages(RPAD(lookup_desc('IGS_PE_HOLDS','START_DT'),20)||':',IGS_GE_DATE.IGSCHARDT(l_start_date));
188:
189: FND_FILE.NEW_LINE(FND_FILE.LOG,2); /** writes 2 new line characters **/
190:
191: -- if both start date and term parameters are passed as null , error out NOCOPY of the process

Line 254: RPAD(IGS_GE_DATE.IGSCHARDT(l_start_date),11) ;

250: RPAD(NVL(r_rec_query.full_name,' '),452) ||
251: RPAD(p_hold_type,12) ||
252: NVL(RPAD(l_cal_type,15),' ')||
253: NVL(RPAD(TO_CHAR(l_seq_num),17),' ')||
254: RPAD(IGS_GE_DATE.IGSCHARDT(l_start_date),11) ;
255: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_str_1);
256:
257: igs_pe_pers_encumb_pkg.insert_row
258: (

Line 437: l_start_date := IGS_GE_DATE.IGSDATE(SUBSTR(p_term,12,10));

433:
434: IF p_term IS NOT NULL THEN
435: l_cal_type := TRIM(SUBSTR(p_term,1,10)) ;
436: l_seq_num := FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(p_term,-6)); --3338759: To get the 6-digit sequence number
437: l_start_date := IGS_GE_DATE.IGSDATE(SUBSTR(p_term,12,10));
438: l_expiry_date := IGS_GE_DATE.IGSDATE(SUBSTR(p_term,23,10));
439: ELSE
440: l_start_date := IGS_GE_DATE.IGSDATE(p_start_dt) ; /** Character to date conversion **/
441: l_expiry_date := IGS_GE_DATE.IGSDATE(p_expiry_dt) ; /** Character to date conversion **/

Line 438: l_expiry_date := IGS_GE_DATE.IGSDATE(SUBSTR(p_term,23,10));

434: IF p_term IS NOT NULL THEN
435: l_cal_type := TRIM(SUBSTR(p_term,1,10)) ;
436: l_seq_num := FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(p_term,-6)); --3338759: To get the 6-digit sequence number
437: l_start_date := IGS_GE_DATE.IGSDATE(SUBSTR(p_term,12,10));
438: l_expiry_date := IGS_GE_DATE.IGSDATE(SUBSTR(p_term,23,10));
439: ELSE
440: l_start_date := IGS_GE_DATE.IGSDATE(p_start_dt) ; /** Character to date conversion **/
441: l_expiry_date := IGS_GE_DATE.IGSDATE(p_expiry_dt) ; /** Character to date conversion **/
442: END IF;

Line 440: l_start_date := IGS_GE_DATE.IGSDATE(p_start_dt) ; / Character to date conversion /

436: l_seq_num := FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(p_term,-6)); --3338759: To get the 6-digit sequence number
437: l_start_date := IGS_GE_DATE.IGSDATE(SUBSTR(p_term,12,10));
438: l_expiry_date := IGS_GE_DATE.IGSDATE(SUBSTR(p_term,23,10));
439: ELSE
440: l_start_date := IGS_GE_DATE.IGSDATE(p_start_dt) ; /** Character to date conversion **/
441: l_expiry_date := IGS_GE_DATE.IGSDATE(p_expiry_dt) ; /** Character to date conversion **/
442: END IF;
443:
444: -- logs all the parameters

Line 441: l_expiry_date := IGS_GE_DATE.IGSDATE(p_expiry_dt) ; / Character to date conversion /

437: l_start_date := IGS_GE_DATE.IGSDATE(SUBSTR(p_term,12,10));
438: l_expiry_date := IGS_GE_DATE.IGSDATE(SUBSTR(p_term,23,10));
439: ELSE
440: l_start_date := IGS_GE_DATE.IGSDATE(p_start_dt) ; /** Character to date conversion **/
441: l_expiry_date := IGS_GE_DATE.IGSDATE(p_expiry_dt) ; /** Character to date conversion **/
442: END IF;
443:
444: -- logs all the parameters
445: log_messages(RPAD(lookup_desc('IGS_PE_HOLDS','PERS_ID_GROUP'),20)||':',p_pid_group);

Line 455: log_messages(RPAD(lookup_desc('IGS_PE_HOLDS','START_DT'),20)||':',IGS_GE_DATE.IGSCHARDT(l_start_date));

451: log_messages(RPAD(lookup_desc('IGS_PE_HOLDS','CAL_TYPE'),20)||':',l_cal_type);
452: log_messages(RPAD(lookup_desc('IGS_PE_HOLDS','SEQ_NUM'),20)||':',l_seq_num);
453: END IF;
454:
455: log_messages(RPAD(lookup_desc('IGS_PE_HOLDS','START_DT'),20)||':',IGS_GE_DATE.IGSCHARDT(l_start_date));
456: log_messages(RPAD(lookup_desc('IGS_PE_HOLDS','EXPIRY_DT'),20)||':',IGS_GE_DATE.IGSCHARDT(l_expiry_date));
457: FND_FILE.NEW_LINE(FND_FILE.LOG,2); /** writes 2 new line characters **/
458:
459: -- if both start date and term parameters are passed as null , error out of the process

Line 456: log_messages(RPAD(lookup_desc('IGS_PE_HOLDS','EXPIRY_DT'),20)||':',IGS_GE_DATE.IGSCHARDT(l_expiry_date));

452: log_messages(RPAD(lookup_desc('IGS_PE_HOLDS','SEQ_NUM'),20)||':',l_seq_num);
453: END IF;
454:
455: log_messages(RPAD(lookup_desc('IGS_PE_HOLDS','START_DT'),20)||':',IGS_GE_DATE.IGSCHARDT(l_start_date));
456: log_messages(RPAD(lookup_desc('IGS_PE_HOLDS','EXPIRY_DT'),20)||':',IGS_GE_DATE.IGSCHARDT(l_expiry_date));
457: FND_FILE.NEW_LINE(FND_FILE.LOG,2); /** writes 2 new line characters **/
458:
459: -- if both start date and term parameters are passed as null , error out of the process
460: IF ((p_start_dt IS NULL OR p_expiry_dt IS NULL) AND p_term IS NULL) THEN