1 PACKAGE FLM_KANBANCARD_PUB AUTHID CURRENT_USER AS
2 /* $Header: flmkancs.pls 120.1 2011/03/24 08:37:57 sisankar noship $ */
3
4 PROCEDURE UPDATE_CARD_STATUS( P_KANBAN_ID IN NUMBER,
5 P_SUPPLY_STATUS_FROM IN NUMBER DEFAULT NULL,
6 P_SUPPLY_STATUS_TO IN NUMBER DEFAULT NULL,
7 P_CARD_STATUS_TO IN NUMBER DEFAULT NULL,
8 P_VERIFY IN VARCHAR DEFAULT 'N',
9 X_RETCODE OUT NOCOPY VARCHAR2,
10 X_RET_MSG_CODE OUT NOCOPY NUMBER,
11 X_ERR_MSG OUT NOCOPY VARCHAR2);
12
13 PROCEDURE UPDATE_CARD_STATUS( P_KANBAN_CARD_NUM IN VARCHAR2,
14 P_ORG_CODE IN VARCHAR2,
15 P_SUPPLY_STATUS_FROM IN NUMBER DEFAULT NULL,
16 P_SUPPLY_STATUS_TO IN NUMBER DEFAULT NULL,
17 P_CARD_STATUS_TO IN NUMBER DEFAULT NULL,
18 P_COMMIT_FLAG IN VARCHAR DEFAULT 'N',
19 X_RETCODE OUT NOCOPY VARCHAR2,
20 X_RET_MSG_CODE OUT NOCOPY NUMBER,
21 X_ERR_MSG OUT NOCOPY VARCHAR2);
22
23 PROCEDURE UPDATE_CARD( p_kanban_card_id IN NUMBER,
24 p_kanban_card_number IN VARCHAR2,
25 p_pull_sequence_id IN NUMBER,
26 p_inventory_item_id IN NUMBER,
27 p_organization_id IN NUMBER,
28 p_subinventory_name IN VARCHAR2,
29 p_supply_status IN NUMBER,
30 p_supply_status_to IN NUMBER,
31 p_card_status IN NUMBER,
32 p_card_status_to IN NUMBER,
33 p_kanban_card_type IN NUMBER,
34 p_source_type IN NUMBER,
35 p_kanban_size IN NUMBER,
36 p_last_update_date IN DATE,
37 p_last_updated_by IN NUMBER,
38 p_creation_date IN DATE,
39 p_created_by IN NUMBER,
40 p_locator_id IN NUMBER,
41 p_supplier_id IN NUMBER,
42 p_supplier_site_id IN NUMBER,
43 p_source_organization_id IN NUMBER,
44 p_source_subinventory IN VARCHAR2,
45 p_source_locator_id IN NUMBER,
46 p_wip_line_id IN NUMBER,
47 p_current_replnsh_cycle_id IN NUMBER,
48 p_document_type IN NUMBER,
49 p_document_header_id IN NUMBER,
50 p_document_detail_id IN NUMBER,
51 p_error_code IN VARCHAR2,
52 p_last_update_login IN NUMBER,
53 p_last_print_date IN DATE,
54 p_attribute_category IN VARCHAR2,
55 p_attribute1 IN VARCHAR2,
56 p_attribute2 IN VARCHAR2,
57 p_attribute3 IN VARCHAR2,
58 p_attribute4 IN VARCHAR2,
59 p_attribute5 IN VARCHAR2,
60 p_attribute6 IN VARCHAR2,
61 p_attribute7 IN VARCHAR2,
62 p_attribute8 IN VARCHAR2,
63 p_attribute9 IN VARCHAR2,
64 p_attribute10 IN VARCHAR2,
65 p_attribute11 IN VARCHAR2,
66 p_attribute12 IN VARCHAR2,
67 p_attribute13 IN VARCHAR2,
68 p_attribute14 IN VARCHAR2,
69 p_attribute15 IN VARCHAR2,
70 p_request_id IN NUMBER ,
71 p_program_application_id IN NUMBER ,
72 p_program_id IN NUMBER ,
73 p_program_update_date IN DATE ,
74 p_lot_item_id IN NUMBER ,
75 p_lot_number IN VARCHAR2,
76 p_lot_item_revision IN VARCHAR2,
77 p_lot_subinventory_code IN VARCHAR2,
78 p_lot_location_id IN NUMBER,
79 p_lot_quantity IN NUMBER,
80 p_replenish_quantity IN NUMBER,
81 p_need_by_date IN DATE,
82 p_source_wip_entity_id IN NUMBER,
83 p_replenishment_count IN NUMBER,
84 p_max_replenishments IN NUMBER,
85 p_disable_date IN DATE,
86 p_replacement_flag IN NUMBER,
87 P_VERIFY IN VARCHAR DEFAULT 'N',
88 X_RETCODE OUT NOCOPY VARCHAR2,
89 X_RET_MSG_CODE OUT NOCOPY NUMBER,
90 X_ERR_MSG OUT NOCOPY VARCHAR2);
91
92
93 Function validate_supply_status_change(P_KANBAN_ID IN NUMBER,
94 P_SUPPLY_STATUS_FROM IN NUMBER,
95 P_SUPPLY_STATUS_TO IN NUMBER)
96 Return NUMBER;
97
98 PROCEDURE CHANGE_CARD_STATUS_FULL(p_Kanban_Card_Id IN NUMBER,
99 p_replenish_quantity IN NUMBER DEFAULT NULL,
100 p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE,
101 X_ERR_MSG OUT NOCOPY VARCHAR2,
102 X_RET_MSG_CODE OUT NOCOPY NUMBER,
103 X_RETCODE OUT NOCOPY VARCHAR2);
104
105 END FLM_KANBANCARD_PUB;