APPS.IGS_PE_DELIVERY_CDS_PKG dependencies on IGS_PE_DELIVERY_CDS_ALL

Line 5: old_references igs_pe_delivery_cds_all%RowType;

1: PACKAGE BODY igs_pe_delivery_cds_pkg AS
2: /* $Header: IGSNI47B.pls 115.8 2002/11/29 01:25:04 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_delivery_cds_all%RowType;
6: new_references igs_pe_delivery_cds_all%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_delivery_cds_all%RowType;

2: /* $Header: IGSNI47B.pls 115.8 2002/11/29 01:25:04 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_delivery_cds_all%RowType;
6: new_references igs_pe_delivery_cds_all%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM igs_pe_delivery_cds_all

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

Line 123: FROM igs_pe_delivery_cds_all

119: ***************************************************************/
120:
121: CURSOR cur_rowid IS
122: SELECT rowid
123: FROM igs_pe_delivery_cds_all
124: WHERE delivery_code = x_delivery_code
125: FOR UPDATE NOWAIT;
126:
127: lv_rowid cur_rowid%RowType;

Line 265: cursor C is select ROWID from igs_pe_delivery_cds_all

261:
262: (reverse chronological order - newest change first)
263: ***************************************************************/
264:
265: cursor C is select ROWID from igs_pe_delivery_cds_all
266: where DELIVERY_CODE= X_DELIVERY_CODE
267: ;
268: X_LAST_UPDATE_DATE DATE ;
269: X_LAST_UPDATED_BY NUMBER ;

Line 303: insert into igs_pe_delivery_cds_all (

299: x_last_updated_by=>X_LAST_UPDATED_BY,
300: x_last_update_login=>X_LAST_UPDATE_LOGIN,
301: x_org_id=>igs_ge_gen_003.get_org_id
302: );
303: insert into igs_pe_delivery_cds_all (
304: DELIVERY_CODE
305: ,DESCRIPTION
306: ,CLOSED_IND
307: ,CREATION_DATE

Line 355: from igs_pe_delivery_cds_all

351:
352: cursor c1 is select
353: DESCRIPTION
354: , CLOSED_IND
355: from igs_pe_delivery_cds_all
356: where ROWID = X_ROWID
357: for update nowait;
358: tlinfo c1%rowtype;
359: begin

Line 433: update igs_pe_delivery_cds_all set

429: x_last_update_date=>X_LAST_UPDATE_DATE,
430: x_last_updated_by=>X_LAST_UPDATED_BY,
431: x_last_update_login=>X_LAST_UPDATE_LOGIN
432: );
433: update igs_pe_delivery_cds_all set
434: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
435: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
436: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
437: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 468: cursor c1 is select ROWID from igs_pe_delivery_cds_all

464:
465: (reverse chronological order - newest change first)
466: ***************************************************************/
467:
468: cursor c1 is select ROWID from igs_pe_delivery_cds_all
469: where DELIVERY_CODE= X_DELIVERY_CODE
470: ;
471: begin
472: open c1;

Line 514: delete from igs_pe_delivery_cds_all

510: Before_DML (
511: p_action => 'DELETE',
512: x_rowid => X_ROWID
513: );
514: delete from igs_pe_delivery_cds_all
515: where ROWID = X_ROWID;
516: if (sql%notfound) then
517: raise no_data_found;
518: end if;