APPS.IGS_PS_USEC_SPNSRSHP_PKG dependencies on IGS_PS_USEC_SPNSRSHP

Line 1: PACKAGE BODY igs_ps_usec_spnsrshp_pkg AS

1: PACKAGE BODY igs_ps_usec_spnsrshp_pkg AS
2: /* $Header: IGSPI1DB.pls 115.8 2003/03/21 08:04:56 sarakshi ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_spnsrshp%RowType;
5: new_references igs_ps_usec_spnsrshp%RowType;

Line 4: old_references igs_ps_usec_spnsrshp%RowType;

1: PACKAGE BODY igs_ps_usec_spnsrshp_pkg AS
2: /* $Header: IGSPI1DB.pls 115.8 2003/03/21 08:04:56 sarakshi ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_spnsrshp%RowType;
5: new_references igs_ps_usec_spnsrshp%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_usec_spnsrshp%RowType;

1: PACKAGE BODY igs_ps_usec_spnsrshp_pkg AS
2: /* $Header: IGSPI1DB.pls 115.8 2003/03/21 08:04:56 sarakshi ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_spnsrshp%RowType;
5: new_references igs_ps_usec_spnsrshp%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM IGS_PS_USEC_SPNSRSHP

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

Line 169: FROM igs_ps_usec_spnsrshp

165: ***************************************************************/
166:
167: CURSOR cur_rowid IS
168: SELECT rowid
169: FROM igs_ps_usec_spnsrshp
170: WHERE unit_section_sponsorship_id = x_unit_section_sponsorship_id
171: FOR UPDATE NOWAIT;
172:
173: lv_rowid cur_rowid%RowType;

Line 206: FROM igs_ps_usec_spnsrshp

202: ***************************************************************/
203:
204: CURSOR cur_rowid IS
205: SELECT rowid
206: FROM igs_ps_usec_spnsrshp
207: WHERE uoo_id = x_uoo_id and organization_code = x_organization_code and ((l_rowid is null) or (rowid <> l_rowid))
208:
209: ;
210: lv_rowid cur_rowid%RowType;

Line 241: FROM igs_ps_usec_spnsrshp

237: ***************************************************************/
238:
239: CURSOR cur_rowid IS
240: SELECT rowid
241: FROM igs_ps_usec_spnsrshp
242: WHERE uoo_id = x_uoo_id ;
243:
244: lv_rowid cur_rowid%RowType;
245:

Line 396: cursor C is select ROWID from IGS_PS_USEC_SPNSRSHP

392:
393: (reverse chronological order - newest change first)
394: ***************************************************************/
395:
396: cursor C is select ROWID from IGS_PS_USEC_SPNSRSHP
397: where UNIT_SECTION_SPONSORSHIP_ID= X_UNIT_SECTION_SPONSORSHIP_ID
398: ;
399: X_LAST_UPDATE_DATE DATE ;
400: X_LAST_UPDATED_BY NUMBER ;

Line 423: IGS_PS_USEC_SPNSRSHP_S.NEXTVAL

419: app_exception.raise_exception;
420: end if;
421:
422: SELECT
423: IGS_PS_USEC_SPNSRSHP_S.NEXTVAL
424: INTO
425: x_UNIT_SECTION_SPONSORSHIP_ID
426:
427: FROM

Line 441: insert into IGS_PS_USEC_SPNSRSHP (

437: x_created_by=>X_LAST_UPDATED_BY,
438: x_last_update_date=>X_LAST_UPDATE_DATE,
439: x_last_updated_by=>X_LAST_UPDATED_BY,
440: x_last_update_login=>X_LAST_UPDATE_LOGIN);
441: insert into IGS_PS_USEC_SPNSRSHP (
442: UNIT_SECTION_SPONSORSHIP_ID
443: ,UOO_ID
444: ,ORGANIZATION_CODE
445: ,SPONSORSHIP_PERCENTAGE

Line 494: from IGS_PS_USEC_SPNSRSHP

490: cursor c1 is select
491: UOO_ID
492: , ORGANIZATION_CODE
493: , SPONSORSHIP_PERCENTAGE
494: from IGS_PS_USEC_SPNSRSHP
495: where ROWID = X_ROWID
496: for update nowait;
497: tlinfo c1%rowtype;
498: begin

Line 574: update IGS_PS_USEC_SPNSRSHP set

570: x_created_by=>X_LAST_UPDATED_BY,
571: x_last_update_date=>X_LAST_UPDATE_DATE,
572: x_last_updated_by=>X_LAST_UPDATED_BY,
573: x_last_update_login=>X_LAST_UPDATE_LOGIN);
574: update IGS_PS_USEC_SPNSRSHP set
575: UOO_ID = NEW_REFERENCES.UOO_ID,
576: ORGANIZATION_CODE = NEW_REFERENCES.ORGANIZATION_CODE,
577: SPONSORSHIP_PERCENTAGE = NEW_REFERENCES.SPONSORSHIP_PERCENTAGE,
578: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 610: cursor c1 is select ROWID from IGS_PS_USEC_SPNSRSHP

606:
607: (reverse chronological order - newest change first)
608: ***************************************************************/
609:
610: cursor c1 is select ROWID from IGS_PS_USEC_SPNSRSHP
611: where UNIT_SECTION_SPONSORSHIP_ID= X_UNIT_SECTION_SPONSORSHIP_ID
612: ;
613: begin
614: open c1;

Line 655: delete from IGS_PS_USEC_SPNSRSHP

651: Before_DML (
652: p_action => 'DELETE',
653: x_rowid => X_ROWID
654: );
655: delete from IGS_PS_USEC_SPNSRSHP
656: where ROWID = X_ROWID;
657: if (sql%notfound) then
658: raise no_data_found;
659: end if;

Line 665: END igs_ps_usec_spnsrshp_pkg;

661: p_action => 'DELETE',
662: x_rowid => X_ROWID
663: );
664: end DELETE_ROW;
665: END igs_ps_usec_spnsrshp_pkg;