PACKAGE: APPS.IGS_PE_VOTE_INFO_PKG

Source

1 PACKAGE igs_pe_vote_info_pkg AS
2 /* $Header: IGSNI50S.pls 120.0 2005/06/01 22:08:01 appldev noship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_VOTER_ID IN OUT NOCOPY NUMBER,
6        x_PERSON_ID IN NUMBER,
7        x_VOTER_INFO IN VARCHAR2,
8        x_TYPE_CODE IN VARCHAR2,
9        x_VOTER_REGN_ST_DATE IN DATE,
10        x_VOTER_REGN_END_DATE IN DATE,
11       X_MODE in VARCHAR2 default 'R',
12       X_ORG_ID in NUMBER ,
13       x_TYPE_CODE_ID IN NUMBER DEFAULT NULL
14   );
15 
16  procedure LOCK_ROW (
17       X_ROWID in  VARCHAR2,
18        x_VOTER_ID IN NUMBER,
19        x_PERSON_ID IN NUMBER,
20        x_VOTER_INFO IN VARCHAR2,
21        x_TYPE_CODE IN VARCHAR2,
22        x_VOTER_REGN_ST_DATE IN DATE,
23        x_VOTER_REGN_END_DATE IN DATE  ,
24            x_TYPE_CODE_ID IN NUMBER  DEFAULT NULL
25      );
26  procedure UPDATE_ROW (
27       X_ROWID in  VARCHAR2,
28        x_VOTER_ID IN NUMBER,
29        x_PERSON_ID IN NUMBER,
30        x_VOTER_INFO IN VARCHAR2,
31        x_TYPE_CODE IN VARCHAR2,
32        x_VOTER_REGN_ST_DATE IN DATE,
33        x_VOTER_REGN_END_DATE IN DATE,
34       X_MODE in VARCHAR2 default 'R'  ,
35              x_TYPE_CODE_ID IN NUMBER  DEFAULT NULL
36   );
37 
38  procedure ADD_ROW (
39       X_ROWID in out NOCOPY VARCHAR2,
40        x_VOTER_ID IN OUT NOCOPY NUMBER,
41        x_PERSON_ID IN NUMBER,
42        x_VOTER_INFO IN VARCHAR2,
43        x_TYPE_CODE IN VARCHAR2,
44        x_VOTER_REGN_ST_DATE IN DATE,
45        x_VOTER_REGN_END_DATE IN DATE,
46       X_MODE in VARCHAR2 default 'R',
47       X_ORG_ID in NUMBER ,
48              x_TYPE_CODE_ID IN NUMBER  DEFAULT NULL
49   ) ;
50 
51 procedure DELETE_ROW (
52   X_ROWID in VARCHAR2,
53   x_mode IN VARCHAR2 DEFAULT 'R'
54 ) ;
55   FUNCTION Get_PK_For_Validation (
56     x_voter_id IN NUMBER
57     ) RETURN BOOLEAN ;
58 
59   PROCEDURE Get_FK_Igs_Pe_Person (
60     x_person_id IN NUMBER
61     );
62 
63   PROCEDURE Check_Constraints (
64 		 Column_Name IN VARCHAR2  DEFAULT NULL,
65 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
66   PROCEDURE Before_DML (
67     p_action IN VARCHAR2,
68     x_rowid IN VARCHAR2 DEFAULT NULL,
69     x_voter_id IN NUMBER DEFAULT NULL,
70     x_person_id IN NUMBER DEFAULT NULL,
71     x_voter_info IN VARCHAR2 DEFAULT NULL,
72     x_type_code IN VARCHAR2 DEFAULT NULL,
73     x_type_code_id IN NUMBER DEFAULT NULL,
74     x_voter_regn_st_date IN DATE DEFAULT NULL,
75     x_voter_regn_end_date IN DATE DEFAULT NULL,
76     x_creation_date IN DATE DEFAULT NULL,
77     x_created_by IN NUMBER DEFAULT NULL,
78     x_last_update_date IN DATE DEFAULT NULL,
79     x_last_updated_by IN NUMBER DEFAULT NULL,
80     x_last_update_login IN NUMBER DEFAULT NULL,
81     x_org_id IN NUMBER DEFAULT NULL
82  );
83 END igs_pe_vote_info_pkg;