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