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_NOTE_TYPE_PKG dependencies on IGS_PS_NOTE_TYPE_ALL

Line 5: old_references IGS_PS_NOTE_TYPE_ALL%RowType;

1: package body IGS_PS_NOTE_TYPE_PKG AS
2: /* $Header: IGSPI48B.pls 120.3 2006/01/27 02:51:50 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_NOTE_TYPE_ALL%RowType;
6: new_references IGS_PS_NOTE_TYPE_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_NOTE_TYPE_ALL%RowType;

2: /* $Header: IGSPI48B.pls 120.3 2006/01/27 02:51:50 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_NOTE_TYPE_ALL%RowType;
6: new_references IGS_PS_NOTE_TYPE_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_PS_NOTE_TYPE_ALL

19: ) AS
20:
21: CURSOR cur_old_ref_values IS
22: SELECT *
23: FROM IGS_PS_NOTE_TYPE_ALL
24: WHERE rowid = x_rowid;
25:
26: BEGIN
27:

Line 126: FROM IGS_PS_NOTE_TYPE_ALL

122: ) RETURN BOOLEAN AS
123:
124: CURSOR cur_rowid IS
125: SELECT rowid
126: FROM IGS_PS_NOTE_TYPE_ALL
127: WHERE crs_note_type = x_crs_note_type
128: FOR UPDATE NOWAIT;
129:
130: lv_rowid cur_rowid%RowType;

Line 226: cursor C is select ROWID from IGS_PS_NOTE_TYPE_ALL

222: X_DESCRIPTION in VARCHAR2,
223: X_MODE in VARCHAR2 default 'R',
224: X_ORG_ID IN NUMBER
225: ) AS
226: cursor C is select ROWID from IGS_PS_NOTE_TYPE_ALL
227: where CRS_NOTE_TYPE = X_CRS_NOTE_TYPE;
228: X_LAST_UPDATE_DATE DATE;
229: X_LAST_UPDATED_BY NUMBER;
230: X_LAST_UPDATE_LOGIN NUMBER;

Line 263: insert into IGS_PS_NOTE_TYPE_ALL (

259: x_last_update_login => X_LAST_UPDATE_LOGIN,
260: x_org_id => igs_ge_gen_003.get_org_id
261: );
262:
263: insert into IGS_PS_NOTE_TYPE_ALL (
264: CRS_NOTE_TYPE,
265: DESCRIPTION,
266: CREATION_DATE,
267: CREATED_BY,

Line 303: from IGS_PS_NOTE_TYPE_ALL

299: X_DESCRIPTION in VARCHAR2
300: ) AS
301: cursor c1 is select
302: DESCRIPTION
303: from IGS_PS_NOTE_TYPE_ALL
304: where ROWID = X_ROWID for update nowait;
305: tlinfo c1%rowtype;
306:
307: begin

Line 370: update IGS_PS_NOTE_TYPE_ALL set

366: x_last_updated_by => X_LAST_UPDATED_BY,
367: x_last_update_login => X_LAST_UPDATE_LOGIN
368: );
369:
370: update IGS_PS_NOTE_TYPE_ALL set
371: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
372: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
373: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
374: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 392: cursor c1 is select rowid from IGS_PS_NOTE_TYPE_ALL

388: X_DESCRIPTION in VARCHAR2,
389: X_MODE in VARCHAR2 default 'R',
390: X_ORG_ID IN NUMBER
391: ) AS
392: cursor c1 is select rowid from IGS_PS_NOTE_TYPE_ALL
393: where CRS_NOTE_TYPE = X_CRS_NOTE_TYPE
394: ;
395: begin
396: open c1;

Line 423: delete from IGS_PS_NOTE_TYPE_ALL

419: begin
420: Before_DML (p_action => 'DELETE',
421: x_rowid => X_ROWID
422: );
423: delete from IGS_PS_NOTE_TYPE_ALL
424: where ROWID = X_ROWID;
425: if (sql%notfound) then
426: raise no_data_found;
427: end if;

Line 446: CURSOR c_igs_ps_note_type_all(cp_crs_note_type VARCHAR2) IS

442: f_ludate date; -- entity update date in file
443: db_luby number; -- entity owner in db
444: db_ludate date; -- entity update date in db
445:
446: CURSOR c_igs_ps_note_type_all(cp_crs_note_type VARCHAR2) IS
447: SELECT last_updated_by, last_update_date
448: FROM igs_ps_note_type_all
449: WHERE crs_note_type = cp_crs_note_type;
450:

Line 448: FROM igs_ps_note_type_all

444: db_ludate date; -- entity update date in db
445:
446: CURSOR c_igs_ps_note_type_all(cp_crs_note_type VARCHAR2) IS
447: SELECT last_updated_by, last_update_date
448: FROM igs_ps_note_type_all
449: WHERE crs_note_type = cp_crs_note_type;
450:
451:
452: BEGIN

Line 461: OPEN c_igs_ps_note_type_all(x_crs_note_type);

457: -- Translate char last_update_date to date
458: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
459:
460:
461: OPEN c_igs_ps_note_type_all(x_crs_note_type);
462: FETCH c_igs_ps_note_type_all INTO db_luby, db_ludate;
463: IF c_igs_ps_note_type_all%FOUND THEN
464: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
465: db_ludate, x_custom_mode)) THEN

Line 462: FETCH c_igs_ps_note_type_all INTO db_luby, db_ludate;

458: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
459:
460:
461: OPEN c_igs_ps_note_type_all(x_crs_note_type);
462: FETCH c_igs_ps_note_type_all INTO db_luby, db_ludate;
463: IF c_igs_ps_note_type_all%FOUND THEN
464: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
465: db_ludate, x_custom_mode)) THEN
466:

Line 463: IF c_igs_ps_note_type_all%FOUND THEN

459:
460:
461: OPEN c_igs_ps_note_type_all(x_crs_note_type);
462: FETCH c_igs_ps_note_type_all INTO db_luby, db_ludate;
463: IF c_igs_ps_note_type_all%FOUND THEN
464: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
465: db_ludate, x_custom_mode)) THEN
466:
467:

Line 468: UPDATE IGS_PS_NOTE_TYPE_ALL SET

464: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
465: db_ludate, x_custom_mode)) THEN
466:
467:
468: UPDATE IGS_PS_NOTE_TYPE_ALL SET
469: description = x_description,
470: last_updated_by = f_luby,
471: last_update_date = f_ludate,
472: last_update_login = 0

Line 477: INSERT INTO IGS_PS_NOTE_TYPE_ALL

473: WHERE crs_note_type = x_crs_note_type;
474:
475: END IF;
476: ELSE
477: INSERT INTO IGS_PS_NOTE_TYPE_ALL
478: (
479: CRS_NOTE_TYPE,
480: DESCRIPTION,
481: CREATED_BY,

Line 498: CLOSE c_igs_ps_note_type_all;

494: f_ludate,
495: 0
496: );
497: END IF;
498: CLOSE c_igs_ps_note_type_all;
499:
500: END LOAD_ROW;
501:
502: