[Home] [Help]
PACKAGE: APPS.CN_TRANSACTION_LOAD_PKG
Source
1 PACKAGE cn_transaction_load_pkg AUTHID CURRENT_USER AS
2 -- $Header: cnloads.pls 120.3 2005/08/10 03:44:59 hithanki noship $
3 -- +======================================================================+
4 -- | Copyright (c) 1994 Oracle Corporation |
5 -- | Redwood Shores, California, USA |
6 -- | All rights reserved. |
7 -- +======================================================================+
8 --
9 -- Package Name
10 -- cn_transaction_load_pkg
11 -- Purpose
12 -- Procedures TO load trx FROM cn_comm_lines_api TO cn_commission_headers
13 -- History
14 -- 10/21/99 Harlen Chen Created
15 -- 08/28/01 Rao Chenna acctd_transaction_amount column update logic
16 -- is modified.
17 -- Name:
18 -- Load
19 -- Purpose:
20 -- This procedure initiates a load from the API table.
21
22
23 PROCEDURE load (errbuf OUT NOCOPY VARCHAR2,
24 retcode OUT NOCOPY NUMBER,
25 p_salesrep_id IN NUMBER,
26 pp_start_date IN VARCHAR2,
27 pp_end_date IN VARCHAR2,
28 p_cls_rol_flag IN VARCHAR2,
29 p_org_id IN NUMBER
30 );
31
32
33 -- Name:
34 -- Load_Worker
35 -- Purpose:
36 -- This procedure is called by the concurrent program "CN_PROC_BATCHES_PKG.Runner"
37
38 PROCEDURE load_worker(p_physical_batch_id NUMBER,
39 p_salesrep_id NUMBER,
40 p_start_date DATE,
41 p_end_date DATE,
42 p_cls_rol_flag VARCHAR2);
43
44 -- Name:
45 -- check_api_data
46 -- Purpose:
47 -- check api data called by cn_transaction_load_pkg and cn_transaction_load_pub
48
49 PROCEDURE check_api_data(p_start_date DATE,
50 p_end_date DATE,
51 p_org_id NUMBER);
52
53 PROCEDURE ASSIGN(p_logical_batch_id NUMBER, p_org_id NUMBER);
54
55 PROCEDURE Pre_Conc_Dispatch(p_salesrep_id NUMBER,
56 p_start_date DATE ,
57 p_end_date DATE ,
58 p_org_id NUMBER);
59
60 PROCEDURE post_conc_dispatch(p_salesrep_id NUMBER,
61 p_start_date DATE,
62 p_end_date DATE ,
63 p_org_id NUMBER);
64
65 PROCEDURE void_batches(p_physical_batch_id NUMBER,
66 p_logical_batch_id NUMBER);
67
68 END cn_transaction_load_pkg;