1 PACKAGE JTF_TERR_RSC_ACCESS_PKG AS
2 /* $Header: jtfvrsas.pls 120.2 2005/09/08 17:54:44 applrt ship $ */
3 -- 02/22/00 JDOCHERT Passing in ORG_ID to Insert/Update/Lock
4 -- 09/01/05 mhtran passing trans_access_code to Insert/Update for R12
5
6 PROCEDURE Insert_Row(
7 x_Rowid IN OUT NOCOPY VARCHAR2,
8 x_TERR_RSC_ACCESS_ID IN OUT NOCOPY NUMBER,
9 x_LAST_UPDATE_DATE IN DATE,
10 x_LAST_UPDATED_BY IN NUMBER,
11 x_CREATION_DATE IN DATE,
12 x_CREATED_BY IN NUMBER,
13 x_LAST_UPDATE_LOGIN IN NUMBER,
14 x_TERR_RSC_ID IN NUMBER,
15 x_ACCESS_TYPE IN VARCHAR2,
16 x_TRANS_ACCESS_CODE IN VARCHAR2,
17 x_ORG_ID IN NUMBER);
18
19
20
21 PROCEDURE Lock_Row(
22 x_Rowid IN VARCHAR2,
23 x_TERR_RSC_ACCESS_ID IN NUMBER,
24 x_LAST_UPDATE_DATE IN DATE,
25 x_LAST_UPDATED_BY IN NUMBER,
26 x_CREATION_DATE IN DATE,
27 x_CREATED_BY IN NUMBER,
28 x_LAST_UPDATE_LOGIN IN NUMBER,
29 x_TERR_RSC_ID IN NUMBER,
30 x_ACCESS_TYPE IN VARCHAR2,
31 x_TRANS_ACCESS_CODE IN VARCHAR2,
32 x_ORG_ID IN NUMBER);
33
34
35
36 PROCEDURE Update_Row(
37 x_Rowid IN VARCHAR2,
38 x_TERR_RSC_ACCESS_ID IN NUMBER,
39 x_LAST_UPDATE_DATE IN DATE,
40 x_LAST_UPDATED_BY IN NUMBER,
41 x_CREATION_DATE IN DATE,
42 x_CREATED_BY IN NUMBER,
43 x_LAST_UPDATE_LOGIN IN NUMBER,
44 x_TERR_RSC_ID IN NUMBER,
45 x_ACCESS_TYPE IN VARCHAR2,
46 x_TRANS_ACCESS_CODE IN VARCHAR2,
47 x_ORG_ID IN NUMBER);
48
49
50
51 PROCEDURE Delete_Row( x_TERR_RSC_ACCESS_ID IN NUMBER);
52
53 END JTF_TERR_RSC_ACCESS_PKG;