1 PACKAGE AST_SEARCH_RESULT_PVT AUTHID CURRENT_USER AS
2 /* $Header: astlsgns.pls 115.3 2002/02/06 11:20:25 pkm ship $ */
3 -- Start of Comments - astlsgns.pls
4 -- Package name : AST_SEARCH_RESULT_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:SEARCH_RESULT_REC_TYPE
16 -- -------------------------------------------------------
17 -- Parameters:
18 --
19 -- Required:
20 -- Defaults:
21 --
22 -- End of Comments
23
24 TYPE SEARCH_RESULT_REC_TYPE IS RECORD
25 (
26 version_number NUMBER := FND_API.G_MISS_NUM,
27 created_by NUMBER := FND_API.G_MISS_NUM,
28 creation_date DATE := FND_API.G_MISS_DATE,
29 last_updated_by NUMBER := FND_API.G_MISS_NUM,
30 last_update_date DATE := FND_API.G_MISS_DATE,
31 last_update_login NUMBER := FND_API.G_MISS_NUM,
32 search_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
33 primary_id NUMBER := FND_API.G_MISS_NUM,
34 secondary_id NUMBER := FND_API.G_MISS_NUM
35 );
36
37 G_MISS_SEARCH_RESULT_REC SEARCH_RESULT_REC_TYPE;
38 TYPE SEARCH_RESULT_TBL_TYPE IS TABLE OF SEARCH_RESULT_REC_TYPE
39 INDEX BY BINARY_INTEGER;
40 G_MISS_SEARCH_RESULT_TBL SEARCH_RESULT_TBL_TYPE;
41 GLB_SEARCH_RESULT_TBL SEARCH_RESULT_TBL_TYPE;
42 -- *******************************************************
43 -- Start of Comments
44 -- *******************************************************
45 -- API Name: Create_search_result
46 -- Type : Private
47 -- Pre-Req :
48 -- Parameters:
49 -- IN
50 --
51 -- OUT:
52 -- x_return_status OUT VARCHAR2
53 -- x_msg_count OUT NUMBER
54 -- x_msg_data OUT VARCHAR2
55 -- Version : Current version 2.0
56 --
57 -- End of Comments
58 --
59 FUNCTION GET_SEARCH_RESULT_REC
60 RETURN AST_SEARCH_RESULT_PVT.SEARCH_RESULT_REC_TYPE;
61
62 PROCEDURE CREATE_SEARCH_RESULT(
63 P_Api_Version_Number IN NUMBER,
64 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
65 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
66 p_validation_level IN NUMBER
67 := FND_API.G_VALID_LEVEL_FULL,
68 P_Search_Result_Rec IN SEARCH_RESULT_REC_TYPE
69 := G_MISS_search_result_REC,
70 X_Return_Status OUT VARCHAR2,
71 X_Msg_Count OUT NUMBER,
72 X_Msg_Data OUT VARCHAR2
73 );
74
75 PROCEDURE GET_SEARCH_RESULT(
76 P_Api_Version_Number IN NUMBER,
77 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
78 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
79 p_validation_level IN NUMBER
80 := FND_API.G_VALID_LEVEL_FULL,
81 p_count IN NUMBER,
82 x_Search_Result_Rec OUT SEARCH_RESULT_REC_TYPE,
83 X_Return_Status OUT VARCHAR2,
84 X_Msg_Count OUT NUMBER,
85 X_Msg_Data OUT VARCHAR2
86 );
87
88 PROCEDURE DELETE_SEARCH_RESULT(
89 P_Api_Version_Number IN NUMBER,
90 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92 p_validation_level IN NUMBER
93 := FND_API.G_VALID_LEVEL_FULL,
94 X_Return_Status OUT VARCHAR2,
95 X_Msg_Count OUT NUMBER,
96 X_Msg_Data OUT VARCHAR2
97 );
98
99 TYPE party_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
100 TYPE party_contact_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
101 TYPE opportunity_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
102 TYPE sales_lead_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
103 TYPE event_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
104 TYPE campaign_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
105 TYPE quote_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
106 TYPE collateral_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
107
108 glb_party_id_tbl party_id_tbl;
109 glb_party_contact_id_tbl party_contact_id_tbl;
110 glb_opportunity_id_tbl opportunity_id_tbl;
111 glb_sales_lead_tbl sales_lead_id_tbl;
112 glb_event_id_tbl event_id_tbl;
113 glb_campaign_id_tbl campaign_id_tbl;
114 glb_quote_id_tbl quote_id_tbl;
115 glb_collateral_id_tbl collateral_id_tbl;
116
117 PROCEDURE add_party_id(
118 p_api_version IN NUMBER := 1.0,
119 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120 p_commit IN VARCHAR2 := FND_API.G_FALSE,
121 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122 x_return_status OUT VARCHAR2,
123 x_msg_count OUT NUMBER,
124 x_msg_data OUT VARCHAR2,
125 p_search_type IN VARCHAR2,
126 p_party_id_tbl IN party_id_tbl,
127 x_glb_count OUT NUMBER
128 );
129
130 PROCEDURE get_party_id(
131 p_api_version IN NUMBER := 1.0,
132 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133 p_commit IN VARCHAR2 := FND_API.G_FALSE,
134 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135 x_return_status OUT VARCHAR2,
136 x_msg_count OUT NUMBER,
137 x_msg_data OUT VARCHAR2,
138 p_search_type IN VARCHAR2,
139 x_party_id_tbl OUT party_id_tbl,
140 x_glb_count OUT NUMBER
141 );
142
143 End AST_search_result_PVT;