1 package WIP_WS_CUSTOM AUTHID CURRENT_USER as
2 /* $Header: wipwscts.pls 120.3.12020000.3 2012/08/24 11:54:03 sisankar ship $ */
3
4 TYPE stringArray IS TABLE OF VARCHAR2(80);
5 TYPE numberArray IS TABLE OF NUMBER;
6 PROCEDURE LOT_HOOK(
7 org_id in NUMBER,
8 wip_entity_id in NUMBER,
9 operation_seq_num in NUMBER,
10 repetitive_schedule_id in NUMBER,
11 inventory_item_id in NUMBER,
12 supply_subinv in VARCHAR2,
13 supply_locator_id in NUMBER,
14 revision in VARCHAR2,
15 primary_qty in NUMBER,
16 lot_number IN OUT NOCOPY VARCHAR2,
17 return_status OUT NOCOPY VARCHAR2, --Values 'S': Success and 'E': Error
18 return_message OUT NOCOPY VARCHAR2);
19
20 PROCEDURE MOVE_TO_STEP_HOOK(
21 org_id IN NUMBER,
22 wip_entity_id IN NUMBER,
23 fm_op_seq IN NUMBER,
24 fm_op_step_type IN NUMBER,
25 fm_dept_id IN NUMBER,
26 to_op_seq IN OUT NOCOPY NUMBER,
27 to_op_step_type IN OUT NOCOPY NUMBER,
28 return_status OUT NOCOPY VARCHAR2, --Values 'S': Success and 'E': Error
29 return_message OUT NOCOPY VARCHAR2);
30
31 function get_orderby_attribute_1(p_wip_entity_id number, p_op_seq number) return varchar2;
32 function get_orderby_attribute_2(p_wip_entity_id number, p_op_seq number) return varchar2;
33 function get_related_jobs(p_wip_entity_id number) return varchar2;
34
35 function get_custom_ready_status(
36 wip_entity_id in number,
37 operation_seq_num in number,
38 serial_number in varchar2,
39 attribute1 in varchar2,
40 attribute2 in varchar2,
41 attribute3 in varchar2
42 ) return varchar2;
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 );
79
80 procedure reorder_ops_for_shortage (
81 p_wip_job_op_tbl IN OUT NOCOPY WIP_WS_SHORTAGE.wip_job_op_tbl_type,
82 p_return_status OUT NOCOPY VARCHAR2,
83 p_retcode OUT NOCOPY NUMBER);
84
85
86 /* Hook For validating Component Serial while pressing Add in Exp transact component page. */
87 PROCEDURE validate_comp_serial( p_org_id IN NUMBER,
88 p_wip_entity_id IN NUMBER,
89 p_assy_serial IN VARCHAR2,
90 p_op_seq_num IN NUMBER,
91 p_comp_item_id IN NUMBER,
92 p_comp_serial IN VARCHAR2,
93 p_quantity IN NUMBER,
94 p_txn_type_id IN NUMBER,
95 p_return_status OUT NOCOPY VARCHAR2,
96 p_errmsg OUT NOCOPY VARCHAR2);
97
98 /* Hook to get Component issued Quantity per Assembly Serial in Exp transact component page as well as view assembly serial Page. */
99 Function get_assy_serial_issue_qty(p_org_id IN NUMBER,
100 p_job_id IN NUMBER,
101 p_op_seq IN NUMBER,
102 p_assy_item_id IN NUMBER,
103 p_assy_serial IN VARCHAR2,
104 p_comp_item_id IN NUMBER)
105 return Number;
106
107 /* Hook to get the DFF Column Mapping for Assembly Serial in Exp transact component page. */
108 Function get_assy_serial_dff_column
109 return Number;
110
111 end WIP_WS_CUSTOM;
112