DBA Data[Home] [Help]

APPS.FTE_SOURCE_LINE_CONSOLIDATION dependencies on FTE_PROCESS_REQUESTS

Line 137: PROCEDURE Create_Hash(p_source_line_rec IN FTE_PROCESS_REQUESTS.fte_source_line_rec,

133: -- Create Hash needs to be changed to return l_group_by_flags
134: -- Only if flag is populated we should propogate the value to header level
135: --
136: -- R12 Sachin
137: PROCEDURE Create_Hash(p_source_line_rec IN FTE_PROCESS_REQUESTS.fte_source_line_rec,
138: p_action IN VARCHAR2,
139: x_hash_value OUT NOCOPY NUMBER,
140: x_hash_string OUT NOCOPY VARCHAR2,
141: x_group_by_flags OUT NOCOPY WSH_DELIVERY_AUTOCREATE.group_by_flags_rec_type) IS

Line 318: PROCEDURE Consolidate_Lines(p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,

314:
315: -- main procedure that will take in a table of source line inputs
316: -- and consolidate them based on grouping rules and sum the weights and volume
317: -- across lines and return back the consolidations
318: PROCEDURE Consolidate_Lines(p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
319: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
320: p_action IN VARCHAR2,
321: x_return_status OUT NOCOPY VARCHAR2,
322: x_msg_count OUT NOCOPY NUMBER,

Line 319: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,

315: -- main procedure that will take in a table of source line inputs
316: -- and consolidate them based on grouping rules and sum the weights and volume
317: -- across lines and return back the consolidations
318: PROCEDURE Consolidate_Lines(p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
319: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
320: p_action IN VARCHAR2,
321: x_return_status OUT NOCOPY VARCHAR2,
322: x_msg_count OUT NOCOPY NUMBER,
323: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 329: l_source_header_rec FTE_PROCESS_REQUESTS.fte_source_header_rec;

325: l_counter PLS_INTEGER;
326: l_con_id_seq PLS_INTEGER := 1;
327: l_con_id PLS_INTEGER;
328:
329: l_source_header_rec FTE_PROCESS_REQUESTS.fte_source_header_rec;
330: l_hash_string VARCHAR2(1000);
331: l_con_hash_rec source_header_hash_rec;
332:
333: l_weight_uom_code VARCHAR2(3);