APPS.IGS_UC_REF_AWRDBDY_PKG dependencies on IGS_UC_REF_AWRDBDY

Line 1: PACKAGE BODY igs_uc_ref_awrdbdy_pkg AS

1: PACKAGE BODY igs_uc_ref_awrdbdy_pkg AS
2: /* $Header: IGSXI25B.pls 115.5 2003/02/28 07:48:41 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_awrdbdy%ROWTYPE;

Line 5: old_references igs_uc_ref_awrdbdy%ROWTYPE;

1: PACKAGE BODY igs_uc_ref_awrdbdy_pkg AS
2: /* $Header: IGSXI25B.pls 115.5 2003/02/28 07:48:41 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_awrdbdy%ROWTYPE;
6: new_references igs_uc_ref_awrdbdy%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_ref_awrdbdy%ROWTYPE;

2: /* $Header: IGSXI25B.pls 115.5 2003/02/28 07:48:41 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_awrdbdy%ROWTYPE;
6: new_references igs_uc_ref_awrdbdy%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 35: FROM IGS_UC_REF_AWRDBDY

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

Line 90: igs_uc_com_ebl_subj_pkg.get_fk_igs_uc_ref_awrdbdy (

86: || (reverse chronological order - newest change first)
87: */
88: BEGIN
89:
90: igs_uc_com_ebl_subj_pkg.get_fk_igs_uc_ref_awrdbdy (
91: old_references.awarding_body,
92: old_references.sitting,
93: old_references.year
94: );

Line 115: FROM igs_uc_ref_awrdbdy

111: || (reverse chronological order - newest change first)
112: */
113: CURSOR cur_rowid IS
114: SELECT rowid
115: FROM igs_uc_ref_awrdbdy
116: WHERE awarding_body = x_awarding_body
117: AND sitting = x_sitting
118: AND year = x_year ;
119:

Line 235: FROM igs_uc_ref_awrdbdy

231: || (reverse chronological order - newest change first)
232: */
233: CURSOR c IS
234: SELECT rowid
235: FROM igs_uc_ref_awrdbdy
236: WHERE awarding_body = x_awarding_body
237: AND sitting = x_sitting
238: AND year = x_year;
239:

Line 281: INSERT INTO igs_uc_ref_awrdbdy (

277: x_last_updated_by => x_last_updated_by,
278: x_last_update_login => x_last_update_login
279: );
280:
281: INSERT INTO igs_uc_ref_awrdbdy (
282: year,
283: sitting,
284: awarding_body,
285: body_name,

Line 341: FROM igs_uc_ref_awrdbdy

337: SELECT
338: body_name,
339: body_abbrev,
340: imported
341: FROM igs_uc_ref_awrdbdy
342: WHERE rowid = x_rowid
343: FOR UPDATE NOWAIT;
344:
345: tlinfo c1%ROWTYPE;

Line 437: UPDATE igs_uc_ref_awrdbdy

433: x_last_updated_by => x_last_updated_by,
434: x_last_update_login => x_last_update_login
435: );
436:
437: UPDATE igs_uc_ref_awrdbdy
438: SET
439: body_name = new_references.body_name,
440: body_abbrev = new_references.body_abbrev,
441: imported = new_references.imported,

Line 475: FROM igs_uc_ref_awrdbdy

471: || (reverse chronological order - newest change first)
472: */
473: CURSOR c1 IS
474: SELECT rowid
475: FROM igs_uc_ref_awrdbdy
476: WHERE awarding_body = x_awarding_body
477: AND sitting = x_sitting
478: AND year = x_year;
479:

Line 534: DELETE FROM igs_uc_ref_awrdbdy

530: p_action => 'DELETE',
531: x_rowid => x_rowid
532: );
533:
534: DELETE FROM igs_uc_ref_awrdbdy
535: WHERE rowid = x_rowid;
536:
537: IF (SQL%NOTFOUND) THEN
538: RAISE NO_DATA_FOUND;

Line 544: END igs_uc_ref_awrdbdy_pkg;

540:
541: END delete_row;
542:
543:
544: END igs_uc_ref_awrdbdy_pkg;