DBA Data[Home] [Help]

PACKAGE: APPS.CN_PMTSUB_PUB_CUHK

Source


1 PACKAGE CN_PMTSUB_PUB_CUHK as
2 -- $Header: cncpsubs.pls 120.1 2005/10/14 11:30:50 rnagired noship $ --+
3 
4 -------------------------------------------------------------------------------------+
5 -- Start of comments
6 -- API name 	: Pay_pre
7 -- Type		: Public.
8 -- Pre-reqs	: None.
9 -- Usage	: Customization before paying a payrun
10 --
11 -- Desc 	:
12 --
13 -- Parameters	:
14 -- IN		:  p_api_version       IN NUMBER      Required
15 -- 		   p_init_msg_list     IN VARCHAR2    Optional
16 --					  	      Default = FND_API.G_FALSE
17 -- 		   p_commit	       IN VARCHAR2    Optional
18 -- 		       	                              Default = FND_API.G_FALSE
19 -- 		   p_validation_level  IN NUMBER      Optional
20 -- 		       	                   Default = FND_API.G_VALID_LEVEL_FULL
21 -- OUT		:  x_return_status     OUT	      VARCHAR2(1)
22 -- 		   x_msg_count	       OUT	      NUMBER
23 -- 		   x_msg_data	       OUT	      VARCHAR2(2000)
24 -- IN		:  p_payrun_name       IN             cn_payruns.name%TYPE
25 --
26 -- OUT		:  x_loading_status    OUT            VARCHAR2(50)
27 --                 Detailed error code returned from procedure.
28 --
29 -- OUT		:  x_status           OUT	      VARCHAR2(50)
30 --		      Return Sql Statement Status ( VALID/INVALID)
31 --
32 -- Version	: Current version	1.0
33 --		  Initial version 	1.0
34 --
35 -- Notes	:
36 --
37 -- End of comments
38 --------------------------------------------------------------------------------------+
39 PROCEDURE Pay_pre
40 ( 	p_api_version           	IN	NUMBER,
41   	p_init_msg_list		        IN	VARCHAR2 := FND_API.G_FALSE,
42 	p_commit	    		IN  	VARCHAR2 := FND_API.G_FALSE,
43 	p_validation_level		IN  	NUMBER   := FND_API.G_VALID_LEVEL_FULL,
44 	x_return_status		        OUT	NOCOPY VARCHAR2,
45 	x_msg_count			OUT	NOCOPY NUMBER,
46 	x_msg_data			OUT	NOCOPY  VARCHAR2,
47       p_payrun_name                   IN OUT NOCOPY  cn_payruns.name%TYPE,
48     	p_payrun_id         IN   cn_payruns.payrun_id%TYPE,
49       x_loading_status		OUT   NOCOPY   VARCHAR2,
50 	x_status                        OUT   NOCOPY   VARCHAR2
51 );
52 
53 -------------------------------------------------------------------------------------+
54 -- Start of comments
55 -- API name 	: Pay_post
56 -- Type		: Public.
57 -- Pre-reqs	: None.
58 -- Usage	: Customization after paying a payrun
59 --
60 -- Desc 	:
61 --
62 -- Parameters	:
63 -- IN		:  p_api_version       IN NUMBER      Required
64 -- 		   p_init_msg_list     IN VARCHAR2    Optional
65 --					  	      Default = FND_API.G_FALSE
66 -- 		   p_commit	       IN VARCHAR2    Optional
67 -- 		       	                              Default = FND_API.G_FALSE
68 -- 		   p_validation_level  IN NUMBER      Optional
69 -- 		       	                   Default = FND_API.G_VALID_LEVEL_FULL
70 -- OUT		:  x_return_status     OUT	      VARCHAR2(1)
71 -- 		   x_msg_count	       OUT	      NUMBER
72 -- 		   x_msg_data	       OUT	      VARCHAR2(2000)
73 -- IN		:  p_payrun_name       IN             cn_payruns.name%TYPE
74 --
75 -- OUT		:  x_loading_status    OUT            VARCHAR2(50)
76 --                 Detailed error code returned from procedure.
77 --
78 -- OUT		:  x_status           OUT	      VARCHAR2(50)
79 --		      Return Sql Statement Status ( VALID/INVALID)
80 --
81 -- Version	: Current version	1.0
82 --		  Initial version 	1.0
83 --
84 -- Notes	:
85 --
86 -- End of comments
87 --------------------------------------------------------------------------------------+
88 PROCEDURE Pay_post
89 ( 	p_api_version           	IN	NUMBER,
90   	p_init_msg_list		        IN	VARCHAR2 := FND_API.G_FALSE,
91 	p_commit	    		IN  	VARCHAR2 := FND_API.G_FALSE,
92 	p_validation_level		IN  	NUMBER   := FND_API.G_VALID_LEVEL_FULL,
93 	x_return_status		        OUT	NOCOPY VARCHAR2,
94 	x_msg_count			OUT	NOCOPY NUMBER,
95 	x_msg_data			OUT	NOCOPY VARCHAR2,
96       p_payrun_name                   IN      cn_payruns.name%TYPE,
97     	p_payrun_id         IN   cn_payruns.payrun_id%TYPE,
98       x_loading_status		OUT     NOCOPY VARCHAR2,
99 	x_status                        OUT     NOCOPY VARCHAR2
100 );
101 
102 --------------------------------------------------------------------------------------+
103 -- Start of comments
104 -- API name 	: ok_to_generate_msg
105 -- Type		: Public.
106 -- Pre-reqs	: None.
107 -- Usage	: Function to decide whether message needs to be generated
108 --
109 -- Desc 	:
110 --
111 -- Parameters	:
112 -- IN		:
113 -- OUT		:
114 -- Version	: Current version	1.0
115 --		  Initial version 	1.0
116 --
117 -- End of comments
118 --------------------------------------------------------------------------------------+
119   FUNCTION ok_to_generate_msg
120     (p_payrun_name           IN      cn_payruns.name%TYPE)
121 RETURN BOOLEAN;
122 
123 
124 END CN_PMTSUB_PUB_CUHK;