Line 500: SELECT Sysdate INTO l_sysdate FROM dual;
496: BEGIN
497: IF (x_owner = 'SEED') THEN
498: l_user_id := 1;
499: END IF; 500: SELECT Sysdate INTO l_sysdate FROM dual; 501: --
502: IF (x_organization_code = '-1') THEN
503: l_organization_id := -1;
504: ELSE
Line 550: SELECT wms_strategies_s.NEXTVAL INTO l_strategy_id FROM dual;
546: );
547: EXCEPTION
548: WHEN no_data_found THEN
549: IF (l_strategy_id IS NULL) THEN 550: SELECT wms_strategies_s.NEXTVAL INTO l_strategy_id FROM dual; 551: END IF;
552: wms_strategies_pkg.insert_row
553: (
554: X_ROWID => l_row_id
[Home] [Help]