1 PACKAGE IGR_INQUIRY_LINES_PKG AS
2 /* $Header: IGSRT04S.pls 120.0 2005/06/01 16:38:50 appldev noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_sales_lead_line_id OUT NOCOPY NUMBER,
7 x_person_id IN NUMBER,
8 x_enquiry_appl_number IN NUMBER,
9 x_enquiry_dt IN DATE,
10 x_inquiry_method_code IN VARCHAR2,
11 x_preference IN NUMBER DEFAULT NULL,
12 x_ret_status OUT NOCOPY VARCHAR2,
13 x_msg_data OUT NOCOPY VARCHAR2,
14 x_msg_count OUT NOCOPY NUMBER,
15 x_mode IN VARCHAR2 DEFAULT 'R',
16 x_product_category_id IN NUMBER,
17 x_product_category_set_id IN NUMBER
18 );
19
20 PROCEDURE update_row (
21 x_rowid IN VARCHAR2,
22 x_sales_lead_line_id IN NUMBER,
23 x_person_id IN NUMBER,
24 x_enquiry_appl_number IN NUMBER,
25 x_enquiry_dt IN DATE,
26 x_inquiry_method_code IN VARCHAR2,
27 x_preference IN NUMBER DEFAULT NULL,
28 x_mode IN VARCHAR2 DEFAULT 'R' ,
29 x_ret_status OUT NOCOPY VARCHAR2,
30 x_msg_data OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_product_category_id IN NUMBER,
33 x_product_category_set_id IN NUMBER
34 );
35
36 FUNCTION get_uk_for_validation (
37 x_person_id IN NUMBER,
38 x_enquiry_appl_number IN NUMBER,
39 x_rowid IN VARCHAR2 DEFAULT NULL,
40 x_product_category_id IN NUMBER,
41 x_product_category_set_id IN NUMBER
42 ) RETURN BOOLEAN ;
43
44 END IGR_INQUIRY_LINES_PKG;