1 PACKAGE HZ_CITIZENSHIP_PKG AUTHID CURRENT_USER as
2 /* $Header: ARHPCITS.pls 115.4 2003/02/10 09:35:04 ssmohan ship $ */
3
4 PROCEDURE Insert_Row(
5
6 x_CITIZENSHIP_ID IN OUT NOCOPY NUMBER,
7 x_BIRTH_OR_SELECTED IN VARCHAR2,
8 x_PARTY_ID IN NUMBER,
9 x_COUNTRY_CODE IN VARCHAR2,
10 x_DATE_DISOWNED IN DATE,
11 x_DATE_RECOGNIZED IN DATE,
12 x_DOCUMENT_REFERENCE IN VARCHAR2,
13 x_DOCUMENT_TYPE IN VARCHAR2,
14 x_END_DATE IN DATE,
15 x_STATUS IN VARCHAR2,
16 x_OBJECT_VERSION_NUMBER IN NUMBER,
17 x_CREATED_BY_MODULE IN VARCHAR2,
18 x_APPLICATION_ID IN NUMBER );
19
20
21 PROCEDURE Lock_Row(
22 x_Rowid IN VARCHAR2,
23 x_CITIZENSHIP_ID IN NUMBER,
24 x_BIRTH_OR_SELECTED IN VARCHAR2,
25 x_PARTY_ID IN NUMBER,
26 x_COUNTRY_CODE IN VARCHAR2,
27 x_DATE_DISOWNED IN DATE,
28 x_DATE_RECOGNIZED IN DATE,
29 x_DOCUMENT_REFERENCE IN VARCHAR2,
30 x_DOCUMENT_TYPE IN VARCHAR2,
31 x_CREATED_BY IN NUMBER,
32 x_CREATION_DATE IN DATE,
33 x_LAST_UPDATE_LOGIN IN NUMBER,
34 x_LAST_UPDATE_DATE IN DATE,
35 x_LAST_UPDATED_BY IN NUMBER,
36 x_REQUEST_ID IN NUMBER,
37 x_PROGRAM_APPLICATION_ID IN NUMBER,
38 x_PROGRAM_ID IN NUMBER,
39 x_PROGRAM_UPDATE_DATE IN DATE,
40 x_WH_UPDATE_DATE IN DATE,
41 x_END_DATE IN DATE,
42 x_STATUS IN VARCHAR2);
43
44
45
46 PROCEDURE Update_Row(
47
48 x_Rowid IN OUT NOCOPY VARCHAR2,
49 x_CITIZENSHIP_ID IN OUT NOCOPY NUMBER,
50 x_BIRTH_OR_SELECTED IN VARCHAR2,
51 x_PARTY_ID IN NUMBER,
52 x_COUNTRY_CODE IN VARCHAR2,
53 x_DATE_DISOWNED IN DATE,
54 x_DATE_RECOGNIZED IN DATE,
55 x_DOCUMENT_REFERENCE IN VARCHAR2,
56 x_DOCUMENT_TYPE IN VARCHAR2,
57 x_END_DATE IN DATE,
58 x_STATUS IN VARCHAR2,
59 x_OBJECT_VERSION_NUMBER IN NUMBER,
60 x_CREATED_BY_MODULE IN VARCHAR2,
61 x_APPLICATION_ID IN NUMBER
62 );
63
64
65 PROCEDURE Select_Row (
66 x_citizenship_id IN OUT NOCOPY NUMBER,
67 x_birth_or_selected OUT NOCOPY VARCHAR2,
68 x_party_id OUT NOCOPY NUMBER,
69 x_country_code OUT NOCOPY VARCHAR2,
70 x_date_disowned OUT NOCOPY DATE,
71 x_date_recognized OUT NOCOPY DATE,
72 x_document_reference OUT NOCOPY VARCHAR2,
73 x_end_date OUT NOCOPY DATE,
74 x_document_type OUT NOCOPY VARCHAR2,
75 x_status OUT NOCOPY VARCHAR2,
76 x_application_id OUT NOCOPY NUMBER,
77 x_created_by_module OUT NOCOPY VARCHAR2
78 );
79
80
81 PROCEDURE Delete_Row( x_CITIZENSHIP_ID NUMBER);
82
83 END HZ_CITIZENSHIP_PKG;