PACKAGE: APPS.IGS_AD_SPL_TALENTS_PKG

Source

1 PACKAGE igs_ad_spl_talents_pkg AS
2 /* $Header: IGSAI97S.pls 120.0 2005/06/01 14:24:45 appldev noship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_SPL_TALENT_ID IN OUT NOCOPY NUMBER,
6        x_PERSON_ID IN NUMBER,
7        x_ADMISSION_APPL_NUMBER IN NUMBER,
8        x_SPECIAL_TALENT_TYPE_ID IN NUMBER,
9       X_MODE in VARCHAR2 default 'R'
10   );
11 
12  procedure LOCK_ROW (
13       X_ROWID in  VARCHAR2,
14        x_SPL_TALENT_ID IN NUMBER,
15        x_PERSON_ID IN NUMBER,
16        x_ADMISSION_APPL_NUMBER IN NUMBER,
17        x_SPECIAL_TALENT_TYPE_ID IN NUMBER  );
18  procedure UPDATE_ROW (
19       X_ROWID in  VARCHAR2,
20        x_SPL_TALENT_ID IN NUMBER,
21        x_PERSON_ID IN NUMBER,
22        x_ADMISSION_APPL_NUMBER IN NUMBER,
23        x_SPECIAL_TALENT_TYPE_ID IN NUMBER,
24       X_MODE in VARCHAR2 default 'R'
25   );
26 
27  procedure ADD_ROW (
28       X_ROWID in out NOCOPY VARCHAR2,
29        x_SPL_TALENT_ID IN OUT NOCOPY NUMBER,
30        x_PERSON_ID IN NUMBER,
31        x_ADMISSION_APPL_NUMBER IN NUMBER,
32        x_SPECIAL_TALENT_TYPE_ID IN NUMBER,
33       X_MODE in VARCHAR2 default 'R'
34   ) ;
35 
36 procedure DELETE_ROW (
37   X_ROWID in VARCHAR2,
38   x_mode IN VARCHAR2 DEFAULT 'R'
39 ) ;
40   FUNCTION Get_PK_For_Validation (
41     x_spl_talent_id IN NUMBER
42     ) RETURN BOOLEAN ;
43 
44   FUNCTION Get_UK_For_Validation (
45     x_special_talent_type_id IN NUMBER,
46     x_admission_appl_number IN NUMBER,
47     x_person_id IN NUMBER
48     ) RETURN BOOLEAN;
49 
50   PROCEDURE Get_FK_Igs_Ad_Code_Classes (
51     x_code_id IN NUMBER
52     );
53 
54   PROCEDURE Get_FK_Igs_Ad_Appl (
55     x_person_id IN NUMBER,
56     x_admission_appl_number IN NUMBER
57     );
58 
59   PROCEDURE Check_Constraints (
60 		 Column_Name IN VARCHAR2  DEFAULT NULL,
61 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
62   PROCEDURE Before_DML (
63     p_action IN VARCHAR2,
64     x_rowid IN VARCHAR2 DEFAULT NULL,
65     x_spl_talent_id IN NUMBER DEFAULT NULL,
66     x_person_id IN NUMBER DEFAULT NULL,
67     x_admission_appl_number IN NUMBER DEFAULT NULL,
68     x_special_talent_type_id IN NUMBER DEFAULT NULL,
69     x_creation_date IN DATE DEFAULT NULL,
70     x_created_by IN NUMBER DEFAULT NULL,
71     x_last_update_date IN DATE DEFAULT NULL,
72     x_last_updated_by IN NUMBER DEFAULT NULL,
73     x_last_update_login IN NUMBER DEFAULT NULL
74  );
75 END igs_ad_spl_talents_pkg;