DBA Data[Home] [Help]

APPS.AP_WEB_VALIDATE_UTIL dependencies on OIE_PDM_NUMBER_T

Line 32: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL,

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,

Line 35: p_amount 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,

Line 36: p_number_of_meals IN OIE_PDM_NUMBER_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,

Line 37: p_meals_amount 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,
41: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,

Line 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,

Line 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,

Line 46: p_pdm_rate 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,

Line 48: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_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,

Line 49: p_pdm_destination_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,

Line 52: p_location_id IN OIE_PDM_NUMBER_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,
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

Line 53: p_cust_meals_amount 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:

Line 54: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,

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: );

Line 55: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,

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:

Line 56: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T

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:

Line 101: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL,

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,

Line 104: p_amount 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,

Line 105: p_number_of_meals IN OIE_PDM_NUMBER_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,

Line 106: p_meals_amount 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,
110: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,

Line 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,

Line 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,

Line 115: p_pdm_rate 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,

Line 117: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_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,

Line 118: p_pdm_destination_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,

Line 121: p_location_id IN OIE_PDM_NUMBER_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,
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

Line 122: p_cust_meals_amount 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:

Line 123: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,

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: );

Line 124: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,

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:

Line 125: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T

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(

Line 157: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL,

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,

Line 160: p_amount 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,

Line 161: p_number_of_meals IN OIE_PDM_NUMBER_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,

Line 162: p_meals_amount 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,
166: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,

Line 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,

Line 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,

Line 171: p_pdm_rate 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,

Line 173: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_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,

Line 174: p_pdm_destination_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,

Line 177: p_location_id IN OIE_PDM_NUMBER_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,
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

Line 178: p_cust_meals_amount 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: );

Line 179: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,

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:

Line 180: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,

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

Line 181: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T

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,

Line 247: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL,

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,

Line 250: p_amount 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,

Line 251: p_number_of_meals IN OIE_PDM_NUMBER_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,

Line 252: p_meals_amount 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,
256: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,

Line 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,

Line 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,

Line 261: p_pdm_rate 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,

Line 263: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_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,

Line 264: p_pdm_destination_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,

Line 267: p_location_id IN OIE_PDM_NUMBER_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,
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

Line 268: p_cust_meals_amount 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: );

Line 269: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,

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:

Line 270: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,

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(

Line 271: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T

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,