APPS.IGS_PS_US_REQ_REF_CD_PKG dependencies on IGS_PS_US_REQ_REF_CD

Line 1: PACKAGE BODY igs_ps_us_req_ref_cd_pkg AS

1: PACKAGE BODY igs_ps_us_req_ref_cd_pkg AS
2: /* $Header: IGSPI2TB.pls 115.6 2003/05/09 06:42:28 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_us_req_ref_cd%ROWTYPE;

Line 5: old_references igs_ps_us_req_ref_cd%ROWTYPE;

1: PACKAGE BODY igs_ps_us_req_ref_cd_pkg AS
2: /* $Header: IGSPI2TB.pls 115.6 2003/05/09 06:42:28 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_us_req_ref_cd%ROWTYPE;
6: new_references igs_ps_us_req_ref_cd%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_us_req_ref_cd%ROWTYPE;

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

Line 34: FROM IGS_PS_US_REQ_REF_CD

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

Line 183: FROM igs_ps_us_req_ref_cd

179: || (reverse chronological order - newest change first)
180: */
181: CURSOR cur_rowid IS
182: SELECT rowid
183: FROM igs_ps_us_req_ref_cd
184: WHERE unit_section_req_ref_cd_id = x_unit_section_req_ref_cd_id
185: FOR UPDATE NOWAIT;
186:
187: lv_rowid cur_rowid%RowType;

Line 220: FROM igs_ps_us_req_ref_cd

216: || (reverse chronological order - newest change first)
217: */
218: CURSOR cur_rowid IS
219: SELECT rowid
220: FROM igs_ps_us_req_ref_cd
221: WHERE unit_section_reference_id = x_unit_section_reference_id
222: AND reference_cd_type = x_reference_cd_type
223: AND reference_code = x_reference_code
224: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 258: FROM igs_ps_us_req_ref_cd

254: || (reverse chronological order - newest change first)
255: */
256: CURSOR cur_rowid IS
257: SELECT rowid
258: FROM igs_ps_us_req_ref_cd
259: WHERE reference_cd_type = x_reference_cd_type
260: AND reference_code= x_reference_code;
261:
262: lv_rowid cur_rowid%RowType;

Line 294: FROM igs_ps_us_req_ref_cd

290: || (reverse chronological order - newest change first)
291: */
292: CURSOR cur_rowid IS
293: SELECT rowid
294: FROM igs_ps_us_req_ref_cd
295: WHERE ((reference_cd_type = x_reference_cd_type));
296:
297: lv_rowid cur_rowid%RowType;
298:

Line 329: FROM igs_ps_us_req_ref_cd

325: || (reverse chronological order - newest change first)
326: */
327: CURSOR cur_rowid IS
328: SELECT rowid
329: FROM igs_ps_us_req_ref_cd
330: WHERE ((unit_section_reference_id = x_unit_section_reference_id));
331:
332: lv_rowid cur_rowid%RowType;
333:

Line 447: FROM igs_ps_us_req_ref_cd

443: || (reverse chronological order - newest change first)
444: */
445: CURSOR c IS
446: SELECT rowid
447: FROM igs_ps_us_req_ref_cd
448: WHERE unit_section_req_ref_cd_id = x_unit_section_req_ref_cd_id;
449:
450: x_last_update_date DATE;
451: x_last_updated_by NUMBER;

Line 475: SELECT igs_ps_us_req_ref_cd_s.NEXTVAL

471: igs_ge_msg_stack.add;
472: app_exception.raise_exception;
473: END IF;
474:
475: SELECT igs_ps_us_req_ref_cd_s.NEXTVAL
476: INTO x_unit_section_req_ref_cd_id
477: FROM dual;
478:
479: before_dml(

Line 494: INSERT INTO igs_ps_us_req_ref_cd (

490: x_reference_code => x_reference_code,
491: x_reference_code_desc => x_reference_code_desc
492: );
493:
494: INSERT INTO igs_ps_us_req_ref_cd (
495: unit_section_req_ref_cd_id,
496: unit_section_reference_id,
497: reference_cd_type,
498: creation_date,

Line 552: FROM igs_ps_us_req_ref_cd

548: unit_section_reference_id,
549: reference_cd_type,
550: reference_code,
551: reference_code_desc
552: FROM igs_ps_us_req_ref_cd
553: WHERE rowid = x_rowid
554: FOR UPDATE NOWAIT;
555:
556: tlinfo c1%ROWTYPE;

Line 651: UPDATE igs_ps_us_req_ref_cd

647: x_reference_code => x_reference_code,
648: x_reference_code_desc => x_reference_code_desc
649: );
650:
651: UPDATE igs_ps_us_req_ref_cd
652: SET
653: unit_section_reference_id = new_references.unit_section_reference_id,
654: reference_cd_type = new_references.reference_cd_type,
655: last_update_date = x_last_update_date,

Line 689: FROM igs_ps_us_req_ref_cd

685: || (reverse chronological order - newest change first)
686: */
687: CURSOR c1 IS
688: SELECT rowid
689: FROM igs_ps_us_req_ref_cd
690: WHERE unit_section_req_ref_cd_id = x_unit_section_req_ref_cd_id;
691:
692: BEGIN
693:

Line 744: DELETE FROM igs_ps_us_req_ref_cd

740: p_action => 'DELETE',
741: x_rowid => x_rowid
742: );
743:
744: DELETE FROM igs_ps_us_req_ref_cd
745: WHERE rowid = x_rowid;
746:
747: IF (SQL%NOTFOUND) THEN
748: RAISE NO_DATA_FOUND;

Line 754: END igs_ps_us_req_ref_cd_pkg;

750:
751: END delete_row;
752:
753:
754: END igs_ps_us_req_ref_cd_pkg;