APPS.IMC_THREE_SIXTY_PARAMS_PKG dependencies on IMC_THREE_SIXTY_PARAMS

Line 1: package body IMC_THREE_SIXTY_PARAMS_PKG as

1: package body IMC_THREE_SIXTY_PARAMS_PKG as
2: /* $Header: ARHTSPMB.pls 120.0 2005/05/25 22:00:22 achung noship $ */
3:
4: procedure INSERT_ROW (
5: X_QUERY_ID in NUMBER,

Line 22: insert into IMC_THREE_SIXTY_PARAMS (

18: begin
19: dbms_output.put_line('In begin of insert_row : query_id is ' ||to_char(X_QUERY_ID));
20: dbms_output.put_line('In begin of insert_row : ssm_query_id is ' ||to_char(X_SSM_QUERY_ID));
21:
22: insert into IMC_THREE_SIXTY_PARAMS (
23: QUERY_ID,
24: APPLICATION_ID,
25: SSM_QUERY_ID,
26: PARAM_POSITION,

Line 68: from IMC_THREE_SIXTY_PARAMS

64: APPLICATION_ID,
65: PARAM_POSITION,
66: PARAM_NAME,
67: OBJECT_VERSION_NUMBER
68: from IMC_THREE_SIXTY_PARAMS
69: where QUERY_ID = X_QUERY_ID
70: or SSM_QUERY_ID = X_SSM_QUERY_ID
71: and PARAM_NAME = X_PARAM_NAME
72: for update of PARAM_POSITION nowait;

Line 112: update IMC_THREE_SIXTY_PARAMS set

108: X_LAST_UPDATE_LOGIN in NUMBER,
109: X_OBJECT_VERSION_NUMBER in NUMBER) is
110:
111: begin
112: update IMC_THREE_SIXTY_PARAMS set
113: APPLICATION_ID = X_APPLICATION_ID,
114: PARAM_NAME = X_PARAM_NAME,
115: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
116: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 135: delete from IMC_THREE_SIXTY_PARAMS

131: X_SSM_QUERY_ID in NUMBER,
132: X_PARAM_POSITION in NUMBER
133: ) is
134: begin
135: delete from IMC_THREE_SIXTY_PARAMS
136: where NVL( QUERY_ID,0) = NVL(X_QUERY_ID,0)
137: and NVL(SSM_QUERY_ID,0) = NVL(X_SSM_QUERY_ID,0)
138: and PARAM_POSITION = X_PARAM_POSITION;
139:

Line 176: IMC_THREE_SIXTY_PARAMS_PKG.UPDATE_ROW (

172: dbms_output.put_line('In begin of load_row : ssm_query_id is ' ||to_char(X_SSM_QUERY_ID));
173:
174: L_OBJECT_VERSION_NUMBER := NVL(X_OBJECT_VERSION_NUMBER, 1) + 1;
175:
176: IMC_THREE_SIXTY_PARAMS_PKG.UPDATE_ROW (
177: X_QUERY_ID => X_QUERY_ID,
178: X_APPLICATION_ID => X_APPLICATION_ID,
179: X_SSM_QUERY_ID => X_SSM_QUERY_ID,
180: X_PARAM_POSITION => X_PARAM_POSITION,

Line 190: IMC_THREE_SIXTY_PARAMS_PKG.INSERT_ROW (

186:
187: exception
188: when NO_DATA_FOUND then
189:
190: IMC_THREE_SIXTY_PARAMS_PKG.INSERT_ROW (
191: X_QUERY_ID => L_QUERY_ID,
192: X_APPLICATION_ID => X_APPLICATION_ID,
193: X_SSM_QUERY_ID => X_SSM_QUERY_ID,
194: X_PARAM_POSITION => X_PARAM_POSITION,

Line 206: end IMC_THREE_SIXTY_PARAMS_PKG;

202:
203: end ;
204: end LOAD_ROW;
205:
206: end IMC_THREE_SIXTY_PARAMS_PKG;