PACKAGE: APPS.IGS_AD_CODE_CLASSES_PKG

Source

1 PACKAGE igs_ad_code_classes_pkg AS
2 /* $Header: IGSAI75S.pls 120.2 2005/09/21 07:03:01 appldev ship $ */
3 PROCEDURE INSERT_ROW (
4      X_ROWID in out NOCOPY VARCHAR2,
5       x_CODE_ID IN OUT NOCOPY NUMBER,
6       x_NAME IN VARCHAR2,
7       x_DESCRIPTION IN VARCHAR2,
8       x_CLASS IN VARCHAR2,
9       x_CLOSED_IND IN VARCHAR2,
10       x_SYSTEM_STATUS IN VARCHAR2 DEFAULT NULL,
11       x_SYSTEM_DEFAULT IN VARCHAR2 DEFAULT NULL,
12       X_MODE in VARCHAR2 default 'R',
13       x_class_type_code  IN VARCHAR2 DEFAULT NULL
14  );
15 
16 PROCEDURE LOCK_ROW (
17      X_ROWID in  VARCHAR2,
18       x_CODE_ID IN NUMBER,
19       x_NAME IN VARCHAR2,
20       x_DESCRIPTION IN VARCHAR2,
21       x_CLASS IN VARCHAR2,
22       x_CLOSED_IND IN VARCHAR2,
23       x_SYSTEM_STATUS IN VARCHAR2 DEFAULT NULL,
24       x_SYSTEM_DEFAULT IN VARCHAR2 DEFAULT NULL,
25       x_class_type_code  IN VARCHAR2 DEFAULT NULL
26       );
27 PROCEDURE UPDATE_ROW (
28      X_ROWID in  VARCHAR2,
29       x_CODE_ID IN NUMBER,
30       x_NAME IN VARCHAR2,
31       x_DESCRIPTION IN VARCHAR2,
32       x_CLASS IN VARCHAR2,
33       x_CLOSED_IND IN VARCHAR2,
34       x_SYSTEM_STATUS IN VARCHAR2 DEFAULT NULL,
35       x_SYSTEM_DEFAULT IN VARCHAR2 DEFAULT NULL,
36       X_MODE in VARCHAR2 default 'R',
37       x_class_type_code  IN VARCHAR2 DEFAULT NULL
38  );
39 
40 PROCEDURE ADD_ROW (
41      X_ROWID in out NOCOPY VARCHAR2,
42       x_CODE_ID IN OUT NOCOPY NUMBER,
43       x_NAME IN VARCHAR2,
44       x_DESCRIPTION IN VARCHAR2,
45       x_CLASS IN VARCHAR2,
46       x_CLOSED_IND IN VARCHAR2,
47       x_SYSTEM_STATUS IN VARCHAR2 DEFAULT NULL,
48       x_SYSTEM_DEFAULT IN VARCHAR2 DEFAULT NULL,
49       X_MODE in VARCHAR2 default 'R',
50       x_class_type_code  IN VARCHAR2 DEFAULT NULL
51  ) ;
52 
53 PROCEDURE DELETE_ROW (
54       X_ROWID in VARCHAR2
55 ) ;
56 
57 FUNCTION Get_PK_For_Validation (
58   x_code_id IN NUMBER,
59   x_closed_ind IN VARCHAR2 DEFAULT NULL
60   ) RETURN BOOLEAN ;
61 
62 FUNCTION Get_UK_For_Validation (
63   x_name IN VARCHAR2,
64   x_class IN VARCHAR2,
65   x_closed_ind IN VARCHAR2 DEFAULT NULL,
66   x_class_type_code  IN VARCHAR2 DEFAULT NULL
67   ) RETURN BOOLEAN;
68 
69 FUNCTION Get_UK2_For_Validation (
70   x_code_id IN NUMBER,
71   x_class IN VARCHAR2,
72   x_closed_ind IN VARCHAR2 DEFAULT NULL,
73   x_class_type_code  IN VARCHAR2 DEFAULT NULL
74   ) RETURN BOOLEAN;
75 
76 PROCEDURE Check_Constraints (
77  Column_Name IN VARCHAR2  DEFAULT NULL,
78  Column_Value IN VARCHAR2  DEFAULT NULL ) ;
79 
80 PROCEDURE Before_DML (
81   p_action IN VARCHAR2,
82   x_rowid IN VARCHAR2 DEFAULT NULL,
83   x_code_id IN NUMBER DEFAULT NULL,
84   x_name IN VARCHAR2 DEFAULT NULL,
85   x_description IN VARCHAR2 DEFAULT NULL,
86   x_class IN VARCHAR2 DEFAULT NULL,
87   x_closed_ind IN VARCHAR2 DEFAULT NULL,
88   x_system_status IN VARCHAR2 DEFAULT NULL,
89   x_system_default IN VARCHAR2 DEFAULT NULL,
90   x_creation_date IN DATE DEFAULT NULL,
91   x_created_by IN NUMBER DEFAULT NULL,
92   x_last_update_date IN DATE DEFAULT NULL,
93   x_last_updated_by IN NUMBER DEFAULT NULL,
94   x_last_update_login IN NUMBER DEFAULT NULL,
95   x_class_type_code  IN VARCHAR2 DEFAULT NULL
96 );
97 END igs_ad_code_classes_pkg;