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_OFFICE_HRS_PKG dependencies on IGS_PE_OFFICE_HRS

Line 1: PACKAGE BODY igs_pe_office_hrs_pkg AS

1: PACKAGE BODY igs_pe_office_hrs_pkg AS
2: /* $Header: IGSNIB3B.pls 120.1 2005/06/28 06:07:07 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_office_hrs%ROWTYPE;

Line 5: old_references igs_pe_office_hrs%ROWTYPE;

1: PACKAGE BODY igs_pe_office_hrs_pkg AS
2: /* $Header: IGSNIB3B.pls 120.1 2005/06/28 06:07:07 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_office_hrs%ROWTYPE;
6: new_references igs_pe_office_hrs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_office_hrs%ROWTYPE;

2: /* $Header: IGSNIB3B.pls 120.1 2005/06/28 06:07:07 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_office_hrs%ROWTYPE;
6: new_references igs_pe_office_hrs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 34: FROM igs_pe_office_hrs

30: */
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM igs_pe_office_hrs
35: WHERE rowid = x_rowid;
36:
37: BEGIN
38:

Line 78: p_contact_preference_id IN igs_pe_office_hrs.CONTACT_PREFERENCE_ID%type,

74:
75:
76:
77: PROCEDURE validate_overlap (
78: p_contact_preference_id IN igs_pe_office_hrs.CONTACT_PREFERENCE_ID%type,
79: p_day_of_week_code IN igs_pe_office_hrs.day_of_week_code%TYPE,
80: p_start_tm_date IN DATE,
81: p_end_tm_date IN DATE,
82: P_OFFID NUMBER) AS

Line 79: p_day_of_week_code IN igs_pe_office_hrs.day_of_week_code%TYPE,

75:
76:
77: PROCEDURE validate_overlap (
78: p_contact_preference_id IN igs_pe_office_hrs.CONTACT_PREFERENCE_ID%type,
79: p_day_of_week_code IN igs_pe_office_hrs.day_of_week_code%TYPE,
80: p_start_tm_date IN DATE,
81: p_end_tm_date IN DATE,
82: P_OFFID NUMBER) AS
83: /*

Line 95: CURSOR c_overlap (cp_contact_preference_id igs_pe_office_hrs.CONTACT_PREFERENCE_ID%type,

91: || pkpatel 18-JUL-2003 Bug 3026057
92: || Consider only the time component in the overlap check
93: */
94:
95: CURSOR c_overlap (cp_contact_preference_id igs_pe_office_hrs.CONTACT_PREFERENCE_ID%type,
96: cp_day_of_week_code igs_pe_office_hrs.day_of_week_code%TYPE,
97: cp_start_tm_date DATE,
98: cp_end_tm_date DATE,
99: cp_offid NUMBER) IS

Line 96: cp_day_of_week_code igs_pe_office_hrs.day_of_week_code%TYPE,

92: || Consider only the time component in the overlap check
93: */
94:
95: CURSOR c_overlap (cp_contact_preference_id igs_pe_office_hrs.CONTACT_PREFERENCE_ID%type,
96: cp_day_of_week_code igs_pe_office_hrs.day_of_week_code%TYPE,
97: cp_start_tm_date DATE,
98: cp_end_tm_date DATE,
99: cp_offid NUMBER) IS
100: SELECT count(1)

Line 101: FROM igs_pe_office_hrs

97: cp_start_tm_date DATE,
98: cp_end_tm_date DATE,
99: cp_offid NUMBER) IS
100: SELECT count(1)
101: FROM igs_pe_office_hrs
102: WHERE contact_preference_id = cp_contact_preference_id AND
103: (CP_OFFID <> OFFICE_HRS_ID OR CP_OFFID IS NULL) AND
104: day_of_week_code = cp_day_of_week_code AND
105: ( TO_DATE(TO_CHAR(end_tm_date,'HH24:MI'),'HH24:MI') > cp_start_tm_date OR TO_DATE(TO_CHAR(end_tm_date,'HH24:MI'),'HH24:MI') >= cp_end_tm_date) AND

Line 185: FROM IGS_PE_OFFICE_HRS

181: || (reverse chronological order - newest change first)
182: */
183: CURSOR cur_rowid IS
184: SELECT rowid
185: FROM IGS_PE_OFFICE_HRS
186: WHERE office_hrs_id = x_office_hrs_id
187: FOR UPDATE NOWAIT;
188:
189: lv_rowid cur_rowid%RowType;

Line 387: fnd_message.set_token ('ROUTINE', 'IGS_PE_OFFICE_HRS_PKG.INSERT_ROW');

383: x_last_update_login := -1;
384: END IF;
385: ELSE
386: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
387: fnd_message.set_token ('ROUTINE', 'IGS_PE_OFFICE_HRS_PKG.INSERT_ROW');
388: igs_ge_msg_stack.add;
389: app_exception.raise_exception;
390: END IF;
391:

Line 412: INSERT INTO igs_pe_office_hrs (

408:
409: IF (x_mode = 'S') THEN
410: igs_sc_gen_001.set_ctx('R');
411: END IF;
412: INSERT INTO igs_pe_office_hrs (
413: office_hrs_id,
414: contact_preference_id,
415: day_of_week_code,
416: start_tm_date,

Line 424: igs_pe_office_hrs_s.NEXTVAL,

420: last_update_date,
421: last_updated_by,
422: last_update_login
423: ) VALUES (
424: igs_pe_office_hrs_s.NEXTVAL,
425: new_references.contact_preference_id,
426: new_references.day_of_week_code,
427: new_references.start_tm_date,
428: new_references.end_tm_date,

Line 483: FROM igs_pe_office_hrs

479: contact_preference_id,
480: day_of_week_code,
481: start_tm_date,
482: end_tm_date
483: FROM igs_pe_office_hrs
484: WHERE rowid = x_rowid
485: FOR UPDATE NOWAIT;
486:
487: tlinfo c1%ROWTYPE;

Line 560: fnd_message.set_token ('ROUTINE', 'IGS_PE_OFFICE_HRS_PKG.UPDATE_ROW');

556: x_last_update_login := -1;
557: END IF;
558: ELSE
559: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
560: fnd_message.set_token ('ROUTINE', 'IGS_PE_OFFICE_HRS_PKG.UPDATE_ROW');
561: igs_ge_msg_stack.add;
562: app_exception.raise_exception;
563: END IF;
564:

Line 585: UPDATE igs_pe_office_hrs

581:
582: IF (x_mode = 'S') THEN
583: igs_sc_gen_001.set_ctx('R');
584: END IF;
585: UPDATE igs_pe_office_hrs
586: SET
587: office_hrs_id = new_references.office_hrs_id,
588: contact_preference_id = new_references.contact_preference_id,
589: day_of_week_code = new_references.day_of_week_code,

Line 645: FROM igs_pe_office_hrs

641: || (reverse chronological order - newest change first)
642: */
643: CURSOR c1 IS
644: SELECT rowid
645: FROM igs_pe_office_hrs
646: WHERE office_hrs_id= x_office_hrs_id;
647:
648: BEGIN
649:

Line 704: DELETE FROM igs_pe_office_hrs

700:
701: IF (x_mode = 'S') THEN
702: igs_sc_gen_001.set_ctx('R');
703: END IF;
704: DELETE FROM igs_pe_office_hrs
705: WHERE rowid = x_rowid;
706:
707: IF (SQL%NOTFOUND) THEN
708: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 829: FROM igs_pe_office_hrs

825: contact_preference_id,
826: day_of_week_code,
827: to_char(start_tm_date,'HH24:MI') start_tm_date,
828: to_char(end_tm_date,'HH24:MI') end_tm_date
829: FROM igs_pe_office_hrs
830: WHERE rowid = x_rowid
831: FOR UPDATE NOWAIT;
832:
833: tlinfo c1%ROWTYPE;

Line 866: END igs_pe_office_hrs_pkg;

862: RETURN;
863:
864: END lock_row_ss;
865:
866: END igs_pe_office_hrs_pkg;