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;