PACKAGE: APPS.AMW_THRESHOLD_VALUES_PKG

Source

1 package AMW_THRESHOLD_VALUES_PKG AUTHID CURRENT_USER as
2 /* $Header: amwtthrs.pls 115.3 2004/01/08 01:53:46 cpetriuc noship $ */
3 
4 procedure INSERT_ROW (
5   X_THRESHOLD_ID in NUMBER,
6   X_START_PERCENT_VALUE in NUMBER,
7   X_END_PERCENT_VALUE in NUMBER,
8   X_IMAGE_FILE in VARCHAR2,
9   X_SECURITY_GROUP_ID in NUMBER,
10   X_OBJECT_VERSION_NUMBER in NUMBER,
11   X_CREATION_DATE in DATE,
12   X_CREATED_BY in NUMBER,
13   X_LAST_UPDATE_DATE in DATE,
14   X_LAST_UPDATED_BY in NUMBER,
15   X_LAST_UPDATE_LOGIN in NUMBER
16 );
17 
18 procedure LOCK_ROW (
19   X_THRESHOLD_ID in NUMBER,
20   X_START_PERCENT_VALUE in NUMBER,
21   X_END_PERCENT_VALUE in NUMBER,
22   X_IMAGE_FILE in VARCHAR2,
23   X_SECURITY_GROUP_ID in NUMBER,
24   X_OBJECT_VERSION_NUMBER in NUMBER
25 );
26 
27 procedure UPDATE_ROW (
28   X_THRESHOLD_ID in NUMBER,
29   X_START_PERCENT_VALUE in NUMBER,
30   X_END_PERCENT_VALUE in NUMBER,
31   X_IMAGE_FILE in VARCHAR2,
32   X_SECURITY_GROUP_ID in NUMBER,
33   X_OBJECT_VERSION_NUMBER in NUMBER,
34   X_LAST_UPDATE_DATE in DATE,
35   X_LAST_UPDATED_BY in NUMBER,
36   X_LAST_UPDATE_LOGIN in NUMBER
37 );
38 
39 procedure DELETE_ROW (
40   X_THRESHOLD_ID in NUMBER
41 );
42 
43 procedure LOAD_ROW(
44 	X_THRESHOLD_ID		in NUMBER,
45 	X_START_PERCENT_VALUE	in NUMBER,
46 	X_END_PERCENT_VALUE	in NUMBER,
47 	X_IMAGE_FILE		in VARCHAR2,
48 	X_LAST_UPDATE_DATE    	in VARCHAR2,
49 	X_OWNER			in VARCHAR2,
50 	X_CUSTOM_MODE		in VARCHAR2
51 );
52 
53 end AMW_THRESHOLD_VALUES_PKG;