1 package body WIP_WS_CUSTOM as
2 /* $Header: wipwsctb.pls 120.9 2008/01/02 09:17:04 ksuleman ship $ */
3
4
5 function get_orderby_attribute_1(p_wip_entity_id number, p_op_seq number) return varchar2
6 is
7 begin
8 -- fill in implemenation if needed
9 null;
10 return(null);
11 end;
12
13 function get_orderby_attribute_2(p_wip_entity_id number, p_op_seq number) return varchar2
14 is
15 begin
16 -- fill in implemenation if needed
17 null;
18 return(null);
19 end;
20
21 function get_related_jobs(p_wip_entity_id number) return varchar2
22 is
23 begin
24 -- fill in implemenation if needed
25 null;
26 return(null);
27 end;
28
29 function get_custom_ready_status(
30 wip_entity_id in number,
31 operation_seq_num in number,
32 serial_number in varchar2,
33 attribute1 in varchar2,
34 attribute2 in varchar2,
35 attribute3 in varchar2
36 ) return varchar2
37 is
38 begin
39 -- fill in implemenation if needed
40
41 return 'Y';
42 end get_custom_ready_status;
43
44 procedure validate_transaction(
45 wip_entity_id in number,
46 mtl_header_id in number,
47 txn_type in varchar2,
48 from_op_seq in number,
49 from_step in varchar2,
50 to_op_seq in number,
51 to_step in varchar2,
52 txn_quantity in number,
53 txn_uom in varchar2,
54 scrap_quantity in number,
55 reject_quantity in number,
56 subinv in varchar2,
57 locator_id in number,
58 assembly_lot in varchar2,
59 assembly_serial in varchar2,
60 reason_id in number,
61 reference_str in varchar2,
62 sales_order_id in varchar2,
63 sales_order_line_id in number,
64 overcompletion in string,
65 project_id in number,
66 task_id in number,
67 scrap_acct_id in number,
68 kanban_id in number,
69 attribute1 in varchar2,
70 attribute2 in varchar2,
71 attribute3 in varchar2,
72 attribute4 in varchar2,
73 attribute5 in varchar2,
74 return_status out NOCOPY varchar2,
75 return_message out NOCOPY varchar2,
76 return_attribute1 out NOCOPY varchar2,
77 return_attribute2 out NOCOPY varchar2
78 ) is
79 begin
80 -- fill in implemenation if needed
81 return_status := 'Y';
82 return_message := 'custom message';
83 end validate_transaction;
84
85
86 procedure reorder_ops_for_shortage (
87 p_wip_job_op_tbl IN OUT NOCOPY WIP_WS_SHORTAGE.wip_job_op_tbl_type,
88 p_return_status OUT NOCOPY VARCHAR2,
89 p_retcode OUT NOCOPY NUMBER) IS
90
91 begin
92 null;
93 --fill in implementation if needed
94 p_return_status := 'S';
95 end reorder_ops_for_shortage;
96
97
98 begin
99 -- Initialization
100 null;
101 end WIP_WS_CUSTOM;
102