APPS.IGS_UC_REF_POCC_PKG dependencies on IGS_UC_REF_POCC

Line 1: PACKAGE BODY igs_uc_ref_pocc_pkg AS

1: PACKAGE BODY igs_uc_ref_pocc_pkg AS
2: /* $Header: IGSXI31B.pls 120.1 2005/09/27 19:34:46 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_pocc%ROWTYPE;

Line 5: old_references igs_uc_ref_pocc%ROWTYPE;

1: PACKAGE BODY igs_uc_ref_pocc_pkg AS
2: /* $Header: IGSXI31B.pls 120.1 2005/09/27 19:34:46 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_pocc%ROWTYPE;
6: new_references igs_uc_ref_pocc%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_ref_pocc%ROWTYPE;

2: /* $Header: IGSXI31B.pls 120.1 2005/09/27 19:34:46 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_pocc%ROWTYPE;
6: new_references igs_uc_ref_pocc%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 38: FROM IGS_UC_REF_POCC

34: */
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM IGS_UC_REF_POCC
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 97: FROM igs_uc_ref_pocc

93: || (reverse chronological order - newest change first)
94: */
95: CURSOR cur_rowid IS
96: SELECT rowid
97: FROM igs_uc_ref_pocc
98: WHERE pocc = x_pocc ;
99:
100: lv_rowid cur_rowid%RowType;
101:

Line 214: FROM igs_uc_ref_pocc

210: || (reverse chronological order - newest change first)
211: */
212: CURSOR c IS
213: SELECT rowid
214: FROM igs_uc_ref_pocc
215: WHERE pocc = x_pocc;
216:
217: x_last_update_date DATE;
218: x_last_updated_by NUMBER;

Line 242: /* SELECT igs_uc_ref_pocc_s.NEXTVAL

238: igs_ge_msg_stack.add;
239: app_exception.raise_exception;
240: END IF;
241:
242: /* SELECT igs_uc_ref_pocc_s.NEXTVAL
243: INTO x_pocc
244: FROM dual;
245: */
246: before_dml(

Line 264: INSERT INTO igs_uc_ref_pocc (

260: x_last_update_login => x_last_update_login,
261: x_socio_economic => x_socio_economic
262: );
263:
264: INSERT INTO igs_uc_ref_pocc (
265: pocc,
266: social_class,
267: occupation_text,
268: alternative_text,

Line 335: FROM igs_uc_ref_pocc

331: alternative_class1,
332: alternative_class2,
333: imported,
334: socio_economic
335: FROM igs_uc_ref_pocc
336: WHERE rowid = x_rowid
337: FOR UPDATE NOWAIT;
338:
339: tlinfo c1%ROWTYPE;

Line 440: UPDATE igs_uc_ref_pocc

436: x_last_update_login => x_last_update_login,
437: x_socio_economic => x_socio_economic
438: );
439:
440: UPDATE igs_uc_ref_pocc
441: SET
442: social_class = new_references.social_class,
443: occupation_text = new_references.occupation_text,
444: alternative_text = new_references.alternative_text,

Line 485: FROM igs_uc_ref_pocc

481: || (reverse chronological order - newest change first)
482: */
483: CURSOR c1 IS
484: SELECT rowid
485: FROM igs_uc_ref_pocc
486: WHERE pocc = x_pocc;
487:
488: BEGIN
489:

Line 546: DELETE FROM igs_uc_ref_pocc

542: p_action => 'DELETE',
543: x_rowid => x_rowid
544: );
545:
546: DELETE FROM igs_uc_ref_pocc
547: WHERE rowid = x_rowid;
548:
549: IF (SQL%NOTFOUND) THEN
550: RAISE NO_DATA_FOUND;

Line 556: END igs_uc_ref_pocc_pkg;

552:
553: END delete_row;
554:
555:
556: END igs_uc_ref_pocc_pkg;