PACKAGE BODY: APPS.WIP_JSI_HOOKS

Source

1 package body WIP_JSI_Hooks as
2 /* $Header: wipjsihb.pls 120.0.12010000.2 2009/06/12 16:03:01 shjindal 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 -- Fixed bug 7638816
33 function
34 get_default_schedule_group_id (
35   p_interface_id in number,
36   p_current_schedule_group_id in number
37   )
38 return number is
39   x_schedule_group_id number ;
40 begin
41   -- Customer can replace the value below with custom logic
42   x_schedule_group_id := p_current_schedule_group_id ;
43 
44   return x_schedule_group_id ;
45 
46 end get_default_schedule_group_id ;
47 
48 
49 end WIP_JSI_Hooks ;