1 PACKAGE CN_PREPOST_PVT AS
2 -- $Header: cnvposts.pls 120.0 2005/06/06 17:43:30 appldev noship $ --+
3 -- ---------------------------------------------------------------------------------+
4 --
5 -- Procedure : Initialize_Batch
6 -- Description : This procedure is used to initialize a pre posting batch and
7 -- set a global variable CN_PREPOST_PVT.G_BATCH_ID for the session.
8 -- The batch can be entirely system generated or have user defined
9 -- parameters. If a batch has already been initialized then it
10 -- does nothing.
11 -- Calls :
12 --
13 -- ---------------------------------------------------------------------------------+
14 PROCEDURE Initialize_Batch
15 ( p_api_version IN NUMBER ,
16 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
17 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
18 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19 x_return_status OUT NOCOPY VARCHAR2 ,
20 x_msg_count OUT NOCOPY NUMBER ,
21 x_msg_data OUT NOCOPY VARCHAR2 ,
22 x_loading_status OUT NOCOPY VARCHAR2 ,
23 p_loading_status IN VARCHAR2 ,
24 p_posting_batch_rec IN OUT NOCOPY CN_PREPOSTBATCHES.posting_batch_rec_type ,
25 x_status OUT NOCOPY VARCHAR2
26 );
27 -- ---------------------------------------------------------------------------------+
28 --
29 -- Procedure : Terminate_Batch
30 -- Description : This PUBLIC procedure is used to terminate the current pre
31 -- posting batch for a session. The global variable
32 -- CN_PREPOSTBATCHES.G_BATCH_ID is nullified.
33 -- Calls :
34 --
35 -- ---------------------------------------------------------------------------------+
36 PROCEDURE Terminate_Batch;
37 -- ---------------------------------------------------------------------------------+
38 --
39 -- Procedure : Create_From_CommLine
40 -- Description : This procedure is used to create a pre posting detail for a
41 -- commission line. A commission line can be created as a NEW
42 -- or a REVERTed (e.g., the commission line has previously been
43 -- posted and is reversed out) posting detail.
44 -- Calls : Initialize_Batch() is called from within. If a batch already
45 -- exists then OK, else it will create an system generated batch.
46 --
47 -- ---------------------------------------------------------------------------------+
48 PROCEDURE Create_From_CommLine
49 ( p_api_version IN NUMBER ,
50 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
51 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
52 p_validation_level IN NUMBER :=
53 FND_API.G_VALID_LEVEL_FULL ,
54 x_return_status OUT NOCOPY VARCHAR2 ,
55 x_msg_count OUT NOCOPY NUMBER ,
56 x_msg_data OUT NOCOPY VARCHAR2 ,
57 p_create_mode IN VARCHAR2 := 'NEW' ,
58 p_commission_line_id IN NUMBER
59 );
60 -- ---------------------------------------------------------------------------------+
61 --
62 -- Procedure : Create_PrePostDetails
63 -- Description : This procedure is used to create pre posting details from a
64 -- PL/SQL table of transactions, committing once per table (e.g.,
65 -- each time the procedure is called). This procedure therefore
66 -- defines a unit of work. Used to create posting details for
67 -- non commission line related transactions (e.g., payment plan
68 -- transactions).
69 -- Calls :
70 --
71 -- ---------------------------------------------------------------------------------+
72 PROCEDURE Create_PrePostDetails
73 ( p_api_version IN NUMBER ,
74 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
75 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
76 p_validation_level IN NUMBER :=
77 FND_API.G_VALID_LEVEL_FULL ,
78 x_return_status OUT NOCOPY VARCHAR2 ,
79 x_msg_count OUT NOCOPY NUMBER ,
80 x_msg_data OUT NOCOPY VARCHAR2 ,
81 p_posting_detail_rec_tbl IN OUT NOCOPY CN_PREPOSTDETAILS.posting_detail_rec_tbl_type
82 );
83 -- ---------------------------------------------------------------------------------+
84 --
85 -- Procedure : PrePost_PayWorksheets
86 -- Description : This procedure is used to create pre posting details for any
87 -- paid but not posted payment worksheets. Assumes a batch has
88 -- been initialized and uses the batch parameters to drive the
89 -- selection of pay worksheets.
90 -- Populates PL/SQL table and calls Create_PrePostDetails.
91 -- Calls : Create_PrePostDetails()
92 --
93 -- ---------------------------------------------------------------------------------+
94 PROCEDURE PrePost_PayWorksheets
95 ( p_api_version IN NUMBER ,
96 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
97 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
98 p_validation_level IN NUMBER :=
99 FND_API.G_VALID_LEVEL_FULL ,
100 x_return_status OUT NOCOPY VARCHAR2 ,
101 x_msg_count OUT NOCOPY NUMBER ,
102 x_msg_data OUT NOCOPY VARCHAR2
103 );
104 END CN_PREPOST_PVT;