1 PACKAGE WMS_ATF_Util_APIs AUTHID CURRENT_USER AS
2 /* $Header: WMSOPUTS.pls 120.0.12020000.1 2012/06/26 08:40:32 appldev ship $ */
3
4 PROCEDURE assign_operation_plan
5 (
6 p_api_version IN NUMBER,
7 p_init_msg_list IN VARCHAR2 DEFAULT 'F',
8 p_commit IN VARCHAR2 DEFAULT 'F',
9 p_validation_level IN NUMBER DEFAULT 100,
10 x_return_status OUT NOCOPY VARCHAR2,
11 x_msg_count OUT NOCOPY NUMBER,
12 x_msg_data OUT NOCOPY VARCHAR2,
13 p_task_id IN NUMBER,
14 p_activity_type_id IN NUMBER DEFAULT NULL,
15 p_organization_id IN NUMBER DEFAULT NULL
16 );
17
18
19 /**
20 * complete_tm_processing
21 *
22 * <p>This API conlcudes the exeuction of an operation plan.</P>
23 *
24 * <p>Inventory transaction manager should call this API:
25 * 1. After processing a transaction;
26 * 2. Before deleting the MMTT record;
27 * 3. WHen MMTT.operation_plan_ID IS NOT NULL. </P>
28 *
29 *
30 * @param x_return_status -Return Status
31 * @param x_msg_data -Returns the Error message Data
32 * @param x_msg_count -Returns the message count
33 * @param p_organization_id -Organization ID
34 * @param p_txn_header_id -MMTT.transaction_header_id (passed when TM fails to process one MMTT within a batch)
35 * @param p_txn_batch_id -MMTT.transaction_batch_id (passed when TM fails to process one MMTT within a batch)
36 * @param p_transaction_temp_id -MMTT.transaction_temp_id (passed when TM successfully processed one MMTT)
37 * @param p_tm_complete_status -Return status of TM processing: 0 - success, else failure
38 * @param p_txn_processing_mode -Mode in which TM was called: 1 - online, 2 - background, 3 - concurrent
39
40 **/
41
42
43 PROCEDURE complete_tm_processing
44 (
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 p_organization_id IN NUMBER,
49 p_txn_header_id IN NUMBER DEFAULT NULL,
50 p_txn_batch_id IN NUMBER DEFAULT NULL,
51 p_transaction_temp_id IN NUMBER DEFAULT NULL,
52 p_tm_complete_status IN NUMBER,
53 p_txn_processing_mode IN NUMBER
54 );
55
56
57 END WMS_ATF_Util_APIs;