PACKAGE BODY: APPS.WIP_JSI_HOOKS

Source

1 package body WIP_JSI_Hooks as
2 /* $Header: wipjsihb.pls 115.8 2002/12/12 14:48:13 rmahidha ship $ */
3 
4 
5 function
6 get_default_build_sequence (
7   p_interface_id in number,
8   p_current_build_sequence in number
9   )
10 return number is
11   x_build_sequence number ;
12 begin
13 
14   x_build_sequence := p_current_build_sequence ;
15 
16  /*
17   begin
18 
19   select	WDD.load_seq_number
20     into	x_build_sequence
21     from	wip_job_schedule_interface WJSI,
22 		wsh_delivery_details WDD
23     where	WJSI.interface_id = p_interface_id
24 		and WJSI.source_code = 'WICDOL'
25 		and WDD.source_line_id = WJSI.source_line_id;
26    */
27 
28   return x_build_sequence ;
29 
30 end get_default_build_sequence ;
31 
32 
33 end WIP_JSI_Hooks ;