[Home] [Help]
PACKAGE: APPS.IGR_I_E_CHARTYP_PKG
Source
1 PACKAGE igr_i_e_chartyp_pkg as
2 /* $Header: IGSRH04S.pls 120.0 2005/06/01 15:37:04 appldev noship $ */
3
4 PROCEDURE insert_row (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_ENQUIRY_CHARACTERISTIC_TYPE in VARCHAR2,
7 X_DESCRIPTION in VARCHAR2,
8 X_CLOSED_IND in VARCHAR2,
9 X_MODE in VARCHAR2 default 'R'
10 );
11 PROCEDURE lock_row (
12 X_ROWID in VARCHAR2,
13 X_ENQUIRY_CHARACTERISTIC_TYPE in VARCHAR2,
14 X_DESCRIPTION in VARCHAR2,
15 X_CLOSED_IND in VARCHAR2
16 );
17 PROCEDURE update_row (
18 X_ROWID in VARCHAR2,
19 X_ENQUIRY_CHARACTERISTIC_TYPE in VARCHAR2,
20 X_DESCRIPTION in VARCHAR2,
21 X_CLOSED_IND in VARCHAR2,
22 X_MODE in VARCHAR2 default 'R'
23 );
24 PROCEDURE add_row (
25 X_ROWID in out NOCOPY VARCHAR2,
26 X_ENQUIRY_CHARACTERISTIC_TYPE in VARCHAR2,
27 X_DESCRIPTION in VARCHAR2,
28 X_CLOSED_IND in VARCHAR2,
29 X_MODE in VARCHAR2 default 'R'
30 );
31
32 FUNCTION get_pk_for_validation (
33 x_enquiry_characteristic_type IN VARCHAR2,
34 x_closed_ind IN VARCHAR2 DEFAULT NULL
35 ) RETURN BOOLEAN;
36
37 PROCEDURE check_constraints (
38 Column_Name IN VARCHAR2 DEFAULT NULL,
39 Column_Value IN VARCHAR2 DEFAULT NULL
40 );
41
42 PROCEDURE before_dml (
43 p_action IN VARCHAR2,
44 x_rowid IN VARCHAR2 DEFAULT NULL,
45 x_enquiry_characteristic_type IN VARCHAR2 DEFAULT NULL,
46 x_description IN VARCHAR2 DEFAULT NULL,
47 x_closed_ind IN VARCHAR2 DEFAULT NULL,
48 x_creation_date IN DATE DEFAULT NULL,
49 x_created_by IN NUMBER DEFAULT NULL,
50 x_last_update_date IN DATE DEFAULT NULL,
51 x_last_updated_by IN NUMBER DEFAULT NULL,
52 x_last_update_login IN NUMBER DEFAULT NULL
53 ) ;
54
55 END igr_i_e_chartyp_pkg;