PACKAGE: APPS.IMC_THREE_SIXTY_SSM_QUERY_PKG

Source

1 package IMC_THREE_SIXTY_SSM_QUERY_PKG AUTHID CURRENT_USER as
2 /* $Header: ARHTSSQS.pls 120.0 2005/05/25 22:00:29 achung noship $ */
3 
4 procedure INSERT_ROW (
5   X_SSM_QUERY_ID in out NOCOPY NUMBER,
6   X_APPLICATION_ID in Number,
7   X_SSM_QUERY_STRING  in VARCHAR2,
8   X_CREATION_DATE in DATE,
9   X_CREATED_BY in NUMBER,
10   X_LAST_UPDATE_DATE in DATE,
11   X_LAST_UPDATED_BY in NUMBER,
12   X_LAST_UPDATE_LOGIN in NUMBER,
13   X_OBJECT_VERSION_NUMBER in NUMBER);
14 
15 
16 procedure LOCK_ROW (
17   X_SSM_QUERY_ID in NUMBER,
18   X_APPLICATION_ID in Number,
19   X_SSM_QUERY_STRING  in VARCHAR2,
20   X_CREATION_DATE in DATE,
21   X_CREATED_BY in NUMBER,
22   X_LAST_UPDATE_DATE in DATE,
23   X_LAST_UPDATED_BY in NUMBER,
24   X_LAST_UPDATE_LOGIN in NUMBER,
25   X_OBJECT_VERSION_NUMBER in NUMBER
26 );
27 
28 procedure UPDATE_ROW (
29   X_SSM_QUERY_ID in NUMBER,
30   X_APPLICATION_ID in Number,
31   X_SSM_QUERY_STRING  in VARCHAR2,
32   X_LAST_UPDATE_DATE in DATE,
33   X_LAST_UPDATED_BY in NUMBER,
34   X_LAST_UPDATE_LOGIN in NUMBER,
35   X_OBJECT_VERSION_NUMBER in NUMBER
36 );
37 
38 procedure DELETE_ROW (
39   X_SSM_QUERY_ID in NUMBER
40   );
41 
42 
43  procedure LOAD_ROW(
44   X_SSM_QUERY_ID in out NOCOPY NUMBER,
45   X_APPLICATION_ID in Number,
46   X_SSM_QUERY_STRING  in VARCHAR2,
47  X_LAST_UPDATE_DATE in DATE,
48   X_LAST_UPDATED_BY in NUMBER,
49   X_LAST_UPDATE_LOGIN in NUMBER,
50   X_OBJECT_VERSION_NUMBER in NUMBER,
51   X_OWNER in VARCHAR2);
52 
53 end IMC_THREE_SIXTY_SSM_QUERY_PKG;