PACKAGE: APPS.IGS_PE_STUP_DATA_EMT_PKG

Source

1 PACKAGE igs_pe_stup_data_emt_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSNI45S.pls 115.7 2002/11/29 01:24:44 nsidana ship $ */
3  procedure INSERT_ROW (
4        X_ROWID in out NOCOPY VARCHAR2,
5        x_SETUP_DATA_ELEMENT_ID IN OUT NOCOPY NUMBER,
6        x_PERSON_TYPE_CODE IN VARCHAR2,
7        x_DATA_ELEMENT IN VARCHAR2,
8        x_VALUE IN VARCHAR2,
9        x_REQUIRED_IND IN VARCHAR2,
10        X_MODE in VARCHAR2 default 'R',
11        X_ORG_ID in NUMBER default NULL
12 
13   );
14 
15  procedure LOCK_ROW (
16       X_ROWID in  VARCHAR2,
17        x_SETUP_DATA_ELEMENT_ID IN NUMBER,
18        x_PERSON_TYPE_CODE IN VARCHAR2,
19        x_DATA_ELEMENT IN VARCHAR2,
20        x_VALUE IN VARCHAR2,
21        x_REQUIRED_IND IN VARCHAR2
22          );
23  procedure UPDATE_ROW (
24       X_ROWID in  VARCHAR2,
25        x_SETUP_DATA_ELEMENT_ID IN NUMBER,
26        x_PERSON_TYPE_CODE IN VARCHAR2,
27        x_DATA_ELEMENT IN VARCHAR2,
28        x_VALUE IN VARCHAR2,
29        x_REQUIRED_IND IN VARCHAR2,
30       X_MODE in VARCHAR2 default 'R'
31 
32   );
33 
34  procedure ADD_ROW (
35       X_ROWID in out NOCOPY VARCHAR2,
36        x_SETUP_DATA_ELEMENT_ID IN OUT NOCOPY NUMBER,
37        x_PERSON_TYPE_CODE IN VARCHAR2,
38        x_DATA_ELEMENT IN VARCHAR2,
39        x_VALUE IN VARCHAR2,
40        x_REQUIRED_IND IN VARCHAR2,
41       X_MODE in VARCHAR2 default 'R'  ,
42        X_ORG_ID in NUMBER
43   ) ;
44 
45 procedure DELETE_ROW (
46   X_ROWID in VARCHAR2
47 ) ;
48   FUNCTION Get_PK_For_Validation (
49     x_setup_data_element_id IN NUMBER
50     ) RETURN BOOLEAN ;
51 
52   PROCEDURE Get_FK_Igs_Pe_Person_Types (
53     x_person_type_code IN VARCHAR2
54     );
55 
56   PROCEDURE Get_FK_Igs_Pe_Data_Element (
57     x_data_element IN VARCHAR2
58     );
59 
60   PROCEDURE Check_Constraints (
61 		 Column_Name IN VARCHAR2  DEFAULT NULL,
62 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
63   PROCEDURE Before_DML (
64     p_action IN VARCHAR2,
65     x_rowid IN VARCHAR2 DEFAULT NULL,
66     x_setup_data_element_id IN NUMBER DEFAULT NULL,
67     x_person_type_code IN VARCHAR2 DEFAULT NULL,
68     x_data_element IN VARCHAR2 DEFAULT NULL,
69     x_value IN VARCHAR2 DEFAULT NULL,
70     x_required_ind IN VARCHAR2 DEFAULT NULL,
71     x_creation_date IN DATE DEFAULT NULL,
72     x_created_by IN NUMBER DEFAULT NULL,
73     x_last_update_date IN DATE DEFAULT NULL,
74     x_last_updated_by IN NUMBER DEFAULT NULL,
75     x_last_update_login IN NUMBER DEFAULT NULL,
76     X_ORG_ID in NUMBER default NULL
77  );
78 END igs_pe_stup_data_emt_pkg;