15: X_OBJECT_VERSION_NUMBER in NUMBER)
16: IS
17:
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,
16: IS
17:
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,
167: if (X_OWNER = 'SEED') then
168: user_id := 1;
169: end if;
170:
171: dbms_output.put_line('In begin of load_row : query_id is ' ||to_char(X_QUERY_ID));
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:
168: user_id := 1;
169: end if;
170:
171: dbms_output.put_line('In begin of load_row : query_id is ' ||to_char(X_QUERY_ID));
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 (