1 package IGR_I_A_PKGITM_PKG as
2 /* $Header: IGSRH18S.pls 120.0 2005/06/01 14:43:55 appldev noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_PERSON_ID in NUMBER,
6 X_ENQUIRY_APPL_NUMBER in NUMBER,
7 X_PACKAGE_ITEM_ID in NUMBER,
8 X_MAILED_DT in DATE,
9 X_MODE in VARCHAR2 default 'R',
10 X_DONOT_MAIL_IND IN VARCHAR2 DEFAULT NULL ,
11 X_ACTION IN VARCHAR2,
12 X_ret_status OUT NOCOPY VARCHAR2,
13 X_msg_data OUT NOCOPY VARCHAR2,
14 X_msg_count OUT NOCOPY NUMBER
15 );
16 procedure LOCK_ROW (
17 X_ROWID in VARCHAR2,
18 X_PERSON_ID in NUMBER,
19 X_ENQUIRY_APPL_NUMBER in NUMBER,
20 X_PACKAGE_ITEM_ID in NUMBER,
21 X_MAILED_DT in DATE,
22 X_DONOT_MAIL_IND IN VARCHAR2 DEFAULT NULL
23 );
24 procedure UPDATE_ROW (
25 X_ROWID in VARCHAR2,
26 X_PERSON_ID in NUMBER,
27 X_ENQUIRY_APPL_NUMBER in NUMBER,
28 X_PACKAGE_ITEM_ID in NUMBER,
29 X_MAILED_DT in DATE,
30 X_MODE in VARCHAR2 default 'R',
31 X_DONOT_MAIL_IND IN VARCHAR2 DEFAULT NULL,
32 X_ACTION IN VARCHAR2,
33 X_ret_status OUT NOCOPY VARCHAR2,
34 X_msg_data OUT NOCOPY VARCHAR2,
35 X_msg_count OUT NOCOPY NUMBER
36 );
37 procedure ADD_ROW (
38 X_ROWID in out NOCOPY VARCHAR2,
39 X_PERSON_ID in NUMBER,
40 X_ENQUIRY_APPL_NUMBER in NUMBER,
41 X_PACKAGE_ITEM_ID in NUMBER,
42 X_MAILED_DT in DATE,
43 X_MODE in VARCHAR2 default 'R',
44 X_DONOT_MAIL_IND IN VARCHAR2 DEFAULT NULL,
45 X_ACTION IN VARCHAR2,
46 X_ret_status OUT NOCOPY VARCHAR2,
47 X_msg_data OUT NOCOPY VARCHAR2,
48 X_msg_count OUT NOCOPY NUMBER
49 );
50 procedure DELETE_ROW (
51 X_ROWID in VARCHAR2
52 );
53
54 FUNCTION Get_PK_For_Validation (
55 x_person_id IN NUMBER,
56 x_enquiry_appl_number IN NUMBER,
57 x_PACKAGE_ITEM_ID IN NUMBER
58 ) RETURN BOOLEAN;
59
60 PROCEDURE GET_FK_IGR_I_APPL (
61 x_person_id IN NUMBER,
62 x_enquiry_appl_number IN NUMBER
63 );
64
65 PROCEDURE Check_Constraints (
66 Column_Name IN VARCHAR2 DEFAULT NULL,
67 Column_Value IN VARCHAR2 DEFAULT NULL
68 );
69
70 PROCEDURE Before_DML (
71 p_action IN VARCHAR2,
72 x_rowid IN VARCHAR2 DEFAULT NULL,
73 x_person_id IN NUMBER DEFAULT NULL,
74 x_enquiry_appl_number IN NUMBER DEFAULT NULL,
75 x_package_item_id IN NUMBER DEFAULT NULL,
76 x_mailed_dt IN DATE DEFAULT NULL,
77 x_creation_date IN DATE DEFAULT NULL,
78 x_created_by IN NUMBER DEFAULT NULL,
79 x_last_update_date IN DATE DEFAULT NULL,
80 x_last_updated_by IN NUMBER DEFAULT NULL,
81 x_last_update_login IN NUMBER DEFAULT NULL,
82 X_DONOT_MAIL_IND IN VARCHAR2 DEFAULT NULL
83 );
84
85 end IGR_I_A_PKGITM_PKG;