1 PACKAGE AMS_RUNTIME_CAMP_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvrcas.pls 115.8 2004/07/12 09:23:44 vnuti ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_RUNTIME_CAMP_PVT';
5
6 TYPE camp_cursor is REF CURSOR;
7 TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
8 TYPE off_rec_type IS RECORD
9 (
10 activity_offer_id NUMBER,
11 qp_list_header_id NUMBER,
12 camp_schedule_id NUMBER
13 );
14 TYPE off_rec_type_tbl IS TABLE OF off_rec_type INDEX BY BINARY_INTEGER;
15
16 TYPE qp_rec_type IS RECORD
17 (
18 o_activity_offer_id NUMBER,
19 o_qp_list_header_id NUMBER
20 );
21 TYPE qp_rec_type_tbl IS TABLE OF qp_rec_type INDEX BY BINARY_INTEGER;
22
23
24 PROCEDURE getFilteredSchedulesFromList
25 (p_api_version_number IN NUMBER,
26 p_init_msg_list IN VARCHAR2,
27 p_application_id IN NUMBER,
28 p_party_id IN NUMBER,
29 p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
30 p_sched_lst IN JTF_NUMBER_TABLE,
31 p_org_id IN NUMBER,
32 p_bus_prior IN VARCHAR2 := NULL,
33 p_bus_prior_order IN VARCHAR2 := NULL,
34 p_filter_ref_code IN VARCHAR2 := NULL,
35 p_max_ret_num IN NUMBER,
36 x_sched_lst OUT NOCOPY JTF_Number_Table,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2
40 );
41
42 PROCEDURE getRelSchedulesForQuoteAndCust
43 (p_api_version_number IN NUMBER,
44 p_init_msg_list IN VARCHAR2,
45 p_application_id IN NUMBER,
46 p_party_id IN NUMBER,
47 p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
48 p_currency_code IN VARCHAR2 := NULL,
49 p_quote_id IN NUMBER,
50 p_msite_id IN NUMBER,
51 p_top_section_id IN NUMBER,
52 p_org_id IN NUMBER,
53 p_rel_type_code IN VARCHAR2,
54 p_bus_prior IN VARCHAR2,
55 p_bus_prior_order IN VARCHAR2,
56 p_filter_ref_code IN VARCHAR2,
57 p_price_list_id IN NUMBER := NULL,
58 p_max_ret_num IN NUMBER := NULL,
59 x_sched_lst OUT NOCOPY JTF_NUMBER_TABLE,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2
63 );
64
65 PROCEDURE getRelSchedulesForProdAndCust
66 (p_api_version_number IN NUMBER,
67 p_init_msg_list IN VARCHAR2,
68 p_application_id IN NUMBER,
69 p_party_id IN NUMBER,
70 p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
71 p_currency_code IN VARCHAR2 := NULL,
72 p_prod_lst IN JTF_NUMBER_TABLE,
73 p_msite_id IN NUMBER,
74 p_top_section_id IN NUMBER,
75 p_org_id IN NUMBER,
76 p_rel_type_code IN VARCHAR2,
77 p_bus_prior IN VARCHAR2,
78 p_bus_prior_order IN VARCHAR2,
79 p_filter_ref_code IN VARCHAR2,
80 p_price_list_id IN NUMBER := NULL,
81 p_max_ret_num IN NUMBER := NULL,
82 x_sched_lst OUT NOCOPY JTF_NUMBER_TABLE,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2
86 );
87
88 PROCEDURE getFilteredOffersFromList
89 (p_api_version_number IN NUMBER,
90 p_init_msg_list IN VARCHAR2,
91 p_application_id IN NUMBER,
92 p_party_id IN NUMBER,
93 p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
94 p_currency_code IN VARCHAR2 := NULL,
95 p_offer_lst IN JTF_NUMBER_TABLE,
96 p_org_id IN NUMBER,
97 p_bus_prior IN VARCHAR2 := NULL,
98 p_bus_prior_order IN VARCHAR2 := NULL,
99 p_filter_ref_code IN VARCHAR2 := NULL,
100 p_price_list_id IN NUMBER := NULL,
101 p_max_ret_num IN NUMBER,
102 x_offer_lst OUT NOCOPY JTF_Number_Table,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2
106 );
107
108 PROCEDURE getRelOffersForQuoteAndCust
109 (p_api_version_number IN NUMBER,
110 p_init_msg_list IN VARCHAR2,
111 p_application_id IN NUMBER,
112 p_party_id IN NUMBER,
113 p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
114 p_currency_code IN VARCHAR2 := NULL,
115 p_quote_id IN NUMBER,
116 p_msite_id IN NUMBER,
117 p_top_section_id IN NUMBER,
118 p_org_id IN NUMBER,
119 p_rel_type_code IN VARCHAR2,
120 p_bus_prior IN VARCHAR2,
121 p_bus_prior_order IN VARCHAR2,
122 p_filter_ref_code IN VARCHAR2,
123 p_price_list_id IN NUMBER := NULL,
124 p_max_ret_num IN NUMBER := NULL,
125 x_offer_lst OUT NOCOPY JTF_NUMBER_TABLE,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2
129 );
130
131 PROCEDURE getRelOffersForProdAndCust
132 (p_api_version_number IN NUMBER,
133 p_init_msg_list IN VARCHAR2,
134 p_application_id IN NUMBER,
135 p_party_id IN NUMBER,
136 p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
137 p_currency_code IN VARCHAR2 := NULL,
138 p_prod_lst IN JTF_NUMBER_TABLE,
139 p_msite_id IN NUMBER,
140 p_top_section_id IN NUMBER,
141 p_org_id IN NUMBER,
142 p_rel_type_code IN VARCHAR2,
143 p_bus_prior IN VARCHAR2,
144 p_bus_prior_order IN VARCHAR2,
145 p_filter_ref_code IN VARCHAR2,
146 p_price_list_id IN NUMBER := NULL,
147 p_max_ret_num IN NUMBER := NULL,
148 x_offer_lst OUT NOCOPY JTF_NUMBER_TABLE,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2
152 );
153
154
155 END AMS_RUNTIME_CAMP_PVT;