APPS.IGS_AD_UP_DETAIL_PKG dependencies on IGS_AD_UP_DETAIL

Line 1: PACKAGE BODY igs_ad_up_detail_pkg AS

1: PACKAGE BODY igs_ad_up_detail_pkg AS
2: /* $Header: IGSAI93B.pls 115.9 2003/10/30 13:16:58 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_up_detail%RowType;
5: new_references igs_ad_up_detail%RowType;

Line 4: old_references igs_ad_up_detail%RowType;

1: PACKAGE BODY igs_ad_up_detail_pkg AS
2: /* $Header: IGSAI93B.pls 115.9 2003/10/30 13:16:58 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_up_detail%RowType;
5: new_references igs_ad_up_detail%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_up_detail%RowType;

1: PACKAGE BODY igs_ad_up_detail_pkg AS
2: /* $Header: IGSAI93B.pls 115.9 2003/10/30 13:16:58 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_up_detail%RowType;
5: new_references igs_ad_up_detail%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM IGS_AD_UP_DETAIL

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

Line 194: FROM igs_ad_up_detail

190: ***************************************************************/
191:
192: CURSOR cur_rowid IS
193: SELECT rowid
194: FROM igs_ad_up_detail
195: WHERE up_detail_id = x_up_detail_id AND
196: closed_ind = NVL(x_closed_ind,closed_ind)
197: FOR UPDATE NOWAIT;
198:

Line 235: FROM igs_ad_up_detail

231: ***************************************************************/
232:
233: CURSOR cur_rowid IS
234: SELECT rowid
235: FROM igs_ad_up_detail
236: WHERE up_header_id = x_up_header_id
237: AND unit_cd = x_unit_cd
238: AND version_number = x_version_number AND
239: ((l_rowid is null) or (rowid <> l_rowid)) AND

Line 274: FROM igs_ad_up_detail

270: ***************************************************************/
271:
272: CURSOR cur_rowid IS
273: SELECT rowid
274: FROM igs_ad_up_detail
275: WHERE up_header_id = x_up_header_id ;
276:
277: lv_rowid cur_rowid%RowType;
278:

Line 312: FROM igs_ad_up_detail

308: ***************************************************************/
309:
310: CURSOR cur_rowid IS
311: SELECT rowid
312: FROM igs_ad_up_detail
313: WHERE unit_cd = x_unit_cd
314: AND version_number = x_version_number ;
315:
316: lv_rowid cur_rowid%RowType;

Line 468: cursor C is select ROWID from IGS_AD_UP_DETAIL

464:
465: (reverse chronological order - newest change first)
466: ***************************************************************/
467:
468: cursor C is select ROWID from IGS_AD_UP_DETAIL
469: where UP_DETAIL_ID= X_UP_DETAIL_ID
470: ;
471: X_LAST_UPDATE_DATE DATE ;
472: X_LAST_UPDATED_BY NUMBER ;

Line 508: insert into IGS_AD_UP_DETAIL (

504: x_created_by=>X_LAST_UPDATED_BY,
505: x_last_update_date=>X_LAST_UPDATE_DATE,
506: x_last_updated_by=>X_LAST_UPDATED_BY,
507: x_last_update_login=>X_LAST_UPDATE_LOGIN);
508: insert into IGS_AD_UP_DETAIL (
509: UP_DETAIL_ID
510: ,UP_HEADER_ID
511: ,UNIT_CD
512: ,VERSION_NUMBER

Line 520: IGS_AD_UP_DETAIL_S.nextval

516: ,LAST_UPDATE_DATE
517: ,LAST_UPDATED_BY
518: ,LAST_UPDATE_LOGIN
519: ) values (
520: IGS_AD_UP_DETAIL_S.nextval
521: ,NEW_REFERENCES.UP_HEADER_ID
522: ,NEW_REFERENCES.UNIT_CD
523: ,NEW_REFERENCES.VERSION_NUMBER
524: ,NEW_REFERENCES.CLOSED_IND

Line 565: from IGS_AD_UP_DETAIL

561: UP_HEADER_ID
562: , UNIT_CD
563: , VERSION_NUMBER
564: , CLOSED_IND
565: from IGS_AD_UP_DETAIL
566: where ROWID = X_ROWID
567: for update nowait;
568: tlinfo c1%rowtype;
569: begin

Line 648: update IGS_AD_UP_DETAIL set

644: x_created_by=>X_LAST_UPDATED_BY,
645: x_last_update_date=>X_LAST_UPDATE_DATE,
646: x_last_updated_by=>X_LAST_UPDATED_BY,
647: x_last_update_login=>X_LAST_UPDATE_LOGIN);
648: update IGS_AD_UP_DETAIL set
649: UP_HEADER_ID = NEW_REFERENCES.UP_HEADER_ID,
650: UNIT_CD = NEW_REFERENCES.UNIT_CD,
651: VERSION_NUMBER = NEW_REFERENCES.VERSION_NUMBER,
652: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 686: cursor c1 is select ROWID from IGS_AD_UP_DETAIL

682:
683: (reverse chronological order - newest change first)
684: ***************************************************************/
685:
686: cursor c1 is select ROWID from IGS_AD_UP_DETAIL
687: where UP_DETAIL_ID= X_UP_DETAIL_ID
688: ;
689: begin
690: open c1;

Line 733: delete from IGS_AD_UP_DETAIL

729: Before_DML (
730: p_action => 'DELETE',
731: x_rowid => X_ROWID
732: );
733: delete from IGS_AD_UP_DETAIL
734: where ROWID = X_ROWID;
735: if (sql%notfound) then
736: raise no_data_found;
737: end if;

Line 743: END igs_ad_up_detail_pkg;

739: p_action => 'DELETE',
740: x_rowid => X_ROWID
741: );
742: end DELETE_ROW;
743: END igs_ad_up_detail_pkg;