PACKAGE: APPS.AMS_TCOP_PERIODS_PKG

Source

1 package AMS_TCOP_PERIODS_PKG AUTHID CURRENT_USER as
2 /* $Header: amsltcps.pls 115.1 2003/10/17 11:53:56 mayjain noship $ */
3 procedure INSERT_ROW (
4 	X_ROWID IN OUT NOCOPY VARCHAR2,
5 	X_PERIOD_ID IN NUMBER,
6 	X_NO_OF_DAYS IN NUMBER,
7 	X_ENABLED_FLAG IN VARCHAR2,
8 	X_PERIOD_NAME IN VARCHAR2,
9 	X_DESCRIPTION in VARCHAR2,
10 	X_LAST_UPDATE_DATE in DATE,
11 	X_LAST_UPDATED_BY in NUMBER,
12 	X_CREATION_DATE in DATE,
13 	X_CREATED_BY in NUMBER,
14 	X_LAST_UPDATE_LOGIN in NUMBER,
15 	X_OBJECT_VERSION_NUMBER in NUMBER
16 );
17 
18 
19 
20 procedure LOCK_ROW (
21 	X_PERIOD_ID IN NUMBER,
22 	X_OBJECT_VERSION_NUMBER in NUMBER,
23 	X_NO_OF_DAYS IN NUMBER,
24 	X_ENABLED_FLAG IN VARCHAR2,
25 	X_PERIOD_NAME IN VARCHAR2,
26 	X_DESCRIPTION in VARCHAR2
27 );
28 
29 
30 procedure UPDATE_ROW (
31 	X_PERIOD_ID IN NUMBER,
32 	X_OBJECT_VERSION_NUMBER in NUMBER,
33 	X_NO_OF_DAYS IN NUMBER,
34 	X_ENABLED_FLAG IN VARCHAR2,
35 	X_PERIOD_NAME IN VARCHAR2,
36 	X_DESCRIPTION in VARCHAR2,
37 	X_LAST_UPDATE_DATE in DATE,
38 	X_LAST_UPDATED_BY in NUMBER,
39 	X_LAST_UPDATE_LOGIN in NUMBER
40 );
41 
42 
43 procedure DELETE_ROW (
44 	X_PERIOD_ID IN NUMBER
45 );
46 
47 
48 procedure  LOAD_ROW(
49 	X_PERIOD_ID IN NUMBER,
50 	X_NO_OF_DAYS IN NUMBER,
51 	X_ENABLED_FLAG IN VARCHAR2,
52 	X_PERIOD_NAME IN VARCHAR2,
53 	X_DESCRIPTION in VARCHAR2,
54 	X_OWNER in  VARCHAR2,
55 	X_CUSTOM_MODE in VARCHAR2
56 );
57 
58 
59 PROCEDURE TRANSLATE_ROW (
60 	X_PERIOD_ID IN NUMBER,
61 	X_PERIOD_NAME IN VARCHAR2,
62 	X_DESCRIPTION in VARCHAR2,
63 	X_OWNER IN VARCHAR2,
64 	X_CUSTOM_MODE IN VARCHAR2
65 );
66 
67 PROCEDURE add_language;
68 
69 end AMS_TCOP_PERIODS_PKG;