1 PACKAGE BODY JTM_FND_PROFILE_OPTION_ACC_PKG AS
2 /* $Header: jtmvprob.pls 120.1 2005/08/24 02:20:35 saradhak noship $ */
3 -- Start of Comments
4 --
5 -- NAME
6 -- JTM_FND_PROFILE_OPTIONS_ACC_PKG
7 --
8 -- PURPOSE
9 -- TABLE-LEVEL PACKAGE for JTM_FND_PROFILE_OPTIONS_ACC.
10 --
11 -- PROCEDURES:
12 --
13 --
14 -- NOTES
15 --
16 --
17 -- HISTORY
18 -- 04-09-2002 YOHUANG Created.
19 --
20 -- End of Comments
21 --
22 --
23 --
24 G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTM_FND_PROFILE_OPTION_ACC_PKG';
25 G_FILE_NAME CONSTANT VARCHAR2(12) := 'jtmvprob.pls';
26 --
27 --
28 -- ACCESS_ID is generated from SEQUENCE. Later ACCESS_ID will be removed.
29 -- It handles the DUPLICATE_VALUE on INDEX Exception.
30 -- For Application Specific ACC tables, the counter is always 1.
31 PROCEDURE INSERT_ROW (
32 X_BASE_APPLICATION_ID IN NUMBER ,
33 X_PROFILE_OPTION_ID IN NUMBER ,
34 X_PROFILE_OPTION_NAME IN VARCHAR2 ,
35 X_APPLICATION_ID IN NUMBER ,
36 X_ACCESS_ID OUT NOCOPY NUMBER
37 ) IS
38
39 BEGIN
40 null;
41 END INSERT_ROW;
42
43 -- For Application Specific ACC table, there won't be any update allowed.
44 PROCEDURE UPDATE_ROW (
45 X_BASE_APPLICATION_ID IN NUMBER ,
46 X_PROFILE_OPTION_ID IN NUMBER ,
47 X_PROFILE_OPTION_NAME IN VARCHAR2 ,
48 X_APPLICATION_ID IN NUMBER
49 ) IS
50
51 BEGIN
52 null;
53 END UPDATE_ROW;
54
55 -- For Deletion, later on we might need to add an "EXPRIATION_DATE" Column to support deletion
56 -- Through FNDLOADER
57 PROCEDURE DELETE_ROW (
58 X_BASE_APPLICATION_ID IN NUMBER ,
59 X_PROFILE_OPTION_ID IN NUMBER ,
60 X_PROFILE_OPTION_NAME IN VARCHAR2 ,
61 X_APPLICATION_ID IN NUMBER
62 ) IS
63
64 BEGIN
65 null;
66 END DELETE_ROW;
67
68 END JTM_FND_PROFILE_OPTION_ACC_PKG;