APPS.IGS_OR_ORG_ACCR_DTLS_PKG dependencies on IGS_OR_ORG_ACCR_DTLS

Line 1: PACKAGE BODY igs_or_org_accr_dtls_pkg AS

1: PACKAGE BODY igs_or_org_accr_dtls_pkg AS
2: /* $Header: IGSOI21B.pls 115.9 2003/10/30 13:30:01 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_or_org_accr_dtls%RowType;
5: new_references igs_or_org_accr_dtls%RowType;

Line 4: old_references igs_or_org_accr_dtls%RowType;

1: PACKAGE BODY igs_or_org_accr_dtls_pkg AS
2: /* $Header: IGSOI21B.pls 115.9 2003/10/30 13:30:01 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_or_org_accr_dtls%RowType;
5: new_references igs_or_org_accr_dtls%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_or_org_accr_dtls%RowType;

1: PACKAGE BODY igs_or_org_accr_dtls_pkg AS
2: /* $Header: IGSOI21B.pls 115.9 2003/10/30 13:30:01 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_or_org_accr_dtls%RowType;
5: new_references igs_or_org_accr_dtls%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2,

Line 36: FROM IGS_OR_ORG_ACCR_DTLS

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

Line 190: FROM igs_or_org_accr_dtls

186: ***************************************************************/
187:
188: CURSOR cur_rowid IS
189: SELECT rowid
190: FROM igs_or_org_accr_dtls
191: WHERE org_accr_status = x_org_accr_status
192: AND org_agency_id = x_org_agency_id
193: AND org_structure_id = x_org_structure_id
194: AND org_structure_type = x_org_structure_type

Line 230: FROM igs_or_org_accr_dtls

226: ***************************************************************/
227:
228: CURSOR cur_rowid IS
229: SELECT rowid
230: FROM igs_or_org_accr_dtls
231: WHERE org_accr_status = x_org_accr_status ;
232:
233: lv_rowid cur_rowid%RowType;
234:

Line 267: FROM igs_or_org_accr_dtls

263: ***************************************************************/
264:
265: CURSOR cur_rowid IS
266: SELECT rowid
267: FROM igs_or_org_accr_dtls
268: WHERE org_agency_id = x_institution_cd ;
269:
270: lv_rowid cur_rowid%RowType;
271:

Line 293: FROM IGS_OR_ORG_ACCR_DTLS

289: x_org_unit_cd IN VARCHAR2
290: ) AS
291: CURSOR cur_rowid IS
292: SELECT ROWID
293: FROM IGS_OR_ORG_ACCR_DTLS
294: WHERE org_structure_id = x_org_unit_cd ;
295: lv_rowid cur_rowid%ROWTYPE;
296: BEGIN
297: OPEN cur_rowid;

Line 451: cursor C is select ROWID from IGS_OR_ORG_ACCR_DTLS

447:
448: (reverse chronological order - newest change first)
449: ***************************************************************/
450:
451: cursor C is select ROWID from IGS_OR_ORG_ACCR_DTLS
452: where ORG_ACCR_STATUS= X_ORG_ACCR_STATUS
453: and ORG_AGENCY_ID = X_ORG_AGENCY_ID
454: and ORG_STRUCTURE_ID = X_ORG_STRUCTURE_ID
455: and ORG_STRUCTURE_TYPE = X_ORG_STRUCTURE_TYPE

Line 494: insert into IGS_OR_ORG_ACCR_DTLS (

490: x_created_by=>X_LAST_UPDATED_BY,
491: x_last_update_date=>X_LAST_UPDATE_DATE,
492: x_last_updated_by=>X_LAST_UPDATED_BY,
493: x_last_update_login=>X_LAST_UPDATE_LOGIN);
494: insert into IGS_OR_ORG_ACCR_DTLS (
495: ORG_STRUCTURE_ID
496: ,ORG_STRUCTURE_TYPE
497: ,ORG_AGENCY_ID
498: ,ORG_ACCR_STATUS

Line 552: from IGS_OR_ORG_ACCR_DTLS

548: ***************************************************************/
549:
550: cursor c1 is select
551: END_DATE
552: from IGS_OR_ORG_ACCR_DTLS
553: where ROWID = X_ROWID
554: for update nowait;
555: tlinfo c1%rowtype;
556: begin

Line 636: update IGS_OR_ORG_ACCR_DTLS set

632: x_created_by=>X_LAST_UPDATED_BY,
633: x_last_update_date=>X_LAST_UPDATE_DATE,
634: x_last_updated_by=>X_LAST_UPDATED_BY,
635: x_last_update_login=>X_LAST_UPDATE_LOGIN);
636: update IGS_OR_ORG_ACCR_DTLS set
637: END_DATE = NEW_REFERENCES.END_DATE,
638: ORG_AGENCY_ID= NEW_REFERENCES.ORG_AGENCY_ID,
639: ORG_ACCR_STATUS=NEW_REFERENCES.ORG_ACCR_STATUS,
640: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 675: cursor c1 is select ROWID from IGS_OR_ORG_ACCR_DTLS

671:
672: (reverse chronological order - newest change first)
673: ***************************************************************/
674:
675: cursor c1 is select ROWID from IGS_OR_ORG_ACCR_DTLS
676: where ORG_ACCR_STATUS= X_ORG_ACCR_STATUS
677: and ORG_AGENCY_ID = X_ORG_AGENCY_ID
678: and ORG_STRUCTURE_ID = X_ORG_STRUCTURE_ID
679: and ORG_STRUCTURE_TYPE = X_ORG_STRUCTURE_TYPE

Line 729: delete from IGS_OR_ORG_ACCR_DTLS

725: Before_DML (
726: p_action => 'DELETE',
727: x_rowid => X_ROWID
728: );
729: delete from IGS_OR_ORG_ACCR_DTLS
730: where ROWID = X_ROWID;
731: if (sql%notfound) then
732: raise no_data_found;
733: end if;

Line 739: END igs_or_org_accr_dtls_pkg;

735: p_action => 'DELETE',
736: x_rowid => X_ROWID
737: );
738: end DELETE_ROW;
739: END igs_or_org_accr_dtls_pkg;