APPS.AMS_QUERY_PURP_ASSOC_PKG dependencies on AMS_QUERY_TEMP_PURPOSE_ASSOC_S

Line 86: update AMS_QUERY_TEMP_PURPOSE_ASSOC set

82: X_LAST_UPDATED_BY in NUMBER,
83: X_LAST_UPDATE_LOGIN in NUMBER
84: ) is
85: begin
86: update AMS_QUERY_TEMP_PURPOSE_ASSOC set
87: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
88: REQUEST_ID = X_REQUEST_ID,
89: QUERY_TEMPLATE_ID = X_QUERY_TEMPLATE_ID,
90: PURPOSE_CODE = X_PURPOSE_CODE,

Line 143: SELECT AMS_QUERY_TEMP_PURPOSE_ASSOC_s.NEXTVAL

139: FROM AMS_QUERY_TEMP_PURPOSE_ASSOC
140: WHERE TEMP_PURPOSE_ASSOC_ID = x_TEMP_PURPOSE_ASSOC_ID;
141:
142: CURSOR c_get_id is
143: SELECT AMS_QUERY_TEMP_PURPOSE_ASSOC_s.NEXTVAL
144: FROM DUAL;
145: BEGIN
146: if X_OWNER = 'SEED' then
147: l_user_id := 1;