PACKAGE: APPS.IGS_AD_PRD_AD_PRC_CA_PKG

Source

1 PACKAGE igs_ad_prd_ad_prc_ca_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSAI30S.pls 115.7 2003/10/30 13:12:19 akadam ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_ADM_CAL_TYPE in VARCHAR2,
6   X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
7   X_ADMISSION_CAT in VARCHAR2,
8   X_S_ADMISSION_PROCESS_TYPE in VARCHAR2,
9   X_MODE in VARCHAR2 default 'R' ,
10   x_closed_ind IN VARCHAR2 DEFAULT 'N',
11   x_single_response_flag IN VARCHAR2 DEFAULT 'N',
12   x_include_sr_in_rollover_flag IN VARCHAR2 DEFAULT 'N'
13   );
14 procedure UPDATE_ROW (
15   X_ROWID in VARCHAR2,
16   X_ADM_CAL_TYPE in VARCHAR2,
17   X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
18   X_ADMISSION_CAT in VARCHAR2,
19   X_S_ADMISSION_PROCESS_TYPE in VARCHAR2,
20   X_MODE in VARCHAR2 default 'R' ,
21   x_closed_ind IN VARCHAR2 DEFAULT 'N',
22   x_single_response_flag IN VARCHAR2 DEFAULT 'N',
23   x_include_sr_in_rollover_flag IN VARCHAR2 DEFAULT 'N'
24   );
25 
26 procedure LOCK_ROW (
27   X_ROWID in VARCHAR2,
28   X_ADM_CAL_TYPE in VARCHAR2,
29   X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
30   X_ADMISSION_CAT in VARCHAR2,
31   X_S_ADMISSION_PROCESS_TYPE in VARCHAR2,
32   x_closed_ind IN VARCHAR2 DEFAULT 'N',
33   x_single_response_flag IN VARCHAR2 DEFAULT 'N',
34   x_include_sr_in_rollover_flag IN VARCHAR2 DEFAULT 'N'
35 );
36 procedure DELETE_ROW (
37   X_ROWID in VARCHAR2
38 );
39 FUNCTION Get_PK_For_Validation (
40     x_adm_cal_type IN VARCHAR2,
41     x_adm_ci_sequence_number IN NUMBER,
42     x_admission_cat IN VARCHAR2,
43     x_s_admission_process_type IN VARCHAR2,
44     x_closed_ind IN VARCHAR2 DEFAULT NULL
45     )
46 RETURN BOOLEAN;
47 
48 PROCEDURE Check_constraints(
49   	Column_Name 	IN	VARCHAR2 DEFAULT NULL,
50 	Column_Value 	IN	VARCHAR2 DEFAULT NULL
51 	);
52 
53   PROCEDURE Before_DML (
54     p_action IN VARCHAR2,
55     x_rowid IN VARCHAR2 DEFAULT NULL,
56     x_adm_cal_type IN VARCHAR2 DEFAULT NULL,
57     x_adm_ci_sequence_number IN NUMBER DEFAULT NULL,
58     x_admission_cat IN VARCHAR2 DEFAULT NULL,
59     x_s_admission_process_type IN VARCHAR2 DEFAULT NULL,
60     x_creation_date IN DATE DEFAULT NULL,
61     x_created_by IN NUMBER DEFAULT NULL,
62     x_last_update_date IN DATE DEFAULT NULL,
63     x_last_updated_by IN NUMBER DEFAULT NULL,
64     x_last_update_login IN NUMBER DEFAULT NULL,
65     x_closed_ind IN VARCHAR2 DEFAULT 'N',
66     x_single_response_flag IN VARCHAR2 DEFAULT 'N',
67     x_include_sr_in_rollover_flag IN VARCHAR2 DEFAULT 'N'
68   );
69 
70   PROCEDURE GET_FK_IGS_AD_PERD_AD_CAT (
71     x_adm_cal_type IN VARCHAR2,
72     x_adm_ci_sequence_number IN NUMBER,
73     x_admission_cat IN VARCHAR2
74     );
75 
76   PROCEDURE GET_FK_IGS_AD_PRCS_CAT (
77     x_admission_cat IN VARCHAR2,
78     x_s_admission_process_type IN VARCHAR2
79     );
80 end igs_ad_prd_ad_prc_ca_pkg;