APPS.ASO_TERRITORY_ACCESSES_PKG dependencies on ASO_TERRITORY_ACCESSES

Line 1: PACKAGE BODY ASO_TERRITORY_ACCESSES_PKG AS

1: PACKAGE BODY ASO_TERRITORY_ACCESSES_PKG AS
2: /* $Header: asottacb.pls 120.0 2005/08/30 00:01:48 gsachdev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_TERRITORY_ACCESSES_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asottacb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_TERRITORY_ACCESSES_PKG';

1: PACKAGE BODY ASO_TERRITORY_ACCESSES_PKG AS
2: /* $Header: asottacb.pls 120.0 2005/08/30 00:01:48 gsachdev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_TERRITORY_ACCESSES_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asottacb.pls';
6:
7: procedure INSERT_ROW (
8: P_ACCESS_ID IN NUMBER,

Line 24: insert into ASO_TERRITORY_ACCESSES (

20: )
21: IS
22:
23: BEGIN
24: insert into ASO_TERRITORY_ACCESSES (
25: ACCESS_ID,
26: TERRITORY_ID,
27: LAST_UPDATE_DATE,
28: LAST_UPDATED_BY,

Line 70: update ASO_TERRITORY_ACCESSES

66: P_PROGRAM_UPDATE_DATE IN DATE,
67: P_CONC_REQUEST_ID IN NUMBER)
68: IS
69: BEGIN
70: update ASO_TERRITORY_ACCESSES
71: set
72: ACCESS_ID = decode( P_ACCESS_ID, FND_API.G_MISS_NUM, ACCESS_ID, P_ACCESS_ID),
73: TERRITORY_ID = decode( P_TERRITORY_ID, FND_API.G_MISS_NUM, TERRITORY_ID, P_TERRITORY_ID),
74: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 96: delete from ASO_TERRITORY_ACCESSES

92: P_ACCESS_ID IN NUMBER,
93: P_TERRITORY_ID IN NUMBER
94: ) is
95: begin
96: delete from ASO_TERRITORY_ACCESSES
97: where ACCESS_ID = P_ACCESS_ID
98: and TERRITORY_ID = P_TERRITORY_ID;
99:
100: if (sql%notfound) then

Line 133: from ASO_TERRITORY_ACCESSES

129: PROGRAM_APPLICATION_ID,
130: PROGRAM_ID,
131: PROGRAM_UPDATE_DATE,
132: CONC_REQUEST_ID
133: from ASO_TERRITORY_ACCESSES
134: where ACCESS_ID = P_ACCESS_ID
135: and TERRITORY_ID = P_TERRITORY_ID
136: for update of CONC_REQUEST_ID nowait;
137:

Line 160: end ASO_TERRITORY_ACCESSES_PKG;

156: app_exception.raise_exception;
157: end if;
158: end LOCK_ROW;
159:
160: end ASO_TERRITORY_ACCESSES_PKG;