APPS.WIP_LEADTIME_TEMP_PKG dependencies on WIP_LEADTIME_TEMP

Line 1: PACKAGE BODY WIP_LEADTIME_TEMP_PKG AS

1: PACKAGE BODY WIP_LEADTIME_TEMP_PKG AS
2: /* $Header: wipltcab.pls 120.0.12000000.2 2007/02/20 23:58:38 vjambhek ship $ */
3:
4: function wip_populate_leadtime_temp ( p_routing_sequence_id IN number,
5: p_debug_level IN number) return number

Line 34: insert into wip_leadtime_temp ( routing_sequence_id,

30: p_from_op number,
31: p_order number)
32: is
33: begin
34: insert into wip_leadtime_temp ( routing_sequence_id,
35: operation_seq_num,
36: network_order
37: )
38: values ( p_routing_seq_id,

Line 66: fnd_file.put_line (fnd_file.log, 'Inserting into wip_leadtime_temp for Network routing ' || p_routing_sequence_id );

62: )
63: and a.transition_type = 1 ;
64:
65: if p_debug_level = 1 then
66: fnd_file.put_line (fnd_file.log, 'Inserting into wip_leadtime_temp for Network routing ' || p_routing_sequence_id );
67: fnd_file.put_line(fnd_file.log, 'Operation Seq.Num ' || l_from_op || ' Order ' || l_order) ;
68: end if ;
69:
70: insert_temp(p_routing_sequence_id, l_from_op, l_order) ;

Line 76: fnd_file.put_line (fnd_file.log, 'Inserting into wip_leadtime_temp for Non Network routing ' || p_routing_sequence_id ); end if ;

72: exception
73: when no_data_found then
74: network_found := 0 ;
75: if (p_debug_level = 1) then
76: fnd_file.put_line (fnd_file.log, 'Inserting into wip_leadtime_temp for Non Network routing ' || p_routing_sequence_id ); end if ;
77: for routing_rec in routing_csr loop
78: if (p_debug_level = 1) then
79: fnd_file.put_line(fnd_file.log, 'Operation Seq.Num ' || routing_rec.operation_seq_num) ;
80: end if ;

Line 122: delete wip_leadtime_temp ;

118: function wip_delete_leadtime_temp (p_debug_level IN number) return number
119: as
120: begin
121:
122: delete wip_leadtime_temp ;
123: if (p_debug_level = 1) then
124: fnd_file.put_line (fnd_file.log, 'Deleted rows ' || sql%ROWCOUNT ||' from wip_leadtime_temp ' );
125: end if ;
126:

Line 124: fnd_file.put_line (fnd_file.log, 'Deleted rows ' || sql%ROWCOUNT ||' from wip_leadtime_temp ' );

120: begin
121:
122: delete wip_leadtime_temp ;
123: if (p_debug_level = 1) then
124: fnd_file.put_line (fnd_file.log, 'Deleted rows ' || sql%ROWCOUNT ||' from wip_leadtime_temp ' );
125: end if ;
126:
127: return 1 ; -- successfull
128:

Line 135: END WIP_LEADTIME_TEMP_PKG ;

131: return 0 ; -- Unsuccessfull
132:
133: end wip_delete_leadtime_temp ;
134:
135: END WIP_LEADTIME_TEMP_PKG ;