APPS.IGS_CO_DTL_PKG dependencies on IGS_CO_DTL

Line 1: PACKAGE BODY igs_co_dtl_pkg AS

1: PACKAGE BODY igs_co_dtl_pkg AS
2: /* $Header: IGSLI05B.pls 115.6 2002/11/29 01:03:21 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_dtl%ROWTYPE;

Line 5: old_references igs_co_dtl%ROWTYPE;

1: PACKAGE BODY igs_co_dtl_pkg AS
2: /* $Header: IGSLI05B.pls 115.6 2002/11/29 01:03:21 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_dtl%ROWTYPE;
6: new_references igs_co_dtl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_co_dtl%ROWTYPE;

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

Line 34: FROM IGS_CO_DTL

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

Line 160: igs_co_dtl_ole_pkg.get_fk_igs_co_dtl (

156: || (reverse chronological order - newest change first)
157: */
158: BEGIN
159:
160: igs_co_dtl_ole_pkg.get_fk_igs_co_dtl (
161: old_references.correspondence_type,
162: old_references.reference_number
163: );
164:

Line 183: FROM igs_co_dtl

179: || (reverse chronological order - newest change first)
180: */
181: CURSOR cur_rowid IS
182: SELECT rowid
183: FROM igs_co_dtl
184: WHERE correspondence_type = x_correspondence_type
185: AND reference_number = x_reference_number
186: FOR UPDATE NOWAIT;
187:

Line 220: FROM igs_co_dtl

216: || (reverse chronological order - newest change first)
217: */
218: CURSOR cur_rowid IS
219: SELECT rowid
220: FROM igs_co_dtl
221: WHERE ((correspondence_type = x_correspondence_type) AND
222: (reference_number = x_reference_number));
223:
224: lv_rowid cur_rowid%RowType;

Line 344: FROM igs_co_dtl

340: || (reverse chronological order - newest change first)
341: */
342: CURSOR c IS
343: SELECT rowid
344: FROM igs_co_dtl
345: WHERE correspondence_type = x_correspondence_type
346: AND reference_number = x_reference_number;
347:
348: x_last_update_date DATE;

Line 404: INSERT INTO igs_co_dtl (

400: x_last_updated_by => x_last_updated_by,
401: x_last_update_login => x_last_update_login
402: );
403:
404: INSERT INTO igs_co_dtl (
405: correspondence_type,
406: reference_number,
407: s_cord_format_type,
408: cord_text,

Line 469: FROM igs_co_dtl

465: SELECT
466: s_cord_format_type,
467: cord_text,
468: external_reference
469: FROM igs_co_dtl
470: WHERE rowid = x_rowid
471: FOR UPDATE NOWAIT;
472:
473: tlinfo c1%ROWTYPE;

Line 581: UPDATE igs_co_dtl

577: x_program_update_date := SYSDATE;
578: END IF;
579: END IF;
580:
581: UPDATE igs_co_dtl
582: SET
583: s_cord_format_type = new_references.s_cord_format_type,
584: cord_text = new_references.cord_text,
585: external_reference = new_references.external_reference,

Line 622: FROM igs_co_dtl

618: || (reverse chronological order - newest change first)
619: */
620: CURSOR c1 IS
621: SELECT rowid
622: FROM igs_co_dtl
623: WHERE correspondence_type = x_correspondence_type
624: AND reference_number = x_reference_number;
625:
626: BEGIN

Line 678: DELETE FROM igs_co_dtl

674: p_action => 'DELETE',
675: x_rowid => x_rowid
676: );
677:
678: DELETE FROM igs_co_dtl
679: WHERE rowid = x_rowid;
680:
681: IF (SQL%NOTFOUND) THEN
682: RAISE NO_DATA_FOUND;

Line 688: END igs_co_dtl_pkg;

684:
685: END delete_row;
686:
687:
688: END igs_co_dtl_pkg;