1 PACKAGE CN_PmtSub_PUB as
2 -- $Header: cnppsubs.pls 120.1 2005/10/14 11:41:37 rnagired noship $
3 /*#
4 * This procedure is used to pay a payrun and update the subledger, run the
5 * concurrent program, and pay the payrun using a concurrent program.
6 * @rep:scope public
7 * @rep:product CN
8 * @rep:displayname Submit Payrun Concurrent Programs
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY CN_COMP_PLANS
12 */
13 --============================================================================
14 -- Start of Comments
15 --
16 -- API name : Pay_Payrun
17 -- Type : Public.
18 -- Pre-reqs : None.
19 -- Usage : Transfers the information to the cn_payment_api table and
20 -- updates the salesperson subledger to reflect the amount paid
21 -- Desc : Procedure to Pay Payrun
22 -- Parameters :
23 -- IN : p_api_version IN NUMBER Require
24 -- p_init_msg_list IN VARCHAR2 Optional
25 -- Default = FND_API.G_FALSE
26 -- p_commit IN VARCHAR2 Optional
27 -- Default = FND_API.G_FALSE
28 -- p_validation_level IN NUMBER Optional
29 -- Default = FND_API.G_VALID_LEVEL_FULL
30 -- OUT : x_return_status OUT VARCHAR2(1)
31 -- x_msg_count OUT NUMBER
32 -- x_msg_data OUT VARCHAR2(2000)
33 -- IN : p_Payrun_name IN cn_payruns.name%TYPE
34 --
35 -- OUT : x_loading_status OUT
36 -- Detailed Error Message
37 -- Version : Current version 1.0
38 -- Initial version 1.0
39 --
40 -- End of comments
41
42 --============================================================================
43 /*#
44 * This procedure is used to pay a payrun and update the subledger.
45 * @param p_api_version API Version
46 * @param p_init_msg_list Initialize Message List
47 * @param p_commit Commit after update
48 * @param p_validation_level Validation Level
49 * @param x_return_status Status of the update operation
50 * @param x_msg_count Number of error messages returned
51 * @param x_msg_data Error messages
52 * @param p_payrun_name Payrun name
53 * @param x_status Status
54 * @param x_loading_status Status
55 * @rep:scope public
56 * @rep:lifecycle active
57 * @rep:displayname Pay Payrun
58 */
59 PROCEDURE Pay
60 ( p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 := cn_api.g_false,
62 p_commit IN VARCHAR2 := cn_api.g_false,
63 p_validation_level IN NUMBER := cn_api.g_valid_level_full,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_payrun_name IN cn_payruns.name%TYPE,
68 p_org_id IN NUMBER,
69 x_status OUT NOCOPY VARCHAR2,
70 x_loading_status OUT NOCOPY VARCHAR2
71 ) ;
72
73 --============================================================================
74 -- Start of Comments
75 --
76 -- API name : Pay_Payrun_conc
77 -- Type : Public.
78 -- Pre-reqs : None.
79 -- Usage : Transfers the information to the cn_payment_api table and
80 -- updates the salesperson subledger to reflect the amount paid
81 -- Desc : Procedure to Pay Payrun using a concurrent program
82 -- Parameters :
83 -- IN : p_api_version IN NUMBER Require
84 -- p_init_msg_list IN VARCHAR2 Optional
85 -- Default = FND_API.G_FALSE
86 -- p_commit IN VARCHAR2 Optional
87 -- Default = FND_API.G_FALSE
88 -- p_validation_level IN NUMBER Optional
89 -- Default = FND_API.G_VALID_LEVEL_FULL
90 -- OUT : x_return_status OUT VARCHAR2(1)
91 -- x_msg_count OUT NUMBER
92 -- x_msg_data OUT VARCHAR2(2000)
93 -- IN : p_Payrun_name IN cn_payruns.name%TYPE
94 --
95 -- OUT : x_loading_status OUT
96 -- Detailed Error Message
97 -- Version : Current version 1.0
98 -- Initial version 1.0
99 --
100 -- End of comments
101
102 --============================================================================
103 /*#
104 * This procedure is used as the executable for the concurrent program CN_PAY_PAYRUN to pay a payrun.
105 * @param errbuf Concurrent request error buffer
106 * @param retcode Concurrent request return code
107 * @param p_name Payrun name
108 * @rep:scope public
109 * @rep:lifecycle active
110 * @rep:displayname Pay Payrun concurrent program
111 */
112 PROCEDURE Pay_Payrun_conc
113 ( errbuf OUT NOCOPY VARCHAR2,
114 retcode OUT NOCOPY NUMBER ,
115 p_name cn_payruns.name%TYPE );
116
117 --============================================================================
118 /*#
119 * This procedure is used to pay a payrun using a concurrent program.
120 * @param p_payrun_id Unique identifier of payrun
121 * @param x_request_id Unique identifier of concurrent request
122 * @rep:scope public
123 * @rep:lifecycle active
124 * @rep:displayname Submit Pay Payrun concurrent request
125 */
126 PROCEDURE submit_request (p_payrun_id IN NUMBER,
127 x_request_id OUT NOCOPY NUMBER) ;
128 END CN_PmtSub_PUB ;