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.

[Home] [Help]

APPS.IGS_OR_ORG_ALT_IDS_PKG dependencies on IGS_OR_ORG_ALT_IDS

Line 1: PACKAGE BODY igs_or_org_alt_ids_pkg AS

1: PACKAGE BODY igs_or_org_alt_ids_pkg AS
2: /* $Header: IGSOI22B.pls 120.1 2006/03/28 09:12:42 skpandey noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_or_org_alt_ids%RowType;
5: new_references igs_or_org_alt_ids%RowType;

Line 4: old_references igs_or_org_alt_ids%RowType;

1: PACKAGE BODY igs_or_org_alt_ids_pkg AS
2: /* $Header: IGSOI22B.pls 120.1 2006/03/28 09:12:42 skpandey noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_or_org_alt_ids%RowType;
5: new_references igs_or_org_alt_ids%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_or_org_alt_ids%RowType;

1: PACKAGE BODY igs_or_org_alt_ids_pkg AS
2: /* $Header: IGSOI22B.pls 120.1 2006/03/28 09:12:42 skpandey noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_or_org_alt_ids%RowType;
5: new_references igs_or_org_alt_ids%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 37: FROM IGS_OR_ORG_ALT_IDS

33: ***************************************************************/
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM IGS_OR_ORG_ALT_IDS
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 180: FROM igs_or_org_alt_ids

176: ***************************************************************/
177:
178: CURSOR cur_rowid IS
179: SELECT rowid
180: FROM igs_or_org_alt_ids
181: WHERE org_alternate_id = x_org_alternate_id
182: AND org_alternate_id_type = x_org_alternate_id_type
183: AND org_structure_id = x_org_structure_id
184: AND org_structure_type = x_org_structure_type

Line 223: FROM igs_or_org_alt_ids

219: ***************************************************************/
220:
221: CURSOR cur_rowid IS
222: SELECT rowid
223: FROM igs_or_org_alt_ids
224: WHERE org_alternate_id_type = x_org_alternate_id_type ;
225:
226: lv_rowid cur_rowid%RowType;
227:

Line 261: FROM IGS_OR_ORG_ALT_IDS

257: x_institution_cd IN VARCHAR2
258: ) AS
259: CURSOR cur_rowid IS
260: SELECT ROWID
261: FROM IGS_OR_ORG_ALT_IDS
262: WHERE (
263: (org_structure_id = x_institution_cd) AND (org_structure_type = 'INSTITUTE')
264: );
265: lv_rowid cur_rowid%ROWTYPE;

Line 297: FROM IGS_OR_ORG_ALT_IDS

293: x_org_unit_cd IN VARCHAR2
294: ) AS
295: CURSOR cur_rowid IS
296: SELECT ROWID
297: FROM IGS_OR_ORG_ALT_IDS
298: WHERE (
299: (org_structure_id = x_org_unit_cd) AND (org_structure_type = 'ORG_UNIT')
300: );
301:

Line 466: cursor C is select ROWID from IGS_OR_ORG_ALT_IDS

462:
463: (reverse chronological order - newest change first)
464: ***************************************************************/
465:
466: cursor C is select ROWID from IGS_OR_ORG_ALT_IDS
467: where ORG_ALTERNATE_ID= X_ORG_ALTERNATE_ID
468: and ORG_ALTERNATE_ID_TYPE = X_ORG_ALTERNATE_ID_TYPE
469: and ORG_STRUCTURE_ID = X_ORG_STRUCTURE_ID
470: and ORG_STRUCTURE_TYPE = X_ORG_STRUCTURE_TYPE

Line 509: insert into IGS_OR_ORG_ALT_IDS (

505: x_created_by=>X_LAST_UPDATED_BY,
506: x_last_update_date=>X_LAST_UPDATE_DATE,
507: x_last_updated_by=>X_LAST_UPDATED_BY,
508: x_last_update_login=>X_LAST_UPDATE_LOGIN);
509: insert into IGS_OR_ORG_ALT_IDS (
510: ORG_STRUCTURE_ID
511: ,ORG_STRUCTURE_TYPE
512: ,ORG_ALTERNATE_ID_TYPE
513: ,ORG_ALTERNATE_ID

Line 567: from IGS_OR_ORG_ALT_IDS

563: ***************************************************************/
564:
565: cursor c1 is select
566: END_DATE
567: from IGS_OR_ORG_ALT_IDS
568: where ROWID = X_ROWID
569: for update nowait;
570: tlinfo c1%rowtype;
571: begin

Line 654: update IGS_OR_ORG_ALT_IDS set

650: x_created_by=>X_LAST_UPDATED_BY,
651: x_last_update_date=>X_LAST_UPDATE_DATE,
652: x_last_updated_by=>X_LAST_UPDATED_BY,
653: x_last_update_login=>X_LAST_UPDATE_LOGIN);
654: update IGS_OR_ORG_ALT_IDS set
655: END_DATE = NEW_REFERENCES.END_DATE,
656: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
657: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
658: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 693: cursor c1 is select ROWID from IGS_OR_ORG_ALT_IDS

689:
690: (reverse chronological order - newest change first)
691: ***************************************************************/
692:
693: cursor c1 is select ROWID from IGS_OR_ORG_ALT_IDS
694: where ORG_ALTERNATE_ID= X_ORG_ALTERNATE_ID
695: and ORG_ALTERNATE_ID_TYPE = X_ORG_ALTERNATE_ID_TYPE
696: and ORG_STRUCTURE_ID = X_ORG_STRUCTURE_ID
697: and ORG_STRUCTURE_TYPE = X_ORG_STRUCTURE_TYPE

Line 750: FROM igs_or_org_alt_ids

746: FROM igs_or_cwlk_dtl
747: WHERE alt_id_type = cp_org_alt_id_typ
748: AND alt_id_value = cp_alt_id_val
749: AND NOT EXISTS ( SELECT 1
750: FROM igs_or_org_alt_ids
751: WHERE org_alternate_id_type = alt_id_type
752: AND org_alternate_id = alt_id_value
753: AND rowid <> cp_rowid);
754: l_row_id ROWID;

Line 766: delete from IGS_OR_ORG_ALT_IDS

762: OPEN cur_get_rowid(old_references.org_alternate_id_type, old_references.org_alternate_id, X_ROWID );
763: FETCH cur_get_rowid INTO l_row_id;
764: CLOSE cur_get_rowid;
765:
766: delete from IGS_OR_ORG_ALT_IDS
767: where ROWID = X_ROWID;
768: if (sql%notfound) then
769: raise no_data_found;
770: end if;

Line 782: END igs_or_org_alt_ids_pkg;

778: END IF;
779:
780: END DELETE_ROW;
781:
782: END igs_or_org_alt_ids_pkg;