1 PACKAGE AML_INTERACTION_LEADS_PKG AUTHID CURRENT_USER AS
2 /* #$Header: amltitls.pls 115.1 2003/09/18 17:25:16 solin ship $ */
3
4 PROCEDURE INSERT_ROW (
5 px_INTERACTION_LEAD_ID IN OUT NOCOPY NUMBER,
6 p_INTERACTION_ID IN NUMBER,
7 p_IMPORT_INTERFACE_ID IN NUMBER,
8 p_SALES_LEAD_ID IN NUMBER,
9 p_CREATION_DATE IN DATE,
10 p_CREATED_BY IN NUMBER,
11 p_LAST_UPDATE_DATE IN DATE,
12 p_LAST_UPDATED_BY IN NUMBER,
13 p_LAST_UPDATE_LOGIN IN NUMBER,
14 p_REQUEST_ID IN NUMBER,
15 p_PROGRAM_APPLICATION_ID IN NUMBER,
16 p_PROGRAM_ID IN NUMBER,
17 p_PROGRAM_UPDATE_DATE IN DATE,
18 p_OBJECT_VERSION_NUMBER IN NUMBER,
19 p_SCORE IN NUMBER);
20
21 PROCEDURE UPDATE_ROW (
22 p_INTERACTION_LEAD_ID IN NUMBER,
23 p_INTERACTION_ID IN NUMBER,
24 p_IMPORT_INTERFACE_ID IN NUMBER,
25 p_SALES_LEAD_ID IN NUMBER,
26 p_CREATION_DATE IN DATE,
27 p_CREATED_BY IN NUMBER,
28 p_LAST_UPDATE_DATE IN DATE,
29 p_LAST_UPDATED_BY IN NUMBER,
30 p_LAST_UPDATE_LOGIN IN NUMBER,
31 p_REQUEST_ID IN NUMBER,
32 p_PROGRAM_APPLICATION_ID IN NUMBER,
33 p_PROGRAM_ID IN NUMBER,
34 p_PROGRAM_UPDATE_DATE IN DATE,
35 p_OBJECT_VERSION_NUMBER IN NUMBER,
36 p_SCORE IN NUMBER);
37
38 PROCEDURE DELETE_ROW (
39 p_INTERACTION_LEAD_ID IN NUMBER
40 );
41
42 PROCEDURE LOCK_ROW (
43 p_INTERACTION_LEAD_ID IN NUMBER,
44 p_INTERACTION_ID IN NUMBER,
45 p_IMPORT_INTERFACE_ID IN NUMBER,
46 p_SALES_LEAD_ID IN NUMBER,
47 p_SCORE IN NUMBER);
48
49 END AML_INTERACTION_LEADS_PKG;