PACKAGE: APPS.IGS_AD_CRED_TYPES_PKG

Source

1 PACKAGE igs_ad_cred_types_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSAI90S.pls 115.10 2003/10/30 13:16:56 akadam ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_CREDENTIAL_TYPE_ID IN OUT NOCOPY NUMBER,
6        x_CREDENTIAL_TYPE IN VARCHAR2,
7        x_SYSTEM_TYPE IN VARCHAR2,
8        x_DESCRIPTION IN VARCHAR2,
9        x_CLOSED_IND IN VARCHAR2,
10        x_STEP_CODE  IN VARCHAR2 DEFAULT NULL,
11        X_MODE in VARCHAR2 default 'R'
12   );
13 
14  procedure LOCK_ROW (
15       X_ROWID in  VARCHAR2,
16        x_CREDENTIAL_TYPE_ID IN NUMBER,
17        x_CREDENTIAL_TYPE IN VARCHAR2,
18        x_SYSTEM_TYPE IN VARCHAR2,
19        x_DESCRIPTION IN VARCHAR2,
20        x_CLOSED_IND IN VARCHAR2,
21        x_STEP_CODE  IN VARCHAR2 DEFAULT NULL
22  );
23 
24  procedure UPDATE_ROW (
25       X_ROWID in  VARCHAR2,
26        x_CREDENTIAL_TYPE_ID IN NUMBER,
27        x_CREDENTIAL_TYPE IN VARCHAR2,
28        x_SYSTEM_TYPE IN VARCHAR2,
29        x_DESCRIPTION IN VARCHAR2,
30        x_CLOSED_IND IN VARCHAR2,
31        x_STEP_CODE  IN VARCHAR2 DEFAULT NULL,
32        X_MODE in VARCHAR2 default 'R'
33   );
34 
35  procedure ADD_ROW (
36       X_ROWID in out NOCOPY VARCHAR2,
37        x_CREDENTIAL_TYPE_ID IN OUT NOCOPY NUMBER,
38        x_CREDENTIAL_TYPE IN VARCHAR2,
39        x_SYSTEM_TYPE IN VARCHAR2,
40        x_DESCRIPTION IN VARCHAR2,
41        x_CLOSED_IND IN VARCHAR2,
42        x_STEP_CODE  IN VARCHAR2 DEFAULT NULL,
43       X_MODE in VARCHAR2 default 'R'
44   ) ;
45 
46 procedure DELETE_ROW (
47   X_ROWID in VARCHAR2
48 ) ;
49 
50   FUNCTION Get_PK_For_Validation (
51     x_credential_type_id IN NUMBER,
52     x_closed_ind IN VARCHAR2 DEFAULT NULL
53     ) RETURN BOOLEAN ;
54 
55   FUNCTION Get_UK_For_Validation (
56     x_credential_type IN VARCHAR2,
57     x_closed_ind IN VARCHAR2 DEFAULT NULL
58     ) RETURN BOOLEAN ;
59 
60   PROCEDURE Check_Constraints (
61 		 Column_Name IN VARCHAR2  DEFAULT NULL,
62 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
63 
64 
65   PROCEDURE Before_DML (
66     p_action IN VARCHAR2,
67     x_rowid IN VARCHAR2 DEFAULT NULL,
68     x_credential_type_id IN NUMBER DEFAULT NULL,
69     x_credential_type IN VARCHAR2 DEFAULT NULL,
70     x_system_type IN VARCHAR2 DEFAULT NULL,
71     x_description IN VARCHAR2 DEFAULT NULL,
72     x_closed_ind IN VARCHAR2 DEFAULT NULL,
73     x_step_code  IN VARCHAR2 DEFAULT NULL,
74     x_creation_date IN DATE DEFAULT NULL,
75     x_created_by IN NUMBER DEFAULT NULL,
76     x_last_update_date IN DATE DEFAULT NULL,
77     x_last_updated_by IN NUMBER DEFAULT NULL,
78     x_last_update_login IN NUMBER DEFAULT NULL
79  );
80 END igs_ad_cred_types_pkg;