1 PACKAGE BIM_Response_IMPORT_PUB AS
2 /* $Header: bimpmris.pls 120.1 2005/06/14 15:29:33 appldev $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- BIM_Response_IMPORT_PUB
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17
18
19 TYPE response_hdr_rec_type IS RECORD
20 (
21 source_code Varchar2(100),
22 response_country Varchar2(30),
23 response_create_date Date,
24 response_source Varchar2(30),
25 landing_pad_hits Number,
26 survey_completed Number
27 );
28
29
30 TYPE response_grade_rec IS RECORD
31 ( response_grade VARCHAR2(30),
32 response_grade_count NUMBER
33 );
34
35 TYPE response_grade_table_type IS TABLE OF response_grade_rec INDEX BY BINARY_INTEGER;
36
37 TYPE response_invalid_rec_type IS RECORD
38 ( invalid_reason VARCHAR2(30),
39 invalid_responses NUMBER
40 );
41 TYPE response_invalid_table_type IS TABLE OF response_invalid_rec_type INDEX BY BINARY_INTEGER;
42
43
44 -- ==============================================================================
45 -- Start of Comments
46 -- ==============================================================================
47 -- API Name
48 -- Import_Responses
49 -- Type
50 -- Private
51 -- Pre-Req
52 --
53 -- Parameters
54 --
55 -- IN
56 -- p_api_version_number IN NUMBER Optional Default := 1.0
57 -- p_init_msg_list IN VARCHAR2 Optional Default := FND_API_G_FALSE
58 -- p_commit IN VARCHAR2 Optional Default := FND_API.G_FALSE
59 -- p_validation_level IN NUMBER Optional Default := FND_API.G_VALID_LEVEL_FULL
60 -- p_interface_header_id IN NUMBER
61 -- p_commit IN VARCHAR2 Optional Default := FND_API.G_FALSE
62 -- p_validation_level IN NUMBER Optional Default := FND_API.G_VALID_LEVEL_FULL
63 -- p_interface_header_id IN NUMBER
64 -- p_response_hdr_rec IN response_hdr_rec_type,
65 -- p_response_grade_table IN response_grade_table_type,
66 -- p_response_invalid_table IN response_invalid_table_type,
67
68
69
70 -- OUT
71 -- x_return_status OUT VARCHAR2
72 -- x_msg_count OUT NUMBER
73 -- x_msg_data OUT VARCHAR2
74
75 -- End of Comments
76 -- ==============================================================================
77 --
78
79 PROCEDURE IMPORT_RESPONSES(
80 p_api_version_number IN NUMBER := 1.0,
81 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
82 p_commit IN VARCHAR2 := FND_API.G_FALSE,
83 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
84 p_response_hdr_rec IN response_hdr_rec_type,
85 p_response_grade_table IN response_grade_table_type,
86 p_response_invalid_table IN response_invalid_table_type,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2);
90
91
92 END BIM_Response_IMPORT_PUB;