APPS.IGS_CO_ITM_PKG dependencies on IGS_CO_ITM_ALL

Line 5: old_references igs_co_itm_all%ROWTYPE;

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

Line 6: new_references igs_co_itm_all%ROWTYPE;

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

Line 47: FROM IGS_CO_ITM_ALL

43: */
44:
45: CURSOR cur_old_ref_values IS
46: SELECT *
47: FROM IGS_CO_ITM_ALL
48: WHERE rowid = x_rowid;
49:
50: BEGIN
51:

Line 163: FROM IGS_CO_ITM_ALL

159: ) AS
160:
161: CURSOR cur_rowid IS
162: SELECT rowid
163: FROM IGS_CO_ITM_ALL
164: WHERE cal_type = x_cal_type
165: AND ci_sequence_number = x_sequence_number ;
166:
167: lv_rowid cur_rowid%RowType;

Line 190: FROM IGS_CO_ITM_ALL

186: ) AS
187:
188: CURSOR cur_rowid IS
189: SELECT rowid
190: FROM IGS_CO_ITM_ALL
191: WHERE correspondence_type = x_correspondence_type ;
192:
193: lv_rowid cur_rowid%RowType;
194:

Line 217: FROM IGS_CO_ITM_ALL

213: ) AS
214:
215: CURSOR cur_rowid IS
216: SELECT rowid
217: FROM IGS_CO_ITM_ALL
218: WHERE course_cd = x_course_cd
219: AND cv_version_number = x_version_number ;
220:
221: lv_rowid cur_rowid%RowType;

Line 244: FROM IGS_CO_ITM_ALL

240: ) AS
241:
242: CURSOR cur_rowid IS
243: SELECT rowid
244: FROM IGS_CO_ITM_ALL
245: WHERE originator_person_id = x_person_id ;
246:
247: lv_rowid cur_rowid%RowType;
248:

Line 271: FROM IGS_CO_ITM_ALL

267: ) AS
268:
269: CURSOR cur_rowid IS
270: SELECT rowid
271: FROM IGS_CO_ITM_ALL
272: WHERE unit_cd = x_unit_cd
273: AND uv_version_number = x_version_number ;
274:
275: lv_rowid cur_rowid%RowType;

Line 352: FROM igs_co_itm_all

348: || (reverse chronological order - newest change first)
349: */
350: CURSOR cur_rowid IS
351: SELECT rowid
352: FROM igs_co_itm_all
353: WHERE correspondence_type = x_correspondence_type
354: AND reference_number = x_reference_number
355: FOR UPDATE NOWAIT;
356:

Line 388: FROM igs_co_itm_all

384: || (reverse chronological order - newest change first)
385: */
386: CURSOR cur_rowid IS
387: SELECT rowid
388: FROM igs_co_itm_all
389: WHERE reference_number = x_reference_number
390: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
391:
392: lv_rowid cur_rowid%RowType;

Line 552: FROM igs_co_itm_all

548: || (reverse chronological order - newest change first)
549: */
550: CURSOR c IS
551: SELECT rowid
552: FROM igs_co_itm_all
553: WHERE correspondence_type = x_correspondence_type
554: AND reference_number = x_reference_number;
555:
556: x_last_update_date DATE;

Line 625: INSERT INTO igs_co_itm_all (

621: x_last_updated_by => x_last_updated_by,
622: x_last_update_login => x_last_update_login
623: );
624:
625: INSERT INTO igs_co_itm_all (
626: org_id,
627: correspondence_type,
628: reference_number,
629: create_dt,

Line 740: FROM igs_co_itm_all

736: comments,
737: originator_person_id,
738: request_num,
739: job_request_id
740: FROM igs_co_itm_all
741: WHERE rowid = x_rowid
742: FOR UPDATE NOWAIT;
743:
744: tlinfo c1%ROWTYPE;

Line 888: UPDATE igs_co_itm_all

884: x_program_update_date := SYSDATE;
885: END IF;
886: END IF;
887:
888: UPDATE igs_co_itm_all
889: SET
890: create_dt = new_references.create_dt,
891: s_job_name = new_references.s_job_name,
892: request_job_id = new_references.request_job_id,

Line 954: FROM igs_co_itm_all

950: || (reverse chronological order - newest change first)
951: */
952: CURSOR c1 IS
953: SELECT rowid
954: FROM igs_co_itm_all
955: WHERE correspondence_type = x_correspondence_type
956: AND reference_number = x_reference_number;
957:
958: BEGIN

Line 1035: DELETE FROM igs_co_itm_all

1031: p_action => 'DELETE',
1032: x_rowid => x_rowid
1033: );
1034:
1035: DELETE FROM igs_co_itm_all
1036: WHERE rowid = x_rowid;
1037:
1038: IF (SQL%NOTFOUND) THEN
1039: RAISE NO_DATA_FOUND;