1 PACKAGE csp_transactions_pub AUTHID CURRENT_USER AS
2 /*$Header: csppttns.pls 120.2 2006/05/15 17:31:15 hhaugeru noship $*/
3 --Start of comments
4 --
5 -- API name : CSP_TRANSACTIONS_PUB
6 -- Type : Public
7 -- Purpose : Maintains the transactions for Spares Management
8 -- Modification History
9 -- 19-Oct-1999 phegde Created
10 --
11 -- End of comments
12
13 /* Creates a record for move order header */
14
15 PROCEDURE CREATE_MOVE_ORDER_HEADER
16 (px_header_id IN OUT NOCOPY NUMBER
17 ,p_request_number IN VARCHAR2 := FND_API.G_MISS_CHAR
18 ,p_api_version IN NUMBER
19 ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
20 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
21 ,p_date_required IN DATE
22 ,p_organization_id IN NUMBER
23 ,p_from_subinventory_code IN VARCHAR2
24 ,p_to_subinventory_code IN VARCHAR2
25 ,p_address1 IN VARCHAR2
26 ,p_address2 IN VARCHAR2
27 ,p_address3 IN VARCHAR2
28 ,p_address4 IN VARCHAR2
29 ,p_city IN VARCHAR2
30 ,p_postal_code IN VARCHAR2
31 ,p_state IN VARCHAR2
32 ,p_province IN VARCHAR2
33 ,p_country IN VARCHAR2
34 ,p_freight_carrier IN VARCHAR2
35 ,p_shipment_method IN VARCHAR2
36 ,p_autoreceipt_flag IN VARCHAR2
37 ,x_return_status OUT NOCOPY VARCHAR2
38 ,x_msg_count OUT NOCOPY NUMBER
39 ,x_msg_data OUT NOCOPY VARCHAR2
40 );
41
42 /* Creates a Move Order Line */
43
44 PROCEDURE CREATE_MOVE_ORDER_LINE
45 (p_api_version IN NUMBER
46 ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
47 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
48 ,px_line_id IN OUT NOCOPY NUMBER
49 ,p_header_id IN NUMBER
50 ,p_organization_id IN NUMBER
51 ,p_from_subinventory_code IN VARCHAR2
52 ,p_from_locator_id IN NUMBER
53 ,p_inventory_item_id IN NUMBER
54 ,p_revision IN VARCHAR2
55 ,p_lot_number IN VARCHAR2
56 ,p_serial_number_start IN VARCHAR2
57 ,p_serial_number_end IN VARCHAR2
58 ,p_quantity IN NUMBER
59 ,p_uom_code IN VARCHAR2
60 ,p_quantity_delivered IN NUMBER
61 ,p_to_subinventory_code IN VARCHAR2
62 ,p_to_locator_id IN VARCHAR2
63 ,p_to_organization_id IN NUMBER
64 ,p_service_request IN VARCHAR2
65 ,p_task_id IN NUMBER
66 ,p_task_assignment_id IN NUMBER
67 ,p_customer_po IN VARCHAR2
68 ,p_date_required IN DATE
69 ,p_comments IN VARCHAR2
70 ,x_return_status OUT NOCOPY VARCHAR2
71 ,x_msg_count OUT NOCOPY NUMBER
72 ,x_msg_data OUT NOCOPY VARCHAR2
73 );
74
75 procedure cancel_move_order_header(
76 p_header_id in number,
77 x_return_status OUT NOCOPY varchar2,
78 x_msg_count OUT NOCOPY number,
79 x_msg_data OUT NOCOPY varchar2);
80
81 procedure cancel_move_order_line(
82 p_line_id IN NUMBER,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2);
86
87 procedure reject_move_order_line(
88 p_line_id IN NUMBER,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2);
92
93 PROCEDURE TRANSACT_MATERIAL
94 (p_api_version IN NUMBER
95 ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
96 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
97 ,px_transaction_id IN OUT NOCOPY NUMBER
98 ,px_transaction_header_id IN OUT NOCOPY NUMBER
99 ,p_inventory_item_id IN NUMBER
100 ,p_organization_id IN NUMBER
101 ,p_subinventory_code IN VARCHAR2
102 ,p_locator_id IN NUMBER
103 ,p_lot_number IN VARCHAR2
104 ,p_lot_expiration_date IN DATE := NULL
105 ,p_revision IN VARCHAR2
106 ,p_serial_number IN VARCHAR2
107 ,p_to_serial_number IN VARCHAR2 := NULL
108 ,p_quantity IN NUMBER
109 ,p_uom IN VARCHAR2
110 ,p_source_id IN VARCHAR2
111 ,p_source_line_id IN NUMBER
112 ,p_transaction_type_id IN NUMBER
113 ,p_account_id IN NUMBER DEFAULT NULL
114 ,p_transfer_to_subinventory IN VARCHAR2
115 ,p_transfer_to_locator IN NUMBER
116 ,p_transfer_to_organization IN NUMBER
117 ,p_online_process_flag IN BOOLEAN := TRUE
118 ,p_transaction_source_id IN NUMBER -- added by klou 03/30/20000
119 ,p_trx_source_line_id IN NUMBER -- added by klou 03/30/20000
120 ,p_transaction_source_name IN VARCHAR2 DEFAULT NULL
121 ,p_waybill_airbill IN VARCHAR2 DEFAULT NULL
122 ,p_shipment_number IN VARCHAR2 DEFAULT NULL
123 ,p_freight_code IN VARCHAR2 DEFAULT NULL
124 ,p_reason_id IN NUMBER DEFAULT NULL
125 ,p_transaction_reference IN VARCHAR2 DEFAULT NULL
126 ,p_transaction_date IN DATE DEFAULT sysdate
127 ,p_expected_delivery_date IN DATE DEFAULT NULL
128 ,p_FINAL_COMPLETION_FLAG IN VARCHAR2 DEFAULT NULL
129 ,x_return_status OUT NOCOPY VARCHAR2
130 ,x_msg_count OUT NOCOPY NUMBER
131 ,x_msg_data OUT NOCOPY VARCHAR2
132 );
133
134 PROCEDURE transact_temp_record(
135 P_Api_Version_Number IN NUMBER,
136 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
137 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
138 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139 p_transaction_temp_id IN NUMBER,
140 px_transaction_header_id IN OUT NOCOPY NUMBER,
141 p_online_process_flag IN BOOLEAN := FALSE,
142 X_Return_Status OUT NOCOPY VARCHAR2,
143 X_Msg_Count OUT NOCOPY NUMBER,
144 X_Msg_Data OUT NOCOPY VARCHAR2
145 );
146
147 END csp_transactions_pub;