28: p_calculate_receipt_index IN BINARY_INTEGER,
29: p_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
30: p_addon_rates IN OIE_ADDON_RATES_T DEFAULT NULL,
31: p_report_line_id IN NUMBER DEFAULT NULL,
32: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
33: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
34: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
35: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
36: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,
31: p_report_line_id IN NUMBER DEFAULT NULL,
32: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
33: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
34: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
35: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
36: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,
37: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
38: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
39: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
32: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
33: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
34: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
35: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
36: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,
37: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
38: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
39: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
40: p_dinner_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
33: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
34: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
35: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
36: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,
37: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
38: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
39: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
40: p_dinner_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
41: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
37: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
38: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
39: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
40: p_dinner_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
41: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
42: p_accommodation_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
43: p_hotel_name IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
44: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
45: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
41: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
42: p_accommodation_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
43: p_hotel_name IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
44: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
45: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
46: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL,
47: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
48: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
49: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
42: p_accommodation_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
43: p_hotel_name IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
44: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
45: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
46: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL,
47: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
48: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
49: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
50: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
44: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
45: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
46: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL,
47: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
48: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
49: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
50: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
51: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
52: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
45: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
46: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL,
47: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
48: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
49: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
50: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
51: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
52: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
53: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
48: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
49: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
50: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
51: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
52: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
53: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
54: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
55: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
56: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
49: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
50: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
51: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
52: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
53: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
54: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
55: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
56: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
57:
50: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
51: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
52: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
53: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
54: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
55: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
56: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
57:
58: );
51: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
52: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
53: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
54: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
55: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
56: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
57:
58: );
59:
52: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
53: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
54: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
55: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
56: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
57:
58: );
59:
60:
97: p_calculate_receipt_index IN BINARY_INTEGER DEFAULT NULL,
98: p_bCalling_from_disconnected IN BOOLEAN,
99: p_addon_rates IN OIE_ADDON_RATES_T DEFAULT NULL,
100: p_report_line_id IN NUMBER DEFAULT NULL,
101: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
102: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
103: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
104: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
105: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,
100: p_report_line_id IN NUMBER DEFAULT NULL,
101: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
102: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
103: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
104: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
105: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,
106: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
107: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
108: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
101: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
102: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
103: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
104: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
105: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,
106: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
107: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
108: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
109: p_dinner_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
102: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
103: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
104: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
105: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,
106: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
107: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
108: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
109: p_dinner_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
110: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
106: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
107: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
108: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
109: p_dinner_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
110: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
111: p_accommodation_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
112: p_hotel_name IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
113: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
114: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
110: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
111: p_accommodation_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
112: p_hotel_name IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
113: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
114: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
115: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL,
116: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
117: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
118: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
111: p_accommodation_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
112: p_hotel_name IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
113: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
114: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
115: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL,
116: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
117: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
118: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
119: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
113: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
114: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
115: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL,
116: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
117: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
118: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
119: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
120: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
121: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
114: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
115: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL,
116: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
117: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
118: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
119: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
120: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
121: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
122: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
117: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
118: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
119: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
120: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
121: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
122: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
123: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
124: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
125: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
118: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
119: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
120: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
121: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
122: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
123: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
124: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
125: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
126:
119: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
120: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
121: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
122: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
123: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
124: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
125: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
126:
127: );
120: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
121: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
122: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
123: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
124: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
125: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
126:
127: );
128:
121: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
122: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
123: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
124: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
125: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
126:
127: );
128:
129: PROCEDURE ValidateExpLines(
153: p_calculate_receipt_index IN BINARY_INTEGER DEFAULT NULL,
154: p_bCalling_from_disconnected IN BOOLEAN,
155: p_addon_rates IN OIE_ADDON_RATES_T DEFAULT NULL,
156: p_report_line_id IN NUMBER DEFAULT NULL,
157: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
158: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
159: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
160: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
161: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,
156: p_report_line_id IN NUMBER DEFAULT NULL,
157: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
158: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
159: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
160: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
161: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,
162: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
163: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
164: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
157: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
158: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
159: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
160: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
161: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,
162: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
163: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
164: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
165: p_dinner_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
158: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
159: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
160: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
161: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,
162: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
163: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
164: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
165: p_dinner_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
166: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
162: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
163: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
164: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
165: p_dinner_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
166: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
167: p_accommodation_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
168: p_hotel_name IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
169: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
170: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
166: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
167: p_accommodation_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
168: p_hotel_name IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
169: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
170: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
171: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL,
172: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
173: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
174: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
167: p_accommodation_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
168: p_hotel_name IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
169: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
170: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
171: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL,
172: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
173: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
174: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
175: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
169: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
170: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
171: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL,
172: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
173: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
174: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
175: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
176: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
177: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
170: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
171: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL,
172: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
173: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
174: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
175: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
176: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
177: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
178: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
173: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
174: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
175: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
176: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
177: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
178: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
179: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
180: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
181: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
174: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
175: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
176: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
177: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
178: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
179: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
180: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
181: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
182: );
175: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
176: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
177: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
178: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
179: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
180: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
181: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
182: );
183:
176: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
177: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
178: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
179: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
180: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
181: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
182: );
183:
184: FUNCTION IsReceiptRequired
177: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
178: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
179: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
180: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
181: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
182: );
183:
184: FUNCTION IsReceiptRequired
185: (p_require_receipt_amount number,
243: p_bCalling_from_disconnected IN BOOLEAN,
244: p_bForBlueGray IN BOOLEAN DEFAULT FALSE,
245: p_addon_rates IN OIE_ADDON_RATES_T DEFAULT NULL,
246: p_report_line_id IN NUMBER DEFAULT NULL,
247: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
248: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
249: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
250: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
251: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,
246: p_report_line_id IN NUMBER DEFAULT NULL,
247: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
248: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
249: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
250: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
251: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,
252: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
253: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
254: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
247: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
248: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
249: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
250: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
251: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,
252: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
253: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
254: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
255: p_dinner_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
248: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
249: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
250: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
251: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,
252: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
253: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
254: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
255: p_dinner_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
256: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
252: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
253: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
254: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
255: p_dinner_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
256: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
257: p_accommodation_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
258: p_hotel_name IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
259: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
260: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
256: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
257: p_accommodation_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
258: p_hotel_name IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
259: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
260: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
261: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL,
262: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
263: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
264: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
257: p_accommodation_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
258: p_hotel_name IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
259: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
260: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
261: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL,
262: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
263: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
264: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
265: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
259: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
260: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
261: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL,
262: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
263: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
264: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
265: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
266: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
267: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
260: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
261: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL,
262: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
263: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
264: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
265: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
266: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
267: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
268: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
263: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
264: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
265: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
266: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
267: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
268: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
269: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
270: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
271: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
264: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
265: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
266: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
267: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
268: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
269: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
270: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
271: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
272: );
265: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
266: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
267: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
268: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
269: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
270: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
271: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
272: );
273:
266: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
267: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
268: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
269: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
270: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
271: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
272: );
273:
274: PROCEDURE MapColumnToCustomFields(
267: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
268: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
269: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
270: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
271: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
272: );
273:
274: PROCEDURE MapColumnToCustomFields(
275: p_userId IN NUMBER,