APPS.IGS_CO_MAPPING_PKG dependencies on IGS_CO_MAPPING

Line 1: PACKAGE BODY igs_co_mapping_pkg AS

1: PACKAGE BODY igs_co_mapping_pkg AS
2: /* $Header: IGSLI29B.pls 120.0 2005/06/01 23:37:26 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_mapping%ROWTYPE;

Line 5: old_references igs_co_mapping%ROWTYPE;

1: PACKAGE BODY igs_co_mapping_pkg AS
2: /* $Header: IGSLI29B.pls 120.0 2005/06/01 23:37:26 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_mapping%ROWTYPE;
6: new_references igs_co_mapping%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_co_mapping%ROWTYPE;

2: /* $Header: IGSLI29B.pls 120.0 2005/06/01 23:37:26 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_mapping%ROWTYPE;
6: new_references igs_co_mapping%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 39: FROM igs_co_mapping

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

Line 194: FROM igs_co_mapping

190: || (reverse chronological order - newest change first)
191: */
192: CURSOR cur_rowid IS
193: SELECT rowid
194: FROM igs_co_mapping
195: WHERE map_id = x_map_id
196: FOR UPDATE NOWAIT;
197:
198: lv_rowid cur_rowid%RowType;

Line 231: FROM igs_co_mapping

227: || (reverse chronological order - newest change first)
228: */
229: CURSOR cur_rowid IS
230: SELECT rowid
231: FROM igs_co_mapping
232: WHERE document_id = x_document_id
233: AND map_code = x_map_code
234: AND sys_ltr_code = x_sys_ltr_code
235: AND ((l_rowid IS NULL) OR (rowid <> l_rowid))

Line 365: FROM igs_co_mapping

361: || (reverse chronological order - newest change first)
362: */
363: CURSOR c IS
364: SELECT rowid
365: FROM igs_co_mapping
366: WHERE map_id = x_map_id;
367:
368: x_last_update_date DATE;
369: x_last_updated_by NUMBER;

Line 393: SELECT igs_co_mapping_s.NEXTVAL

389: igs_ge_msg_stack.add;
390: app_exception.raise_exception;
391: END IF;
392:
393: SELECT igs_co_mapping_s.NEXTVAL
394: INTO x_map_id
395: FROM dual;
396:
397: before_dml(

Line 417: INSERT INTO igs_co_mapping (

413: x_last_updated_by => x_last_updated_by,
414: x_last_update_login => x_last_update_login
415: );
416:
417: INSERT INTO igs_co_mapping (
418: map_id,
419: map_code,
420: doc_code,
421: document_id,

Line 495: FROM igs_co_mapping

491: map_description,
492: elapsed_days,
493: repeat_times,
494: attr_description
495: FROM igs_co_mapping
496: WHERE rowid = x_rowid
497: FOR UPDATE NOWAIT;
498:
499: tlinfo c1%ROWTYPE;

Line 605: UPDATE igs_co_mapping

601: x_last_updated_by => x_last_updated_by,
602: x_last_update_login => x_last_update_login
603: );
604:
605: UPDATE igs_co_mapping
606: SET
607: map_code = new_references.map_code,
608: doc_code = new_references.doc_code,
609: document_id = new_references.document_id,

Line 653: FROM igs_co_mapping

649: || (reverse chronological order - newest change first)
650: */
651: CURSOR c1 IS
652: SELECT rowid
653: FROM igs_co_mapping
654: WHERE map_id = x_map_id;
655:
656: BEGIN
657:

Line 718: DELETE FROM igs_co_mapping

714: p_action => 'DELETE',
715: x_rowid => x_rowid
716: );
717:
718: DELETE FROM igs_co_mapping
719: WHERE rowid = x_rowid;
720:
721: IF (SQL%NOTFOUND) THEN
722: RAISE NO_DATA_FOUND;

Line 728: END igs_co_mapping_pkg;

724:
725: END delete_row;
726:
727:
728: END igs_co_mapping_pkg;