APPS.IMC_THREE_SIXTY_QUERY_MAP_PKG dependencies on IMC_THREE_SIXTY_SSM_QUERY_MAP

Line 20: insert into IMC_THREE_SIXTY_SSM_QUERY_MAP (

16: ) IS
17:
18: begin
19:
20: insert into IMC_THREE_SIXTY_SSM_QUERY_MAP (
21: QUERY_ID,
22: APPLICATION_ID,
23: SSM_QUERY_ID ,
24: PARAM_SOURCE ,

Line 67: from IMC_THREE_SIXTY_SSM_QUERY_MAP

63: APPLICATION_ID,
64: PARAM_SOURCE,
65: PARAM_POSITION,
66: OBJECT_VERSION_NUMBER
67: from IMC_THREE_SIXTY_SSM_QUERY_MAP
68: where QUERY_ID = X_QUERY_ID
69: for update of QUERY_ID nowait;
70: recinfo c%rowtype;
71:

Line 110: update IMC_THREE_SIXTY_SSM_QUERY_MAP set

106: X_OBJECT_VERSION_NUMBER in NUMBER
107: ) is
108:
109: begin
110: update IMC_THREE_SIXTY_SSM_QUERY_MAP set
111: APPLICATION_ID = X_APPLICATION_ID,
112: PARAM_SOURCE = X_PARAM_SOURCE,
113: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
114: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 131: delete from IMC_THREE_SIXTY_SSM_QUERY_MAP

127: procedure DELETE_ROW (
128: X_QUERY_ID in NUMBER
129: ) is
130: begin
131: delete from IMC_THREE_SIXTY_SSM_QUERY_MAP
132: where QUERY_ID = X_QUERY_ID;
133:
134: if (sql%notfound) then
135: raise no_data_found;