PACKAGE: APPS.AMS_IMP_LIST_IMPORT_TYPES_PKG

Source

1 package AMS_IMP_LIST_IMPORT_TYPES_PKG AUTHID CURRENT_USER as
2 /* $Header: amsilmts.pls 115.5 2004/04/07 21:52:07 usingh ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in OUT NOCOPY VARCHAR2,
5   X_IMPORT_TYPE_ID in NUMBER,
6   X_IMPORT_TYPE in VARCHAR2,
7   X_VIEW_NAME in VARCHAR2,
8   X_B2B_FLAG in VARCHAR2,
9   X_CONCURRENT_PROGRAM in VARCHAR2,
10   X_WORKBOOK_NAME in VARCHAR2,
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 procedure LOCK_ROW (
18   X_IMPORT_TYPE_ID in NUMBER,
19   X_IMPORT_TYPE in VARCHAR2,
20   X_VIEW_NAME in VARCHAR2,
21   X_B2B_FLAG in VARCHAR2,
22   X_CONCURRENT_PROGRAM in VARCHAR2,
23   X_WORKBOOK_NAME in VARCHAR2
24 );
25 
26 
27 procedure UPDATE_ROW (
28   X_IMPORT_TYPE_ID in NUMBER,
29   X_IMPORT_TYPE in VARCHAR2,
30   X_VIEW_NAME in VARCHAR2,
31   X_B2B_FLAG in VARCHAR2,
32   X_CONCURRENT_PROGRAM in VARCHAR2,
33   X_WORKBOOK_NAME in VARCHAR2,
34   X_LAST_UPDATE_DATE in DATE,
35   X_LAST_UPDATED_BY in NUMBER,
36   X_LAST_UPDATE_LOGIN in NUMBER
37 );
38 procedure DELETE_ROW (
39   X_IMPORT_TYPE_ID in NUMBER
40 );
41 
42 procedure LOAD_ROW (
43   X_IMPORT_TYPE_ID in NUMBER,
44   X_IMPORT_TYPE in VARCHAR2,
45   X_VIEW_NAME in VARCHAR2,
46   X_B2B_FLAG in VARCHAR2,
47   X_CONCURRENT_PROGRAM in VARCHAR2,
48   X_WORKBOOK_NAME in VARCHAR2,
49   X_OWNER in VARCHAR2,
50   X_CREATION_DATE in DATE,
51   X_CREATED_BY in NUMBER,
52   X_LAST_UPDATE_DATE in DATE,
53   X_LAST_UPDATED_BY in NUMBER,
54   X_LAST_UPDATE_LOGIN in NUMBER
55 );
56 
57 end AMS_IMP_LIST_IMPORT_TYPES_PKG;