APPS.IMC_THREE_SIXTY_SSM_QUERY_PKG dependencies on IMC_THREE_SIXTY_SSM_QUERY

Line 1: package body IMC_THREE_SIXTY_SSM_QUERY_PKG as

1: package body IMC_THREE_SIXTY_SSM_QUERY_PKG as
2: /* $Header: ARHTSSQB.pls 120.0 2005/05/25 22:00:28 achung noship $ */
3:
4: procedure INSERT_ROW (
5: X_SSM_QUERY_ID in out NOCOPY NUMBER,

Line 15: CURSOR C2 IS SELECT IMC_THREE_SIXTY_SSM_QUERY_S.nextval FROM sys.dual;

11: X_LAST_UPDATED_BY in NUMBER,
12: X_LAST_UPDATE_LOGIN in NUMBER,
13: X_OBJECT_VERSION_NUMBER in NUMBER
14: ) IS
15: CURSOR C2 IS SELECT IMC_THREE_SIXTY_SSM_QUERY_S.nextval FROM sys.dual;
16: begin
17: IF ( X_SSM_QUERY_ID IS NULL) OR (X_SSM_QUERY_ID = FND_API.G_MISS_NUM) THEN
18: OPEN C2;
19: FETCH C2 INTO X_SSM_QUERY_ID;

Line 30: insert into IMC_THREE_SIXTY_SSM_QUERY (

26: CLOSE C2;
27: END IF;
28:
29: begin
30: insert into IMC_THREE_SIXTY_SSM_QUERY (
31: SSM_QUERY_ID,
32: APPLICATION_ID,
33: SSM_QUERY_STRING,
34: CREATION_DATE ,

Line 69: from IMC_THREE_SIXTY_SSM_QUERY

65: cursor c is select
66: APPLICATION_ID,
67: SSM_QUERY_STRING,
68: OBJECT_VERSION_NUMBER
69: from IMC_THREE_SIXTY_SSM_QUERY
70: where SSM_QUERY_ID = X_SSM_QUERY_ID
71: for update of SSM_QUERY_ID nowait;
72: recinfo c%rowtype;
73:

Line 108: update IMC_THREE_SIXTY_SSM_QUERY set

104: X_OBJECT_VERSION_NUMBER in NUMBER
105: ) is
106:
107: begin
108: update IMC_THREE_SIXTY_SSM_QUERY set
109: APPLICATION_ID = X_APPLICATION_ID,
110: SSM_QUERY_STRING = X_SSM_QUERY_STRING,
111: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
112: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 127: delete from IMC_THREE_SIXTY_SSM_QUERY

123: procedure DELETE_ROW (
124: X_SSM_QUERY_ID in NUMBER
125: ) is
126: begin
127: delete from IMC_THREE_SIXTY_SSM_QUERY
128: where SSM_QUERY_ID = X_SSM_QUERY_ID;
129:
130: if (sql%notfound) then
131: raise no_data_found;

Line 161: IMC_THREE_SIXTY_SSM_QUERY_PKG.UPDATE_ROW (

157: end if;
158:
159: L_OBJECT_VERSION_NUMBER := NVL(X_OBJECT_VERSION_NUMBER, 1) + 1;
160:
161: IMC_THREE_SIXTY_SSM_QUERY_PKG.UPDATE_ROW (
162: X_SSM_QUERY_ID => X_SSM_QUERY_ID,
163: X_APPLICATION_ID => X_APPLICATION_ID,
164: X_SSM_QUERY_STRING => X_SSM_QUERY_STRING,
165: X_LAST_UPDATE_DATE => sysdate,

Line 173: IMC_THREE_SIXTY_SSM_QUERY_PKG.INSERT_ROW (

169:
170: exception
171: when NO_DATA_FOUND then
172:
173: IMC_THREE_SIXTY_SSM_QUERY_PKG.INSERT_ROW (
174: X_SSM_QUERY_ID => L_SSM_QUERY_ID,
175: X_APPLICATION_ID => X_APPLICATION_ID,
176: X_SSM_QUERY_STRING => X_SSM_QUERY_STRING,
177: X_CREATION_DATE => sysdate,

Line 187: end IMC_THREE_SIXTY_SSM_QUERY_PKG;

183:
184: end ;
185: end LOAD_ROW;
186:
187: end IMC_THREE_SIXTY_SSM_QUERY_PKG;