1 PACKAGE FLM_KANBAN_CUSTOM_PKG AUTHID CURRENT_USER AS
2 /* $Header: flmkacps.pls 120.3 2011/06/12 19:14:06 sunarang noship $ */
3
4 TYPE flm_custom_uc_rec IS RECORD (
5 kanban_card_id mtl_kanban_cards.kanban_card_id%Type,
6 Unmoved_flag mtl_kanban_cards.move_status%Type,
7 last_activity_date mtl_kanban_card_activity.creation_date%Type
8 );
9
10 TYPE flm_custom_uc_table IS TABLE OF flm_custom_uc_rec;
11
12
13 TYPE flm_custom_uc_setup_rec IS RECORD (
14 status mtl_kanban_cards.supply_status%Type,
15 leadtime_days number
16 );
17
18 TYPE flm_custom_uc_setup_table IS TABLE OF flm_custom_uc_setup_rec;
19
20
21 FUNCTION custom_kanban_number (p_pull_sequence_id IN NUMBER)
22 RETURN VARCHAR2;
23
24 FUNCTION status_change_hook(kanban_card_id IN NUMBER,
25 from_supply_status IN NUMBER,
26 to_supply_status IN NUMBER)
27 RETURN NUMBER;
28
29 Procedure cancel_kanban_card_hook(p_kanban_card_id IN NUMBER);
30
31 -- This procedure will be called for creation of kanban card.
32 -- It is called with the following parameters:
33 --
34 -- P_PULL_SEQ_ID -- value of the PULL_SEQUENCE_ID column for which
35 -- kanban card is being generated
36 --
37 -- This procedure should not commit, and should not rollback unless to
38 -- an internally-defined savepoint.
39 -- The procedure's OUT variable values will replace the value in the
40 -- SUPPLIER_ID and SITE_ID
41 --
42
43
44 PROCEDURE GET_DEFAULT_SUPPLIER (p_pull_seq_id IN NUMBER,
45 x_supplier_id OUT NOCOPY NUMBER,
46 x_suppier_site_id OUT NOCOPY NUMBER,
47 x_retcode OUT NOCOPY VARCHAR2,
48 x_err_msg OUT NOCOPY VARCHAR2);
49
50 -- PROCEDURE INTRAORG_TRANSFER_HOOK
51 -- This procedure called from FLM_KANBAN_TRANSFER.COMPLETE_INTRA_TRANSFER API
52
53 PROCEDURE INTRAORG_TRANSFER_HOOK(p_kanban_card_id IN NUMBER
54 ,p_intra_order_id IN NUMBER
55 ,p_intra_line_id IN NUMBER
56 ,p_transfer_qty IN NUMBER
57 ,p_kanban_size IN NUMBER
58 ,x_retcode OUT NOCOPY VARCHAR2
59 ,x_errmsg OUT NOCOPY VARCHAR2
60 );
61
62 -- PROCEDURE INTERORG_TRANSFER_HOOK
63 -- This procedure called from FLM_KANBAN_TRANSFER.COMPLETE_INTER_TRANSFER API
64
65 PROCEDURE INTERORG_TRANSFER_HOOK(p_kanban_card_id IN NUMBER
66 ,p_inter_order_id IN NUMBER
67 ,p_inter_line_id IN NUMBER
68 ,p_transfer_qty IN NUMBER
69 ,p_kanban_size IN NUMBER
70 ,x_retcode OUT NOCOPY VARCHAR2
71 ,x_errmsg OUT NOCOPY VARCHAR2
72 );
73
74
75 -- This procedure called from FLM_RECEIPT_PUB.receive_supplier
76 PROCEDURE receive_supplier_hook
77 ( p_kanban_card_id IN NUMBER,
78 p_po_header_id IN NUMBER,
79 p_po_distribution_id IN NUMBER,
80 p_receipt_quantity IN NUMBER,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_data OUT NOCOPY VARCHAR2
83 );
84
85 -- This procedure called from FLM_RECEIPT_PUB.receive_interorg
86 PROCEDURE receive_interorg_hook
87 ( p_kanban_card_id IN NUMBER,
88 p_shipment_header_id IN NUMBER,
89 p_shipment_line_id IN NUMBER,
90 p_receipt_quantity IN NUMBER,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_data OUT NOCOPY VARCHAR2
93 );
94
95
96 -- HEALTH_FOR_PS is a procedure which allows users to write their custom code to
97 -- derive the good and bad health values for a pull sequence.
98 PROCEDURE HEALTH_FOR_PS(
99 p_pull_sequence_id IN NUMBER
100 ,x_return_status OUT NOCOPY VARCHAR2
101 ,x_error_code OUT NOCOPY VARCHAR2
102 ,x_good_health OUT NOCOPY NUMBER
103 ,x_bad_health OUT NOCOPY NUMBER
104 );
105
106 PROCEDURE UNMOVED_CARDS_HOOK(
107 p_org_id IN NUMBER
108 ,p_pull_sequence_id IN NUMBER
109 ,x_return_status OUT NOCOPY VARCHAR2
110 ,x_error_code OUT NOCOPY VARCHAR2
111 ,x_pull_sequence_id IN OUT NOCOPY NUMBER
112 ,x_uc_from_custom IN OUT NOCOPY flm_custom_uc_table
113 ,x_uc_setup_from_custom IN OUT NOCOPY flm_custom_uc_setup_table
114 );
115
116
117
118
119 END FLM_KANBAN_CUSTOM_PKG;