DBA Data[Home] [Help]

APPS.FTE_SERVICES_UI_WRAPPER dependencies on FTE_RATE_CHART_LOADER

Line 54: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;

50: IF ( WSH_DEBUG_SV.is_debug_enabled ) THEN
51: FTE_UTIL_PKG.Init_Debug(1);
52: END IF;
53:
54: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
55: FTE_RATE_CHART_PKG.RESET_ALL;
56:
57: FOR i IN p_header_table.FIRST..p_header_table.LAST LOOP
58:

Line 77: FTE_RATE_CHART_LOADER.PROCESS_RATE_CHART(p_block_header => l_block_header,

73:
74: g_list_header_id := p_header_table(i).list_header_id;
75:
76: IF ('RC' = p_chart_type) THEN
77: FTE_RATE_CHART_LOADER.PROCESS_RATE_CHART(p_block_header => l_block_header,
78: p_block_data => l_block_data,
79: p_line_number => NULL,
80: p_validate_column => FALSE,
81: p_validate => FALSE,

Line 85: FTE_RATE_CHART_LOADER.PROCESS_CHARGES_DISCOUNTS(p_block_header => l_block_header,

81: p_validate => FALSE,
82: x_status => x_status,
83: x_error_msg => x_error_msg);
84: ELSE
85: FTE_RATE_CHART_LOADER.PROCESS_CHARGES_DISCOUNTS(p_block_header => l_block_header,
86: p_block_data => l_block_data,
87: p_line_number => NULL,
88: p_validate_column => FALSE,
89: p_validate => FALSE,

Line 96: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;

92: END IF;
93:
94: IF (x_status <> -1) THEN
95: FTE_RATE_CHART_PKG.RESET_ALL;
96: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
97: RETURN;
98: END IF;
99:
100: FOR j IN p_line_table.FIRST..p_line_table.LAST LOOP

Line 126: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE (p_block_header => l_block_header,

122: END IF;
123: END IF;
124:
125: IF ('RC' = p_chart_type) THEN
126: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE (p_block_header => l_block_header,
127: p_block_data => l_line_block_data,
128: p_line_number => NULL,
129: p_validate_column => FALSE,
130: p_validate => FALSE,

Line 134: FTE_RATE_CHART_LOADER.PROCESS_CHARGES_DISCOUNTS_LINE (p_block_header => l_block_header,

130: p_validate => FALSE,
131: x_status => x_status,
132: x_error_msg => x_error_msg);
133: ELSE
134: FTE_RATE_CHART_LOADER.PROCESS_CHARGES_DISCOUNTS_LINE (p_block_header => l_block_header,
135: p_block_data => l_line_block_data,
136: p_line_number => NULL,
137: p_validate_column => FALSE,
138: p_validate => FALSE,

Line 145: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;

141: END IF;
142:
143: IF (x_status <> -1) THEN
144: FTE_RATE_CHART_PKG.RESET_ALL;
145: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
146: RETURN;
147: END IF;
148:
149: IF (p_line_table(j).break_type IS NOT NULL) THEN

Line 162: FTE_RATE_CHART_LOADER.PROCESS_RATE_BREAK(p_block_header => l_block_header,

158: l_break_block_data(l_break_block_data.COUNT)('RATE') := p_break_table(k).rate;
159: l_break_block_data(l_break_block_data.COUNT)('RATE_TYPE') := p_break_table(k).rate_type;
160: END IF;
161: END LOOP;
162: FTE_RATE_CHART_LOADER.PROCESS_RATE_BREAK(p_block_header => l_block_header,
163: p_block_data => l_break_block_data,
164: p_line_number => NULL,
165: p_validate_column => FALSE,
166: p_validate => FALSE,

Line 171: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;

167: x_status => x_status,
168: x_error_msg => x_error_msg);
169: IF (x_status <> -1) THEN
170: FTE_RATE_CHART_PKG.RESET_ALL;
171: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
172: RETURN;
173: END IF;
174:
175: END IF;

Line 178: FTE_RATE_CHART_LOADER.ADD_ATTRIBUTE(p_pricing_attribute => 'ORIGIN_ZONE',

174:
175: END IF;
176:
177: IF (p_line_table(j).origin_id IS NOT NULL) THEN
178: FTE_RATE_CHART_LOADER.ADD_ATTRIBUTE(p_pricing_attribute => 'ORIGIN_ZONE',
179: p_attr_value_from => p_line_table(j).origin_id,
180: p_line_number => l_line_number,
181: x_status => x_status,
182: x_error_msg => x_error_msg);

Line 187: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;

183: END IF;
184:
185: IF (x_status <> -1) THEN
186: FTE_RATE_CHART_PKG.RESET_ALL;
187: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
188: RETURN;
189: END IF;
190:
191: IF (p_line_table(j).dest_id IS NOT NULL) THEN

Line 192: FTE_RATE_CHART_LOADER.ADD_ATTRIBUTE(p_pricing_attribute => 'DESTINATION_ZONE',

188: RETURN;
189: END IF;
190:
191: IF (p_line_table(j).dest_id IS NOT NULL) THEN
192: FTE_RATE_CHART_LOADER.ADD_ATTRIBUTE(p_pricing_attribute => 'DESTINATION_ZONE',
193: p_attr_value_from => p_line_table(j).dest_id,
194: p_line_number => l_line_number,
195: x_status => x_status,
196: x_error_msg => x_error_msg);

Line 201: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;

197: END IF;
198:
199: IF (x_status <> -1) THEN
200: FTE_RATE_CHART_PKG.RESET_ALL;
201: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
202: RETURN;
203: END IF;
204:
205: IF (p_line_table(j).catg_id IS NOT NULL) THEN

Line 206: FTE_RATE_CHART_LOADER.ADD_ATTRIBUTE(p_pricing_attribute => 'COMMODITY',

202: RETURN;
203: END IF;
204:
205: IF (p_line_table(j).catg_id IS NOT NULL) THEN
206: FTE_RATE_CHART_LOADER.ADD_ATTRIBUTE(p_pricing_attribute => 'COMMODITY',
207: p_attr_value_from => p_line_table(j).catg_id,
208: p_line_number => l_line_number,
209: x_status => x_status,
210: x_error_msg => x_error_msg);

Line 215: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;

211: END IF;
212:
213: IF (x_status <> -1) THEN
214: FTE_RATE_CHART_PKG.RESET_ALL;
215: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
216: RETURN;
217: END IF;
218:
219: IF (p_line_table(j).service_code IS NOT NULL) THEN

Line 220: FTE_RATE_CHART_LOADER.ADD_ATTRIBUTE(p_pricing_attribute => 'SERVICE_LEVEL',

216: RETURN;
217: END IF;
218:
219: IF (p_line_table(j).service_code IS NOT NULL) THEN
220: FTE_RATE_CHART_LOADER.ADD_ATTRIBUTE(p_pricing_attribute => 'SERVICE_LEVEL',
221: p_attr_value_from => p_line_table(j).service_code,
222: p_line_number => l_line_number,
223: x_status => x_status,
224: x_error_msg => x_error_msg);

Line 229: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;

225: END IF;
226:
227: IF (x_status <> -1) THEN
228: FTE_RATE_CHART_PKG.RESET_ALL;
229: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
230: RETURN;
231: END IF;
232:
233: IF (p_line_table(j).multi_flag IS NOT NULL) THEN

Line 234: FTE_RATE_CHART_LOADER.ADD_ATTRIBUTE(p_pricing_attribute => 'PARCEL_MULTIPIECE_FLAG',

230: RETURN;
231: END IF;
232:
233: IF (p_line_table(j).multi_flag IS NOT NULL) THEN
234: FTE_RATE_CHART_LOADER.ADD_ATTRIBUTE(p_pricing_attribute => 'PARCEL_MULTIPIECE_FLAG',
235: p_attr_value_from => p_line_table(j).multi_flag,
236: p_line_number => l_line_number,
237: x_status => x_status,
238: x_error_msg => x_error_msg);

Line 243: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;

239: END IF;
240:
241: IF (x_status <> -1) THEN
242: FTE_RATE_CHART_PKG.RESET_ALL;
243: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
244: RETURN;
245: END IF;
246:
247: l_line_block_data.DELETE;

Line 254: FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS(

250:
251: l_block_data.DELETE;
252: END LOOP;
253:
254: FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS(
255: x_status => x_status,
256: x_error_msg => x_error_msg);
257:
258: FTE_RATE_CHART_PKG.RESET_ALL;

Line 259: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;

255: x_status => x_status,
256: x_error_msg => x_error_msg);
257:
258: FTE_RATE_CHART_PKG.RESET_ALL;
259: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
260:
261: IF (x_status = -1) THEN
262: commit;
263: ELSE

Line 268: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;

264: rollback;
265: END IF;
266:
267: FTE_RATE_CHART_PKG.RESET_ALL;
268: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
269: END RATE_CHART_WRAPPER;
270:
271:
272: --------------------------------------------------------