PACKAGE: APPS.IGS_AD_SPL_INTERESTS_PKG

Source

1 PACKAGE igs_ad_spl_interests_pkg AS
2 /* $Header: IGSAI96S.pls 120.1 2005/09/08 16:28:14 appldev noship $ */
3   procedure INSERT_ROW (
4     X_ROWID in out NOCOPY VARCHAR2,
5     x_SPL_INTEREST_ID IN OUT NOCOPY NUMBER,
6     x_PERSON_ID IN NUMBER,
7     x_ADMISSION_APPL_NUMBER IN NUMBER,
8     x_SPECIAL_INTEREST_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_INTEREST_ID IN NUMBER,
15     x_PERSON_ID IN NUMBER,
16     x_ADMISSION_APPL_NUMBER IN NUMBER,
17     x_SPECIAL_INTEREST_TYPE_ID IN NUMBER
18   );
19 
20   procedure UPDATE_ROW (
21     X_ROWID in  VARCHAR2,
22     x_SPL_INTEREST_ID IN NUMBER,
23     x_PERSON_ID IN NUMBER,
24     x_ADMISSION_APPL_NUMBER IN NUMBER,
25     x_SPECIAL_INTEREST_TYPE_ID IN NUMBER,
26     X_MODE in VARCHAR2 default 'R'
27   );
28 
29   procedure ADD_ROW (
30     X_ROWID in out NOCOPY VARCHAR2,
31     x_SPL_INTEREST_ID IN OUT NOCOPY NUMBER,
32     x_PERSON_ID IN NUMBER,
33     x_ADMISSION_APPL_NUMBER IN NUMBER,
34     x_SPECIAL_INTEREST_TYPE_ID IN NUMBER,
35     X_MODE in VARCHAR2 default 'R'
36   );
37 
38   procedure DELETE_ROW (
39     X_ROWID in VARCHAR2,
40   x_mode IN VARCHAR2 DEFAULT 'R'
41   );
42 
43   FUNCTION Get_PK_For_Validation (
44     x_spl_interest_id IN NUMBER
45   ) RETURN BOOLEAN ;
46 
47   FUNCTION Get_UK_For_Validation (
48     x_special_interest_type_id IN NUMBER,
49     x_admission_appl_number IN NUMBER,
50     x_person_id IN NUMBER
51   ) RETURN BOOLEAN;
52 
53   PROCEDURE Get_FK_Igs_Ad_Appl (
54     x_person_id IN NUMBER,
55     x_admission_appl_number IN NUMBER
56     );
57 
58   PROCEDURE Get_FK_Igs_Ad_Code_Classes (
59     x_code_id IN NUMBER
60   );
61 
62   PROCEDURE Check_Constraints (
63     Column_Name IN VARCHAR2  DEFAULT NULL,
64     Column_Value IN VARCHAR2  DEFAULT NULL
65   );
66 
67   PROCEDURE Before_DML (
68     p_action IN VARCHAR2,
69     x_rowid IN VARCHAR2 DEFAULT NULL,
70     x_spl_interest_id IN NUMBER DEFAULT NULL,
71     x_person_id IN NUMBER DEFAULT NULL,
72     x_admission_appl_number IN NUMBER DEFAULT NULL,
73     x_special_interest_type_id IN NUMBER 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_spl_interests_pkg;