DBA Data[Home] [Help]

PACKAGE: APPS.CN_TRANSACTION_LOAD_PUB_CUHK

Source


1 PACKAGE cn_transaction_load_pub_cuhk AUTHID CURRENT_USER AS
2 -- $Header: cncloads.pls 120.3 2005/08/10 03:43:24 hithanki noship $
3 
4 -- Start of Comments
5 -- API name 	: Load_Pre
6 -- Type		: Public.
7 -- Pre-reqs	: None.
8 -- Usage	: Customization before load transactions from API table
9 --                (CN_COMM_LINES_API)
10 --                to HEADER table (CN_COMMISSION_HEADERS)
11 -- Parameters	:
12 -- IN		:  p_api_version       IN NUMBER      Require
13 -- 		:  p_init_msg_list     IN VARCHAR2    Optional
14 -- 		   	Default = FND_API.G_FALSE
15 -- 		:  p_commit	       IN VARCHAR2    Optional
16 -- 		       	Default = FND_API.G_FALSE
17 -- 		:  p_validation_level  IN NUMBER      Optional
18 -- 		       	Default = FND_API.G_VALID_LEVEL_FULL
19 -- OUT		:  x_return_status     OUT 	      VARCHAR2(1)
20 -- 		:  x_msg_count	       OUT	      NUMBER
21 -- 		:  x_msg_data	       OUT	      VARCHAR2(2000)
22 --              :  x_loading_status         OUT            VARCHAR2
23 -- Version	: Current version	1.0
24 --		  Initial version 	1.0
25 --
26 -- Notes
27 --
28 --
29 -- Special Notes :
30 --
31 -- End of comments
32 
33   PROCEDURE Load_Pre
34   (
35    p_api_version        IN    NUMBER,
36    p_init_msg_list      IN    VARCHAR2 := FND_API.G_FALSE,
37    p_commit	        IN    VARCHAR2 := FND_API.G_FALSE,
38    p_validation_level   IN    NUMBER   := FND_API.G_VALID_LEVEL_FULL,
39    x_return_status      OUT NOCOPY   VARCHAR2,
40    x_msg_count	        OUT NOCOPY  NUMBER,
41    x_msg_data	        OUT NOCOPY  VARCHAR2,
42    x_loading_status     OUT NOCOPY  VARCHAR2
43    );
44 
45 -- Start of Comments
46 -- API name 	: Load_Post
47 -- Type		: Public.
48 -- Pre-reqs	: None.
49 -- Usage	: Customization after load transactions from API table
50 --                (CN_COMM_LINES_API)
51 --                to HEADER table (CN_COMMISSION_HEADERS)
52 -- Parameters	:
53 -- IN		:  p_api_version       IN NUMBER      Require
54 -- 		:  p_init_msg_list     IN VARCHAR2    Optional
55 -- 		   	Default = FND_API.G_FALSE
56 -- 		:  p_commit	       IN VARCHAR2    Optional
57 -- 		       	Default = FND_API.G_FALSE
58 -- 		:  p_validation_level  IN NUMBER      Optional
59 -- 		       	Default = FND_API.G_VALID_LEVEL_FULL
60 -- OUT		:  x_return_status     OUT	      VARCHAR2(1)
61 -- 		:  x_msg_count	       OUT	      NUMBER
62 -- 		:  x_msg_data	       OUT	      VARCHAR2(2000)
63 --              :  x_loading_status         OUT            VARCHAR2
64 -- Version	: Current version	1.0
65 --		  Initial version 	1.0
66 --
67 -- Notes
68 --
69 --
70 -- Special Notes :
71 --
72 -- End of comments
73 
74   PROCEDURE Load_Post
75   (
76    p_api_version        IN    NUMBER,
77    p_init_msg_list      IN    VARCHAR2 := FND_API.G_FALSE,
78    p_commit	        IN    VARCHAR2 := FND_API.G_FALSE,
79    p_validation_level   IN    NUMBER   := FND_API.G_VALID_LEVEL_FULL,
80    x_return_status      OUT NOCOPY   VARCHAR2,
81    x_msg_count	        OUT NOCOPY   NUMBER,
82    x_msg_data	        OUT NOCOPY  VARCHAR2,
83    x_loading_status     OUT NOCOPY  VARCHAR2
84    );
85 
86 
87  -- Start of comments
88 -- API name 	: ok_to_generate_msg
89 -- Type		: Public.
90 -- Pre-reqs	: None.
91 -- Usage	: Function to decide whether message needs to be generated
92 --
93 -- Desc 	:
94 --
95 -- Parameters	:
96 -- IN		:
97 -- OUT		:
98 -- Version	: Current version	1.0
99 --		  Initial version 	1.0
100 --
101 -- End of comments
102 
103 FUNCTION ok_to_generate_msg
104   RETURN BOOLEAN;
105 
106 
107 END cn_transaction_load_pub_cuhk;