DBA Data[Home] [Help]

PACKAGE: APPS.IGR_I_A_ITYPE_PKG

Source


1 package  IGR_I_A_ITYPE_Pkg as
2 /* $Header: IGSRH15S.pls 120.0 2005/06/01 20:34:09 appldev noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_PERSON_ID in NUMBER,
7   X_ENQUIRY_APPL_NUMBER in NUMBER,
8   X_INFO_TYPE_ID IN VARCHAR2,
9   X_MODE in VARCHAR2 default 'R'
10   );
11 procedure LOCK_ROW (
12   X_ROWID in VARCHAR2,
13   X_PERSON_ID in NUMBER,
14   X_ENQUIRY_APPL_NUMBER in NUMBER,
15   X_INFO_TYPE_ID IN VARCHAR2
16 );
17 procedure DELETE_ROW (
18  X_ROWID in VARCHAR2
19 );
20 FUNCTION Get_PK_For_Validation (
21     x_person_id IN NUMBER,
22     x_enquiry_appl_number IN NUMBER,
23     x_info_type_id IN VARCHAR2
24     ) RETURN BOOLEAN;
25 
26   PROCEDURE GET_FK_IGR_I_APPL (
27     x_person_id IN NUMBER,
28     x_enquiry_appl_number IN NUMBER
29     );
30 
31   PROCEDURE GET_FK_IGR_I_A_ITYPE (
32     x_info_type_id IN VARCHAR2
33     );
34 
35  PROCEDURE Check_Constraints (
36  Column_Name	IN	VARCHAR2	DEFAULT NULL,
37  Column_Value 	IN	VARCHAR2	DEFAULT NULL
38  );
39 
40   PROCEDURE Before_DML (
41     p_action IN VARCHAR2,
42     x_rowid IN  VARCHAR2 DEFAULT NULL,
43     x_person_id IN NUMBER DEFAULT NULL,
44     x_enquiry_appl_number IN NUMBER DEFAULT NULL,
45     x_info_type_id IN VARCHAR2 DEFAULT NULL,
46     x_creation_date IN DATE DEFAULT NULL,
47     x_created_by IN NUMBER DEFAULT NULL,
48     x_last_update_date IN DATE DEFAULT NULL,
49     x_last_updated_by IN NUMBER DEFAULT NULL,
50     x_last_update_login IN NUMBER DEFAULT NULL
51   ) ;
52 
53 end IGR_I_A_ITYPE_Pkg;