DBA Data[Home] [Help]

PACKAGE: APPS.INV_CG_UPGRADE

Source


1 PACKAGE inv_cg_upgrade AS
2 /* $Header: INVCGUGS.pls 120.1 2005/06/15 15:06:05 appldev  $ */
3 PROCEDURE INVMSISB(
4 		   l_organization_id 	IN  	NUMBER,
5 		    USER_NAME           IN      VARCHAR2,
6 		    PASSWORD            IN      VARCHAR2,
7 		    x_return_status	OUT NOCOPY 	VARCHAR2,
8 		    x_msg_count       	OUT NOCOPY 	NUMBER,
9 		    x_msg_data        	OUT NOCOPY 	VARCHAR2);
10 
11 
12 PROCEDURE INVMPSSB(
13                    l_organization_id   IN      NUMBER,
14 		   p_cost_method	IN	NUMBER,
15                    USER_NAME           IN      VARCHAR2,
16 		   PASSWORD            IN      VARCHAR2,
17                    x_return_status     OUT NOCOPY     VARCHAR2,
18                    x_msg_count         OUT NOCOPY     NUMBER,
19                    x_msg_data          OUT NOCOPY     VARCHAR2);
20 
21 
22 PROCEDURE INVMPSB(
23 		  l_organization_id   IN      NUMBER,
24 		  USER_NAME           IN      VARCHAR2,
25 		  PASSWORD            IN      VARCHAR2,
26 		  x_return_status     OUT NOCOPY     VARCHAR2,
27 		  x_msg_count         OUT NOCOPY     NUMBER,
28 		  x_msg_data          OUT NOCOPY     VARCHAR2);
29 
30 
31 PROCEDURE INVMOQSB(
32 		   l_organization_id   IN  	NUMBER,
33 		   p_cost_method	IN	NUMBER,
34 		   USER_NAME           IN      VARCHAR2,
35   		   PASSWORD            IN      VARCHAR2,
36 		   x_return_status     OUT NOCOPY 	VARCHAR2,
37 		   x_msg_count         OUT NOCOPY 	NUMBER,
38 		   x_msg_data          OUT NOCOPY 	VARCHAR2);
39 
40 
41 
42 PROCEDURE INVMMTSB(
43 		   l_organization_id 	IN  	NUMBER,
44 		   p_cost_method	IN	NUMBER,
45 		   p_open_periods_only   IN	NUMBER,
46 		   USER_NAME           IN      VARCHAR2,
47 		   PASSWORD            IN      VARCHAR2,
48 		   x_return_status	  	OUT NOCOPY 	VARCHAR2,
49 		   x_msg_count       	OUT NOCOPY 	NUMBER,
50 		   x_msg_data        	OUT NOCOPY 	VARCHAR2);
51 
52 
53 
54 
55 PROCEDURE INS_ERROR (
56 		      p_table_name         IN   VARCHAR2,
57 		      p_ROWID  	   IN  	VARCHAR2,
58 		      p_org_id             IN   NUMBER,
59 		      p_error_msg	   IN   VARCHAR2,
60                       p_proc_name          IN   VARCHAR2
61 		    );
62 
63 PROCEDURE LAUNCH_UPGRADE(p_open_periods_only	IN	NUMBER default 1) ;
64 
65 
66 PROCEDURE INVMCCESB (
67 		     l_organization_id 	IN  	NUMBER,
68 		    p_cost_method	IN	NUMBER,
69 		    USER_NAME           IN      VARCHAR2,
70 		    PASSWORD            IN      VARCHAR2,
71 		    x_return_status	OUT NOCOPY 	VARCHAR2,
72 		    x_msg_count       	OUT NOCOPY 	NUMBER,
73 		     x_msg_data        	OUT NOCOPY 	VARCHAR2
74 		     );
75 
76 
77 PROCEDURE INVMPASB (
78                     l_organization_id 	IN  	NUMBER,
79 		    p_cost_method	IN	NUMBER,
80 		    USER_NAME           IN      VARCHAR2,
81 		    PASSWORD            IN      VARCHAR2,
82 		    x_return_status	OUT NOCOPY 	VARCHAR2,
83 		    x_msg_count       	OUT NOCOPY 	NUMBER,
84 		     x_msg_data        	OUT NOCOPY 	VARCHAR2
85 
86 		    );
87 
88 
89 PROCEDURE INVMPITSB (
90                     l_organization_id 	IN  	NUMBER,
91 		    p_cost_method	IN	NUMBER,
92 		    USER_NAME           IN      VARCHAR2,
93 		    PASSWORD            IN      VARCHAR2,
94 		    x_return_status	OUT NOCOPY 	VARCHAR2,
95 		    x_msg_count       	OUT NOCOPY 	NUMBER,
96 		     x_msg_data        	OUT NOCOPY 	VARCHAR2
97 
98 		    );
99 
100   --      Name: CG_UPGR_FOR_CLOSED_PER_CP
101   --
102   --      Input parameters: None
103   --
104   --      Output parameters:
105   --                  x_errorbuf  -> Message text buffer
106   --                  x_retcode   -> Error Return code
107   --
108   --      Functions: This API is used in the concurrent program
109   --                 'Costgroup upgrade for closed periods'.
110   --                 This API inturn calls INV_CG_UPGRADE.LAUNCH_UPGRADE()
111   --                 with input parameter 2 to include transactions
112   --                 from closed periods for Cost Group Upgrade.
113 
114 PROCEDURE CG_UPGR_FOR_CLOSED_PER_CP(
115                 x_errorbuf         OUT NOCOPY  VARCHAR2
116               , x_retcode          OUT NOCOPY  VARCHAR2);
117 
118 END inv_cg_upgrade;