APPS.IGS_CO_TYPE_PKG dependencies on IGS_CO_TYPE

Line 1: PACKAGE BODY igs_co_type_pkg AS

1: PACKAGE BODY igs_co_type_pkg AS
2: /* $Header: IGSLI23B.pls 115.8 2002/11/29 01:07:25 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_type%ROWTYPE;

Line 5: old_references igs_co_type%ROWTYPE;

1: PACKAGE BODY igs_co_type_pkg AS
2: /* $Header: IGSLI23B.pls 115.8 2002/11/29 01:07:25 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_type%ROWTYPE;
6: new_references igs_co_type%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_co_type%ROWTYPE;

2: /* $Header: IGSLI23B.pls 115.8 2002/11/29 01:07:25 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_type%ROWTYPE;
6: new_references igs_co_type%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_CO_TYPE

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

Line 132: igs_co_cat_itm_pkg.get_fk_igs_co_type (

128: || (reverse chronological order - newest change first)
129: */
130: BEGIN
131:
132: igs_co_cat_itm_pkg.get_fk_igs_co_type (
133: old_references.correspondence_type
134: );
135:
136: igs_co_ltr_pr_rstcn_pkg.get_fk_igs_co_type (

Line 136: igs_co_ltr_pr_rstcn_pkg.get_fk_igs_co_type (

132: igs_co_cat_itm_pkg.get_fk_igs_co_type (
133: old_references.correspondence_type
134: );
135:
136: igs_co_ltr_pr_rstcn_pkg.get_fk_igs_co_type (
137: old_references.correspondence_type
138: );
139:
140: igs_co_s_ltr_pkg.get_fk_igs_co_type (

Line 140: igs_co_s_ltr_pkg.get_fk_igs_co_type (

136: igs_co_ltr_pr_rstcn_pkg.get_fk_igs_co_type (
137: old_references.correspondence_type
138: );
139:
140: igs_co_s_ltr_pkg.get_fk_igs_co_type (
141: old_references.correspondence_type
142: );
143:
144: igs_co_s_ltr_pr_rstn_pkg.get_fk_igs_co_type (

Line 144: igs_co_s_ltr_pr_rstn_pkg.get_fk_igs_co_type (

140: igs_co_s_ltr_pkg.get_fk_igs_co_type (
141: old_references.correspondence_type
142: );
143:
144: igs_co_s_ltr_pr_rstn_pkg.get_fk_igs_co_type (
145: old_references.correspondence_type
146: );
147:
148: END check_child_existance;

Line 165: FROM igs_co_type

161: || (reverse chronological order - newest change first)
162: */
163: CURSOR cur_rowid IS
164: SELECT rowid
165: FROM igs_co_type
166: WHERE correspondence_type = x_correspondence_type
167: FOR UPDATE NOWAIT;
168:
169: lv_rowid cur_rowid%RowType;

Line 287: FROM igs_co_type

283: || (reverse chronological order - newest change first)
284: */
285: CURSOR c IS
286: SELECT rowid
287: FROM igs_co_type
288: WHERE correspondence_type = x_correspondence_type;
289:
290: x_last_update_date DATE;
291: x_last_updated_by NUMBER;

Line 332: INSERT INTO igs_co_type (

328: x_last_updated_by => x_last_updated_by,
329: x_last_update_login => x_last_update_login
330: );
331:
332: INSERT INTO igs_co_type (
333: correspondence_type,
334: description,
335: sys_generated_ind,
336: closed_ind,

Line 394: FROM igs_co_type

390: sys_generated_ind,
391: closed_ind,
392: job_application_id,
393: job_program_id
394: FROM igs_co_type
395: WHERE rowid = x_rowid
396: FOR UPDATE NOWAIT;
397:
398: tlinfo c1%ROWTYPE;

Line 493: UPDATE igs_co_type

489: x_last_update_login => x_last_update_login
490: );
491:
492:
493: UPDATE igs_co_type
494: SET
495: description = new_references.description,
496: sys_generated_ind = new_references.sys_generated_ind,
497: closed_ind = new_references.closed_ind,

Line 533: FROM igs_co_type

529: || (reverse chronological order - newest change first)
530: */
531: CURSOR c1 IS
532: SELECT rowid
533: FROM igs_co_type
534: WHERE correspondence_type = x_correspondence_type;
535:
536: BEGIN
537:

Line 590: DELETE FROM igs_co_type

586: p_action => 'DELETE',
587: x_rowid => x_rowid
588: );
589:
590: DELETE FROM igs_co_type
591: WHERE rowid = x_rowid;
592:
593: IF (SQL%NOTFOUND) THEN
594: RAISE NO_DATA_FOUND;

Line 600: END igs_co_type_pkg;

596:
597: END delete_row;
598:
599:
600: END igs_co_type_pkg;