APPS.IGR_I_INQUIRY_TYPES_PKG dependencies on IGR_I_INQUIRY_TYPES

Line 1: PACKAGE BODY igr_i_inquiry_types_pkg AS

1: PACKAGE BODY igr_i_inquiry_types_pkg AS
2: /* $Header: IGSRH19B.pls 120.0 2005/06/02 04:04:27 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igr_i_inquiry_types%ROWTYPE;

Line 5: old_references igr_i_inquiry_types%ROWTYPE;

1: PACKAGE BODY igr_i_inquiry_types_pkg AS
2: /* $Header: IGSRH19B.pls 120.0 2005/06/02 04:04:27 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igr_i_inquiry_types%ROWTYPE;
6: new_references igr_i_inquiry_types%ROWTYPE;
7:
8:
9: FUNCTION get_uk_for_validation (

Line 6: new_references igr_i_inquiry_types%ROWTYPE;

2: /* $Header: IGSRH19B.pls 120.0 2005/06/02 04:04:27 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igr_i_inquiry_types%ROWTYPE;
6: new_references igr_i_inquiry_types%ROWTYPE;
7:
8:
9: FUNCTION get_uk_for_validation (
10: x_inquiry_type_cd IN VARCHAR2

Line 23: FROM igr_i_inquiry_types

19: || (reverse chronological order - newest change first)
20: */
21: CURSOR cur_rowid IS
22: SELECT rowid
23: FROM igr_i_inquiry_types
24: WHERE inquiry_type_cd = x_inquiry_type_cd
25: FOR UPDATE NOWAIT;
26:
27: lv_rowid cur_rowid%RowType;

Line 82: igr_i_e_testtyps_pkg.get_fk_igr_i_inquiry_types(old_references.inquiry_type_id);

78: || Who When What
79: || (reverse chronological order - newest change first)
80: */
81: BEGIN
82: igr_i_e_testtyps_pkg.get_fk_igr_i_inquiry_types(old_references.inquiry_type_id);
83:
84: END Check_Child_Existance;
85:
86:

Line 116: FROM igr_i_inquiry_types

112: */
113:
114: CURSOR cur_old_ref_values IS
115: SELECT *
116: FROM igr_i_inquiry_types
117: WHERE rowid = x_rowid;
118:
119: BEGIN
120:

Line 211: FROM igr_i_inquiry_types

207: || (reverse chronological order - newest change first)
208: */
209: CURSOR cur_rowid IS
210: SELECT rowid
211: FROM igr_i_inquiry_types
212: WHERE inquiry_type_id = x_inquiry_type_id
213: FOR UPDATE NOWAIT;
214:
215: lv_rowid cur_rowid%RowType;

Line 246: FROM igr_i_inquiry_types

242: || (reverse chronological order - newest change first)
243: */
244: CURSOR cur_rowid IS
245: SELECT rowid
246: FROM igr_i_inquiry_types
247: WHERE ((imp_source_type_id = x_source_type_id));
248:
249: lv_rowid cur_rowid%RowType;
250:

Line 281: FROM igr_i_inquiry_types

277: || (reverse chronological order - newest change first)
278: */
279: CURSOR cur_rowid IS
280: SELECT rowid
281: FROM igr_i_inquiry_types
282: WHERE ((info_type_id = x_package_item_id ));
283:
284: lv_rowid cur_rowid%RowType;
285:

Line 426: fnd_message.set_token ('ROUTINE', 'IGR_I_INQUIRY_TYPES_PKG.INSERT_ROW');

422: x_last_update_login := -1;
423: END IF;
424: ELSE
425: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
426: fnd_message.set_token ('ROUTINE', 'IGR_I_INQUIRY_TYPES_PKG.INSERT_ROW');
427: igs_ge_msg_stack.add;
428: app_exception.raise_exception;
429: END IF;
430:

Line 450: INSERT INTO igr_i_inquiry_types (

446: x_last_updated_by => x_last_updated_by,
447: x_last_update_login => x_last_update_login
448: );
449:
450: INSERT INTO igr_i_inquiry_types (
451: inquiry_type_id,
452: inquiry_type_cd,
453: inquiry_type_desc,
454: enabled_flag,

Line 464: igr_i_inquiry_types_s.NEXTVAL,

460: last_update_date,
461: last_updated_by,
462: last_update_login
463: ) VALUES (
464: igr_i_inquiry_types_s.NEXTVAL,
465: new_references.inquiry_type_cd,
466: new_references.inquiry_type_desc,
467: new_references.enabled_flag,
468: new_references.imp_source_type_id,

Line 508: FROM igr_i_inquiry_types

504: enabled_flag,
505: imp_source_type_id,
506: info_type_id,
507: configurability_func_name
508: FROM igr_i_inquiry_types
509: WHERE rowid = x_rowid
510: FOR UPDATE NOWAIT;
511:
512: tlinfo c1%ROWTYPE;

Line 588: fnd_message.set_token ('ROUTINE', 'IGR_I_INQUIRY_TYPES_PKG.UPDATE_ROW');

584: x_last_update_login := -1;
585: END IF;
586: ELSE
587: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
588: fnd_message.set_token ('ROUTINE', 'IGR_I_INQUIRY_TYPES_PKG.UPDATE_ROW');
589: igs_ge_msg_stack.add;
590: app_exception.raise_exception;
591: END IF;
592:

Line 610: UPDATE igr_i_inquiry_types

606: x_last_updated_by => x_last_updated_by,
607: x_last_update_login => x_last_update_login
608: );
609:
610: UPDATE igr_i_inquiry_types
611: SET
612: inquiry_type_cd = new_references.inquiry_type_cd,
613: inquiry_type_desc = new_references.inquiry_type_desc,
614: enabled_flag = new_references.enabled_flag,

Line 652: FROM igr_i_inquiry_types

648: || (reverse chronological order - newest change first)
649: */
650: CURSOR c1 IS
651: SELECT rowid
652: FROM igr_i_inquiry_types
653: WHERE inquiry_type_id = x_inquiry_type_id;
654:
655: BEGIN
656:

Line 711: DELETE FROM igr_i_inquiry_types

707: p_action => 'DELETE',
708: x_rowid => x_rowid
709: );
710:
711: DELETE FROM igr_i_inquiry_types
712: WHERE rowid = x_rowid;
713:
714: IF (SQL%NOTFOUND) THEN
715: RAISE NO_DATA_FOUND;

Line 721: END igr_i_inquiry_types_pkg;

717:
718: END delete_row;
719:
720:
721: END igr_i_inquiry_types_pkg;