1 PACKAGE ASO_CHANGED_QUOTES_PKG AUTHID CURRENT_USER AS
2 /* $Header: asotcqts.pls 120.0 2005/08/29 23:52:54 gsachdev noship $ */
3
4 procedure INSERT_ROW (
5 P_QUOTE_NUMBER IN NUMBER,
6 P_LAST_UPDATE_DATE IN DATE,
7 P_LAST_UPDATED_BY IN NUMBER,
8 P_CREATION_DATE IN DATE,
9 P_CREATED_BY IN NUMBER,
10 P_LAST_UPDATE_LOGIN IN NUMBER,
11 P_REQUEST_ID IN NUMBER,
12 P_PROGRAM_APPLICATION_ID IN NUMBER,
13 P_PROGRAM_ID IN NUMBER,
14 P_PROGRAM_UPDATE_DATE IN DATE,
15 P_CONC_REQUEST_ID IN NUMBER
16 );
17
18
19 procedure UPDATE_ROW (
20 P_QUOTE_NUMBER IN NUMBER,
21 P_LAST_UPDATE_DATE IN DATE,
22 P_LAST_UPDATED_BY IN NUMBER,
23 P_CREATION_DATE IN DATE,
24 P_CREATED_BY IN NUMBER,
25 P_LAST_UPDATE_LOGIN IN NUMBER,
26 P_REQUEST_ID IN NUMBER,
27 P_PROGRAM_APPLICATION_ID IN NUMBER,
28 P_PROGRAM_ID IN NUMBER,
29 P_PROGRAM_UPDATE_DATE IN DATE,
30 P_CONC_REQUEST_ID IN NUMBER
31 );
32
33
34 procedure DELETE_ROW (
35 P_QUOTE_NUMBER IN NUMBER,
36 P_CONC_REQUEST_ID IN NUMBER
37 );
38
39
40 procedure LOCK_ROW (
41 P_QUOTE_NUMBER IN NUMBER,
42 P_LAST_UPDATE_DATE IN DATE,
43 P_LAST_UPDATED_BY IN NUMBER,
44 P_CREATION_DATE IN DATE,
45 P_CREATED_BY IN NUMBER,
46 P_LAST_UPDATE_LOGIN IN NUMBER,
47 P_REQUEST_ID IN NUMBER,
48 P_PROGRAM_APPLICATION_ID IN NUMBER,
49 P_PROGRAM_ID IN NUMBER,
50 P_PROGRAM_UPDATE_DATE IN DATE,
51 P_CONC_REQUEST_ID IN NUMBER
52 );
53
54 END ASO_CHANGED_QUOTES_PKG;