1 PACKAGE CN_SCA_CREDITS_BATCH_PUB AUTHID CURRENT_USER AS
2 -- $Header: cnpscabs.pls 120.3.12010000.2 2008/12/04 06:18:31 gmarwah ship $
3 /*#
4 * This package is accessed by users of the Sales Credit Allocation Module via
5 * the concurrent program. The package takes start and end dates and the
6 * Transaction Source as input and processes the transactions available in
7 * the Interface tables. After completing the processing it populates the
8 * results in the output Interface tables
9 * @rep:scope public
10 * @rep:product CN
11 * @rep:displayname Get Sales Credits Public Application Program Interface
12 * @rep:lifecycle active
13 * @rep:compatibility S
14 * @rep:category BUSINESS_ENTITY CN_COMP_PLANS
15 */
16 -- +======================================================================+
17 -- | Copyright (c) 1994 Oracle Corporation |
18 -- | Redwood Shores, California, USA |
19 -- | All rights reserved. |
20 -- +======================================================================+
21 --
22 -- Package Name
23 -- CN_SCA_CREDITS_BATCH_PUB
24 -- Purpose
25 -- This package is a public API for processing Credit Rules and associated
26 -- allocation percentages.
27 -- History
28 -- 06/26/03 Rao.Chenna Created
29 --
30 PROCEDURE Conc_Submit(
31 x_conc_program IN VARCHAR2,
32 x_parent_proc_audit_id IN NUMBER,
33 x_physical_batch_id IN NUMBER,
34 x_start_date IN DATE,
35 x_end_date IN DATE,
36 p_transaction_source IN VARCHAR2,
37 p_org_id IN NUMBER,
38 x_request_id IN OUT NOCOPY NUMBER);
39 --
40 PROCEDURE conc_dispatch(
41 x_parent_proc_audit_id IN NUMBER,
42 x_start_date IN DATE,
43 x_end_date IN DATE,
44 x_logical_batch_id IN NUMBER,
45 x_transaction_source IN VARCHAR2,
46 p_org_id IN NUMBER);
47 --
48 PROCEDURE split_batches(
49 p_logical_batch_id IN NUMBER,
50 p_start_date IN DATE,
51 p_end_date IN DATE,
52 p_transaction_source IN VARCHAR2,
53 p_org_id IN number,
54 x_size OUT NOCOPY NUMBER);
55 --
56 /*--------------------------------------------------------------------------
57 API name : get_sales_credits
58 Type : Public
59 Pre-reqs :
60 Usage :
61 Desc :
62 Parameters
63 IN :
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
66 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
67 p_commit IN VARCHAR2 := CN_API.G_FALSE,
68
69 OUT NOCOPY :
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73
74 Notes :
75 .
76 --------------------------------------------------------------------------*/
77 /*#
78 * The GET_SALES_CREDITS procedure in CN_SCA_CREDITS_BATCH_PUB is used for
79 * determining the distribution of sales credit allocation percentages among the
80 * different resources and role combinations who took part in the sales transaction.
81 * The transactions are loaded into the CN_SCA_HEADERS_INTERFACE table before calling
82 * this procedure. This procedure processes the transactions and identifies the Sales
83 * Credit Rules based on the attribute information on the transaction and results
84 * are populated into the CN_SCA_OUTPUT_LINES table.
85 * @param p_transaction_source The Sales Credit Allocation module supports multiple
86 * transaction sources. This parameter is used as a filter to identify the transactions
87 * to be processed by the Rules Engine.
88 * @param p_start_date Start Date
89 * @param p_end_date End Date
90 * @param errbuf Standard OUT parameter
91 * @param retcode Standard OUT parameter
92 * @rep:scope public
93 * @rep:lifecycle active
94 * @rep:displayname Get Sales Credits (Batch Mode)
95 */
96 PROCEDURE get_sales_credits (
97 errbuf OUT NOCOPY VARCHAR2,
98 retcode OUT NOCOPY NUMBER,
99 p_transaction_source IN VARCHAR2,
100 p_start_date IN VARCHAR2,
101 p_end_date IN VARCHAR2);
102 --
103
104 PROCEDURE get_assignments (
105 errbuf OUT NOCOPY VARCHAR2,
106 retcode OUT NOCOPY VARCHAR2,
107 p_org_id IN NUMBER,
108 p_start_date IN VARCHAR2,
109 p_end_date IN VARCHAR2,
110 p_run_mode IN VARCHAR2);
111
112 PROCEDURE batch_process_txns
113 (
114 errbuf OUT NOCOPY VARCHAR2
115 ,retcode OUT NOCOPY VARCHAR2
116 ,p_org_id IN NUMBER
117 ,p_run_mode IN VARCHAR2
118 ,p_worker_id IN NUMBER);
119
120 END CN_SCA_CREDITS_BATCH_PUB; -- Package spec