1 package WIP_WS_CUSTOM as
2 /* $Header: wipwscts.pls 120.3 2008/01/02 09:16:42 ksuleman ship $ */
3
4 function get_orderby_attribute_1(p_wip_entity_id number, p_op_seq number) return varchar2;
5 function get_orderby_attribute_2(p_wip_entity_id number, p_op_seq number) return varchar2;
6 function get_related_jobs(p_wip_entity_id number) return varchar2;
7
8 function get_custom_ready_status(
9 wip_entity_id in number,
10 operation_seq_num in number,
11 serial_number in varchar2,
12 attribute1 in varchar2,
13 attribute2 in varchar2,
14 attribute3 in varchar2
15 ) return varchar2;
16
17 procedure validate_transaction(
18 wip_entity_id in number,
19 mtl_header_id in number,
20 txn_type in varchar2,
21 from_op_seq in number,
22 from_step in varchar2,
23 to_op_seq in number,
24 to_step in varchar2,
25 txn_quantity in number,
26 txn_uom in varchar2,
27 scrap_quantity in number,
28 reject_quantity in number,
29 subinv in varchar2,
30 locator_id in number,
31 assembly_lot in varchar2,
32 assembly_serial in varchar2,
33 reason_id in number,
34 reference_str in varchar2,
35 sales_order_id in varchar2,
36 sales_order_line_id in number,
37 overcompletion in string,
38 project_id in number,
39 task_id in number,
40 scrap_acct_id in number,
41 kanban_id in number,
42 attribute1 in varchar2,
43 attribute2 in varchar2,
44 attribute3 in varchar2,
45 attribute4 in varchar2,
46 attribute5 in varchar2,
47 return_status out NOCOPY varchar2,
48 return_message out NOCOPY varchar2,
49 return_attribute1 out NOCOPY varchar2,
50 return_attribute2 out NOCOPY varchar2
51 );
52
53 procedure reorder_ops_for_shortage (
54 p_wip_job_op_tbl IN OUT NOCOPY WIP_WS_SHORTAGE.wip_job_op_tbl_type,
55 p_return_status OUT NOCOPY VARCHAR2,
56 p_retcode OUT NOCOPY NUMBER);
57
58
59 end WIP_WS_CUSTOM;
60