1 PACKAGE cn_transaction_load_pub AUTHID CURRENT_USER AS
2 -- $Header: cnploads.pls 120.3 2005/08/10 03:45:53 hithanki noship $
3
4 -- Start of Comments
5 -- API name : Load
6 -- Type : Public.
7 -- Pre-reqs : None.
8 -- Usage : Used to load transactions from API table (CN_COMM_LINES_API)
9 -- to HEADER table (CN_COMMISSION_HEADERS)
10 -- Parameters :
11 -- IN : p_api_version IN NUMBER Require
12 -- : p_init_msg_list IN VARCHAR2 Optional
13 -- Default = FND_API.G_FALSE
14 -- : p_commit IN VARCHAR2 Optional
15 -- Default = FND_API.G_FALSE
16 -- : p_validation_level IN NUMBER Optional
17 -- Default = FND_API.G_VALID_LEVEL_FULL
18 -- OUT : x_return_status OUT VARCHAR2(1)
19 -- : x_msg_count OUT NUMBER
20 -- : x_msg_data OUT VARCHAR2(2000)
21 -- : x_loading_status OUT VARCHAR2
22 -- : x_process_audit_id OUT NUMBER
23 -- Version : Current version 1.0
24 -- Initial version 1.0
25 --
26 -- Notes :
27 -- This procedure loads trx from CN_COMM_LINES_API to
28 -- CN_COMMISSION_HEADERS, update cn_process_batches,
29 -- and perform transaction classification and rollup.
30 --
31 -- Special Notes :
32 --
33 -- End of comments
34
35
36 PROCEDURE load
37 (
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40 p_commit IN VARCHAR2 := FND_API.G_FALSE,
41 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42 p_salesrep_id IN NUMBER,
43 p_start_date IN DATE,
44 p_end_date IN DATE,
45 p_cls_rol_flag IN VARCHAR2,
46 p_org_id IN NUMBER,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2,
50 x_loading_status OUT NOCOPY VARCHAR2,
51 x_process_audit_id OUT NOCOPY NUMBER
52 );
53
54 END cn_transaction_load_pub;