PACKAGE: APPS.AMW_LOAD_CONSTRAINT_DATA

Source

1 PACKAGE AMW_LOAD_CONSTRAINT_DATA AS
2 /* $Header: amwcstls.pls 120.0.12000000.1 2007/01/16 20:38:00 appldev ship $ */
3 
4 -- ===============================================================
5 -- Package name
6 --          AMW_LOAD_CONSTRAINT_DATA
7 -- Purpose
8 --
9 -- History
10 -- 		  	10/01/2004    tsho     Creates
11 -- ===============================================================
12 
13 -- FND_API global constant
14 G_USER_ID                           NUMBER      := FND_GLOBAL.USER_ID;
15 G_LOGIN_ID                          NUMBER      := FND_GLOBAL.CONC_LOGIN_ID;
16 G_FALSE    		  		   CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
17 G_TRUE 					   CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
18 G_VALID_LEVEL_FULL 		   CONSTANT NUMBER 		:= FND_API.G_VALID_LEVEL_FULL;
19 G_RET_STS_SUCCESS 		   VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20 G_RET_STS_ERROR			   VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
21 G_RET_STS_UNEXP_ERROR 	    VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
22 
23 -- AMW table/view name
24 G_AMW_USER                 CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER');
25 G_AMW_USER_RESP_GROUPS     CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_RESP_GROUPS');
26 G_AMW_RESPONSIBILITY       CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY');
27 G_AMW_RESP_FUNCTIONS       CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');
28 G_AMW_MENUS                CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENUS');
29 G_AMW_MENU_ENTRIES         CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');
30 G_AMW_FORM_FUNCTIONS_VL    CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');
31 
32 
33 -- ===============================================================
34 -- Procedure name
35 --          create_constraints
36 -- Purpose
37 -- 		  	import constraints
38 --          from interface table to AMW_CONSTRAINTS_B and AMW_CONSTRAINTS_TL
39 -- Notes
40 --          this procedure is called in Concurrent Executable
41 -- ===============================================================
42 PROCEDURE create_constraints (
43     ERRBUF      OUT NOCOPY   VARCHAR2,
44     RETCODE     OUT NOCOPY   VARCHAR2,
45     p_batch_id       IN       NUMBER,
46     p_user_id        IN       NUMBER
47 );
48 
49 
50 -- ===============================================================
51 -- Procedure name
52 --          update_interface_with_error
53 -- Purpose
54 -- 		  	update interface table with error mesg
55 -- ===============================================================
56 PROCEDURE update_interface_with_error (
57     p_err_msg        IN   VARCHAR2,
58     p_table_name     IN   VARCHAR2,
59     p_interface_id   IN   NUMBER
60 );
61 
62 
63 -- ----------------------------------------------------------------------
64 END AMW_LOAD_CONSTRAINT_DATA;
65