PACKAGE: APPS.IGS_AD_PRCS_CAT_PKG

Source

1 PACKAGE igs_ad_prcs_cat_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSAI09S.pls 115.12 2003/10/30 13:11:07 akadam ship $ */
3  PROCEDURE INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5 			x_ORG_ID IN NUMBER,
6        x_ADMISSION_CAT IN VARCHAR2,
7        x_S_ADMISSION_PROCESS_TYPE IN VARCHAR2,
8        x_OFFER_RESPONSE_OFFSET IN NUMBER,
9       X_MODE in VARCHAR2 default 'R',
10       X_CLOSED_IND IN VARCHAR2 DEFAULT 'N'
11   );
12 
13  PROCEDURE LOCK_ROW (
14       X_ROWID in  VARCHAR2,
15        x_ADMISSION_CAT IN VARCHAR2,
16        x_S_ADMISSION_PROCESS_TYPE IN VARCHAR2,
17        x_OFFER_RESPONSE_OFFSET IN NUMBER,
18        X_CLOSED_IND IN VARCHAR2 DEFAULT 'N'
19        );
20  PROCEDURE UPDATE_ROW (
21       X_ROWID in  VARCHAR2,
22        x_ADMISSION_CAT IN VARCHAR2,
23        x_S_ADMISSION_PROCESS_TYPE IN VARCHAR2,
24        x_OFFER_RESPONSE_OFFSET IN NUMBER,
25       X_MODE in VARCHAR2 default 'R' ,
26      X_CLOSED_IND IN VARCHAR2 DEFAULT 'N'
27   );
28 
29  PROCEDURE ADD_ROW (
30       X_ROWID in out NOCOPY VARCHAR2,
31 			x_ORG_ID IN NUMBER,
32        x_ADMISSION_CAT IN VARCHAR2,
33        x_S_ADMISSION_PROCESS_TYPE IN VARCHAR2,
34        x_OFFER_RESPONSE_OFFSET IN NUMBER,
35       X_MODE in VARCHAR2 default 'R'  ,
36      X_CLOSED_IND IN VARCHAR2 DEFAULT 'N'
37   ) ;
38 
39 PROCEDURE DELETE_ROW (
40   X_ROWID in VARCHAR2
41 ) ;
42 
43   FUNCTION Get_PK_For_Validation (
44     x_admission_cat IN VARCHAR2,
45     x_s_admission_process_type IN VARCHAR2,
46     x_closed_ind IN VARCHAR2 DEFAULT NULL
47     ) RETURN BOOLEAN ;
48 
49   PROCEDURE Get_FK_Igs_Ad_Cat (
50     x_admission_cat IN VARCHAR2
51     );
52 
53 
54   PROCEDURE GET_FK_IGS_LOOKUPS_VIEW(
55     x_s_admission_process_type IN VARCHAR2
56     ) ;
57 
58   PROCEDURE Check_Constraints (
59 		 Column_Name IN VARCHAR2  DEFAULT NULL,
60 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
61 
62   PROCEDURE BeforeRowInsertUpdateDelete1(
63     p_inserting IN BOOLEAN DEFAULT FALSE,
64     p_updating IN BOOLEAN DEFAULT FALSE,
65     p_deleting IN BOOLEAN DEFAULT FALSE
66     );
67 
68   PROCEDURE Before_DML (
69     p_action IN VARCHAR2,
70     x_rowid IN VARCHAR2 DEFAULT NULL,
71 			x_ORG_ID IN NUMBER DEFAULT NULL,
72     x_admission_cat IN VARCHAR2 DEFAULT NULL,
73     x_s_admission_process_type IN VARCHAR2 DEFAULT NULL,
74     x_offer_response_offset IN NUMBER DEFAULT NULL,
75     x_creation_date IN DATE DEFAULT NULL,
76     x_created_by IN NUMBER DEFAULT NULL,
77     x_last_update_date IN DATE DEFAULT NULL,
78     x_last_updated_by IN NUMBER DEFAULT NULL,
79     x_last_update_login IN NUMBER DEFAULT NULL,
80     X_CLOSED_IND IN VARCHAR2 DEFAULT 'N'
81  );
82 END igs_ad_prcs_cat_pkg;