APPS.IGS_PS_UNITREQREF_CD_PKG dependencies on IGS_PS_UNITREQREF_CD

Line 1: PACKAGE BODY igs_ps_unitreqref_cd_pkg AS

1: PACKAGE BODY igs_ps_unitreqref_cd_pkg AS
2: /* $Header: IGSPI2GB.pls 115.4 2003/05/09 06:38:06 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_unitreqref_cd%ROWTYPE;

Line 5: old_references igs_ps_unitreqref_cd%ROWTYPE;

1: PACKAGE BODY igs_ps_unitreqref_cd_pkg AS
2: /* $Header: IGSPI2GB.pls 115.4 2003/05/09 06:38:06 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_unitreqref_cd%ROWTYPE;
6: new_references igs_ps_unitreqref_cd%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_unitreqref_cd%ROWTYPE;

2: /* $Header: IGSPI2GB.pls 115.4 2003/05/09 06:38:06 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_unitreqref_cd%ROWTYPE;
6: new_references igs_ps_unitreqref_cd%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_PS_UNITREQREF_CD

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

Line 171: FROM igs_ps_unitreqref_cd

167: || (reverse chronological order - newest change first)
168: */
169: CURSOR cur_rowid IS
170: SELECT rowid
171: FROM igs_ps_unitreqref_cd
172: WHERE unit_req_ref_cd_id = x_unit_req_ref_cd_id
173: FOR UPDATE NOWAIT;
174:
175: lv_rowid cur_rowid%RowType;

Line 209: FROM igs_ps_unitreqref_cd

205: || (reverse chronological order - newest change first)
206: */
207: CURSOR cur_rowid IS
208: SELECT rowid
209: FROM igs_ps_unitreqref_cd
210: WHERE unit_cd = x_unit_cd
211: AND version_number = x_version_number
212: AND reference_cd_type = x_reference_cd_type
213: AND reference_code = x_reference_code

Line 248: FROM igs_ps_unitreqref_cd

244: || (reverse chronological order - newest change first)
245: */
246: CURSOR cur_rowid IS
247: SELECT rowid
248: FROM igs_ps_unitreqref_cd
249: WHERE reference_cd_type = x_reference_cd_type
250: AND reference_code = x_reference_code;
251:
252: lv_rowid cur_rowid%RowType;

Line 284: FROM igs_ps_unitreqref_cd

280: || (reverse chronological order - newest change first)
281: */
282: CURSOR cur_rowid IS
283: SELECT rowid
284: FROM igs_ps_unitreqref_cd
285: WHERE ((reference_cd_type = x_reference_cd_type));
286:
287: lv_rowid cur_rowid%RowType;
288:

Line 403: FROM igs_ps_unitreqref_cd

399: || (reverse chronological order - newest change first)
400: */
401: CURSOR c IS
402: SELECT rowid
403: FROM igs_ps_unitreqref_cd
404: WHERE unit_req_ref_cd_id = x_unit_req_ref_cd_id;
405:
406: x_last_update_date DATE;
407: x_last_updated_by NUMBER;

Line 431: SELECT igs_ps_unitreqref_cd_s.NEXTVAL

427: igs_ge_msg_stack.add;
428: app_exception.raise_exception;
429: END IF;
430:
431: SELECT igs_ps_unitreqref_cd_s.NEXTVAL
432: INTO x_unit_req_ref_cd_id
433: FROM dual;
434:
435: before_dml(

Line 451: INSERT INTO igs_ps_unitreqref_cd (

447: x_reference_code => x_reference_code,
448: x_reference_code_desc => x_reference_code_desc
449: );
450:
451: INSERT INTO igs_ps_unitreqref_cd (
452: unit_req_ref_cd_id,
453: unit_cd,
454: version_number,
455: reference_cd_type,

Line 513: FROM igs_ps_unitreqref_cd

509: version_number,
510: reference_cd_type ,
511: reference_code,
512: reference_code_desc
513: FROM igs_ps_unitreqref_cd
514: WHERE rowid = x_rowid
515: FOR UPDATE NOWAIT;
516:
517: tlinfo c1%ROWTYPE;

Line 614: UPDATE igs_ps_unitreqref_cd

610: x_last_update_login => x_last_update_login ,
611: x_reference_code => x_reference_code,
612: x_reference_code_desc => x_reference_code_desc);
613:
614: UPDATE igs_ps_unitreqref_cd
615: SET
616: unit_cd = new_references.unit_cd,
617: version_number = new_references.version_number,
618: reference_cd_type = new_references.reference_cd_type,

Line 654: FROM igs_ps_unitreqref_cd

650: || (reverse chronological order - newest change first)
651: */
652: CURSOR c1 IS
653: SELECT rowid
654: FROM igs_ps_unitreqref_cd
655: WHERE unit_req_ref_cd_id = x_unit_req_ref_cd_id;
656:
657: BEGIN
658:

Line 711: DELETE FROM igs_ps_unitreqref_cd

707: p_action => 'DELETE',
708: x_rowid => x_rowid
709: );
710:
711: DELETE FROM igs_ps_unitreqref_cd
712: WHERE rowid = x_rowid;
713:
714: IF (SQL%NOTFOUND) THEN
715: RAISE NO_DATA_FOUND;

Line 721: END igs_ps_unitreqref_cd_pkg;

717:
718: END delete_row;
719:
720:
721: END igs_ps_unitreqref_cd_pkg;