1 PACKAGE JTF_EXCEPTIONS_PKG AUTHID CURRENT_USER AS
2 /* $Header: jtfvtves.pls 115.1 2000/02/16 16:36:01 pkm ship $ */
3
4
5 PROCEDURE Insert_Row(
6 x_Rowid IN OUT VARCHAR2,
7 x_EXCEPTIONS_ID IN OUT NUMBER,
8 x_LAST_UPDATE_DATE IN DATE,
9 x_LAST_UPDATED_BY IN NUMBER,
10 x_CREATION_DATE IN DATE,
11 x_CREATED_BY IN NUMBER,
12 x_LAST_UPDATE_LOGIN IN NUMBER,
13 x_TERR_ID IN NUMBER,
14 x_RESOURCE_ID IN NUMBER,
15 x_CUSTOMER_ID IN NUMBER,
16 x_ADDRESS_ID IN NUMBER,
17 x_LEAD_ID IN NUMBER,
18 x_OPPORTUNITY_ID IN NUMBER,
19 x_ORG_ID IN NUMBER);
20
21
22
23 PROCEDURE Lock_Row(
24 x_Rowid IN VARCHAR2,
25 x_EXCEPTIONS_ID IN NUMBER,
26 x_LAST_UPDATE_DATE IN DATE,
27 x_LAST_UPDATED_BY IN NUMBER,
28 x_CREATION_DATE IN DATE,
29 x_CREATED_BY IN NUMBER,
30 x_LAST_UPDATE_LOGIN IN NUMBER,
31 x_TERR_ID IN NUMBER,
32 x_RESOURCE_ID IN NUMBER,
33 x_CUSTOMER_ID IN NUMBER,
34 x_ADDRESS_ID IN NUMBER,
35 x_LEAD_ID IN NUMBER,
36 x_OPPORTUNITY_ID IN NUMBER,
37 x_ORG_ID IN NUMBER);
38
39
40
41 PROCEDURE Update_Row(
42 x_Rowid IN VARCHAR2,
43 x_EXCEPTIONS_ID IN NUMBER,
44 x_LAST_UPDATE_DATE IN DATE,
45 x_LAST_UPDATED_BY IN NUMBER,
46 x_CREATION_DATE IN DATE,
47 x_CREATED_BY IN NUMBER,
48 x_LAST_UPDATE_LOGIN IN NUMBER,
49 x_TERR_ID IN NUMBER,
50 x_RESOURCE_ID IN NUMBER,
51 x_CUSTOMER_ID IN NUMBER,
52 x_ADDRESS_ID IN NUMBER,
53 x_LEAD_ID IN NUMBER,
54 x_OPPORTUNITY_ID IN NUMBER,
55 x_ORG_ID IN NUMBER);
56
57
58
59 PROCEDURE Delete_Row( x_EXCEPTIONS_ID IN NUMBER);
60
61 END JTF_EXCEPTIONS_PKG;