[Home] [Help]
PACKAGE: APPS.CN_SCA_TRX_PROC_PVT
Source
1 PACKAGE CN_SCA_TRX_PROC_PVT AUTHID CURRENT_USER AS
2 -- $Header: cnvstrps.pls 120.4 2006/03/30 21:10:45 vensrini noship $
3 -- +======================================================================+
4 -- | Copyright (c) 1994 Oracle Corporation |
5 -- | Redwood Shores, California, USA |
6 -- | All rights reserved. |
7 -- +======================================================================+
8 --
9 -- Package Name
10 -- cn_sca_trx_proc_pub
11 -- Purpose
12 -- Procedures TO populate transactions from CN_COMM_LINES_API into SCA interface tables and
13 -- transfer results back to CN_COMM_LINES_API from SCA output tables after credit allocation
14
15 -- History
16 -- 06/02/03 Mike Ting Created
17
18 -- Name:
19 -- populate_results
20 -- Purpose:
21 -- This procedure initiates the population of data from the API table into SCA interface tables.
22
23 PROCEDURE debugmsg(msg VARCHAR2);
24
25 PROCEDURE Conc_Submit(x_conc_program VARCHAR2
26 ,x_parent_proc_audit_id NUMBER
27 ,x_process VARCHAR2
28 ,x_physical_batch_id NUMBER
29 ,x_start_date DATE
30 ,x_end_date DATE
31 ,x_request_id IN OUT NOCOPY NUMBER);
32
33
34 PROCEDURE conc_dispatch(x_parent_proc_audit_id NUMBER,
35 x_start_date DATE,
36 x_end_date DATE,
37 x_logical_batch_id NUMBER,
38 x_process VARCHAR2);
39
40
41 --+ Procedure Name
42 --+ Assign
43 --+ Purpose : Split the logical batch into smaller physical batches
44 --+ populate the physical_batch_id in cn_process_batches
45
46 PROCEDURE ASSIGN(p_logical_batch_id NUMBER,
47 p_start_date DATE,
48 p_end_date DATE,
49 batch_type VARCHAR2,
50 p_org_id NUMBER, -- updated by vensrini
51 x_size OUT NOCOPY NUMBER);
52
53
54 PROCEDURE create_trx (
55 p_start_date DATE,
56 p_end_date DATE,
57 p_physical_batch_id NUMBER);
58
59 PROCEDURE negate_trx (
60 p_start_date DATE,
61 p_end_date DATE,
62 p_physical_batch_id NUMBER);
63
64 PROCEDURE check_adjusted (
65 p_start_date DATE,
66 p_end_date DATE,
67 p_physical_batch_id NUMBER);
68
69 PROCEDURE check_api_adjusted (
70 p_start_date DATE,
71 p_end_date DATE,
72 p_physical_batch_id NUMBER);
73
74 PROCEDURE populate_results (
75 errbuf OUT NOCOPY VARCHAR2,
76 retcode OUT NOCOPY NUMBER,
77 pp_start_date VARCHAR2,
78 pp_end_date VARCHAR2,
79 p_org_id IN VARCHAR2);
80
81 PROCEDURE populate_data (
82 errbuf OUT NOCOPY VARCHAR2,
83 retcode OUT NOCOPY NUMBER,
84 pp_start_date VARCHAR2,
85 pp_end_date VARCHAR2,
86 p_checkbox_value VARCHAR2);
87
88 PROCEDURE call_populate_data (
89 p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
91 p_commit IN VARCHAR2 := FND_API.G_FALSE,
92 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
93 p_start_date IN DATE,
94 p_end_date IN DATE,
95 p_checkbox_value IN VARCHAR2,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 x_process_audit_id OUT NOCOPY NUMBER);
100
101
102 PROCEDURE call_populate_results (
103 p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
105 p_commit IN VARCHAR2 := FND_API.G_FALSE,
106 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
107 p_start_date IN DATE,
108 p_end_date IN DATE,
109 p_org_id IN NUMBER,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 x_process_audit_id OUT NOCOPY NUMBER);
114
115 PROCEDURE sca_batch_runner(
116 errbuf OUT NOCOPY VARCHAR2
117 ,retcode OUT NOCOPY NUMBER
118 ,p_parent_proc_audit_id NUMBER
119 ,p_process VARCHAR2
120 ,p_physical_batch_id NUMBER
121 ,p_start_date DATE := NULL
122 ,p_end_date DATE := NULL
123 ,p_org_id IN NUMBER);
124
125
126 END cn_sca_trx_proc_pvt;